Freakalytics™Rapid Analytics to Explore, Understand, Communicate & Act |
|
Time magazine recently published a map of state budget shortfalls for 2011 by state. While this was a good attempt, I thought it would be informative to show this data in Tableau to offer additional insight. The image of Time’s map is not as clear as a regular scanned image since I used my iPhone- taking the photo on a flight!
There are three primary areas for improvement
Read the rest of this entry »
From datadoodle,
So many people who should know better seem to miss the point when they mention Tableau. Why? I asked BI veteran Stephen McDaniel for his thoughts — which he gave, but then went on to suggest an almost unheard of challenge: a data analysis face-off among vendors
Read the rest of this entry »
This dashboard provides a comparison of per student spending with performance on the SAT exam based on the 2009 New Jersey Report Card data. DFGs are based on economic and demographic data. These are assigned by the New Jersey State Department of Education.
This work was created in collaboration with Bob Morrison of Quadrant Arts Education Research. Bob has extensive experience with helping school systems measure educational results related to how and where funds are spent. I have a great admiration for Bob as a passionate advocate for growing both music and arts education. Bob has expertise in advocating on behalf of students around the many ways that music and arts education can engage students and improve their academic performance. Read the rest of this entry »
Dashboards developed for clients frequently incorporate maps. Tableau offers quick, simple yet insightful mapping capabilities out of the box.
I have noticed that many maps used in my client’s dashboards attempt to display continuous measures. Examples include sales in the past quarter, year to date expenses versus budget or number of open sales opportunities. All of these metrics have shared issues in maps- a small range of the metric may be the dominant value in the display, making it difficult to differentiate amongst the values on the map.
In this post, I will review some common and novel approaches to mapping this type of metric.
Read the rest of this entry and view the maps and dashboards
Add Your Comment Here
This dashboard, a Customer Sales Dashboard for a boutique winery, offers one strategic view of key questions asked by winery management. Information such as amount of sales attributed to various marketing programs, estimated profits by customer segment and number of customers acquired during each of the last four years is displayed.
Using a series of cascading filters based on key customer attributes
Read the rest of this entry and view the dashboard
Add Your Comment Here
The “Simple Business Dashboard Design Strategies” presentation can be downloaded here. I am presenting this presentation today at 4 PM Pacific on Stacey Barr’s Measure and More Webinar.
The dashboard example in this presentation is available below.
Read the rest of this entry »
The setup
You have connected to more than one data source in your Tableau workbook, for example, your sales database in Oracle and a customer call database in SQL Server. Tableau seamlessly allows you to connect to multiple data sources in one workbook. Views developed from both data sources can be placed in a single dashboard.
However, if you try to use global filters or quick filters to synchronize the two data sources, you will find that it isn’t possible; only one data source can be linked to either. In fact, the term “Global” filter in Tableau can be confounding, since it is only global to views using the current data source. Global filters will not work with other data sources even if the data items have the same name!
The solution Read the rest of this entry »
As of Tableau 5.0 (released in 2009), a new feature
Read the rest of this entry »
Inspired by a post at Flowing Data, I present three visuals that demonstrate how the Physicians Committee for Responsible Medicine could improve the presentation of this vital information. I personally found it shocking that US agricultural subsidies were so small
Which “green” activities are consumers performing in their everyday lives?
Activities that-
Win a great trip to San Francisco to attend the Web 2.0 conference and be featured on the Tableau Public home page and Read Write Web! Enter the Tableau Visualization Contest!
No matter what happens, you will have your own copy of tableau public to use as long as you like, which includes free hosting of your content to share with the world on your web site!
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.
For practical, tested in the trenches advice on creating great dashboards for marketing programs, view Stephen’s Dashboard Nirvana webinar.
In this case study, we used customer demographic and sales databases from a boutique winery in combination with Tableau Software
Read the rest of this entry »
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 the rest of this entry »
Economic Indicators and S&P Composite Returns from 1901-2008
A Dashboard to Explore Past, Present and Future Results by Year
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 your mouse across data points of interest.
“
” Read the rest of this entry »
Selecting the right metrics can be difficult but is a vital step to improve insight. Frequently, tradition dictates which metrics people are accustomed to receiving for a particular subject. However, these metrics could leave out vital pieces of information making the standard metrics potentially misleading. For example, many stock market discussions ignore or minimize the impact of inflation on historic returns. To understand the stock market over extended time periods, inflation can severely skew interpretation as inflation has varied widely over the past 100 years in the US.
Follow Freakalytics on Twitter
RSS for Freakalytics.com
RSS for new course registration alerts
