Dashboard Nirvana and Visual Management of Marketing Programs

View and interact with the strategic customer sales and analyst exploratory dashboards below, both hosted by tableau public.

Read Eileen’s white paper, “Visual Management of Marketing Programs“, for detailed explanations on maximizing Marketing ROI with visual marketing dashboards.

In this case study, we used customer demographic and sales databases from a boutique winery in combination with Tableau Software

Read more

tableau public — share your visual insights with the world!

tableau public is now available! What’s not to love? Free web hosting of your visualization and a free desktop license of tableau public, based on the award-winning, rapid data visualization tools in Tableau Desktop and Tableau Server. With tableau public, you can learn the breadth of Tableau while sharing your insights with the world on any blog or web site.
 
Freakalytics is excited to be featured on the home page of tableau public, highlighting our stock market returns dashboard!
 

Click here to read the details about this dashboard, from our blog post last June.

Embedding tableau public content is simple and quick. Your web site visitors will need NO software installation, since Tableau depends on native Ajax functionality used by sites like GMail. Although not officially supported in the current release, tableau public is viewable and functions interactively on the iPhone based on our simple tests!

On your Tableau journey, consider…

Read more

S&P Composite Stock Market Returns Dashboard

Finance-SnP-stock-market-returns-100-yearsEconomic Indicators and S&P Composite Returns
from 1901-2008
A Dashboard to Explore Past, Present and Future Results

When creating a dashboard, two critical questions to ask include, “what are the right metrics” and “what collection of graphs will optimize exploration and understanding from a complex relationship between multiple metrics”? This example uses historic economic and stock market data to explore these concepts and to provide powerful insights into stock market patterns relative to economic conditions. This interactive dashboard is powered by tableau public, a new service of Tableau Software. One means of interacting with this dashboard is data point brushing, highlight data in a part of the dashboard by single-clicking and dragging

Read more

Data warehousing success- 100% Vision / 80% Tactical / 20% of the Work

My Background in Data Warehousing

I have been involved in the creation, development, and maintenance of seven data warehouses through the years- one of them before I even knew about the term “data warehousing”!   I have built them with SAS and Oracle, SAS alone, Informatica and Oracle, Oracle alone, and SQL Server.

I have also visited many companies as an adviser, consultant and user of their data warehouse. In these many visits, I have seen some successes and many failures. Often, the failures could have been prevented with some key guiding principles.

Data Warehousing or Enterprise Data Integration?

Data warehousing is now known by a new buzz word, Enterprise Data Integration. In fact, SAS recently renamed SAS ETL Studio as SAS Data Integration Studio (they also added some new features around the EDI area, one new feature was around continual data acquisition so that near real time data feeds are available in the data warehouse.) Another great part of SAS EDI is SAS Data Quality, this should be a consideration throughout the entire process, but I won’t directly comment about data quality in this post. Since most people still use the term data warehousing, so I will keep the popular terminology over the analysts and even SAS.

What Does it Take to Build a Successful Data Warehouse?

Read more

SAS for Dummies

Whether you are a grad student, business analyst, statistician, or even a long time user of SAS software- SAS for Dummies (available at Amazon) offers quick access to a vast survey of practical knowledge using the new and exciting world of SAS 9. If you are using the latest version of SAS Learning Edition (version … Read more