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
Many students in class ask, “Is it possible for Tableau Reader to show the detailed data using View Data functionality available in Tableau Desktop?” The answer is no, this feature is not available in Tableau Reader.
However, while you can’t use View Data in Tableau Reader, you can
Read the rest of this entry »
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 »
We have several presentations and a book release in the the month of April!
We will be at the SAS Global Forum author party Monday afternoon, April 12th. “SAS for Dummies” is being released today, April 5th. I will be at the author party at the SGF conference with Chris Hemedinger (co-author) meeting other authors and SAS conference attendees.
On April 14th at 9 AM, at SAS Global Forum in Seattle, “The Future of Marketing Analytics with SAS Enterprise Guide“.
On April 14th, we are also
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
Which “green” activities are consumers performing in their everyday lives?
Activities that-
Stephen Few has has been an inspiration to us through the years. He has patiently prodded software companies to improve their tools for visual presentation of information, motivated by the sincere hope to improve the world we all live in.
At Freakalytics, we incorporate his content
Read the rest of this entry »
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 »
Practical tips for quickly building and maintaining these data insight tools Read the rest of this entry »
Tuesday, March 2, 2010- 2:00 PM Eastern Time / 11:00 AM Pacific Time
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 »
Number 6
Waterfall chart examples with detailed instructions on creating them with your own data in Tableau
Waterfall Chart in Tableau and a Superior Alternative…
Number 5
Do your New Year’s resolutions have you wondering where your money goes? Here’s a snapshot of the average American and their spending habits
How the average American spends their income
Number 4
Trying to figure out how to share customer segmentation and lifetime value insights with your business team?
Customer Segmentation and Lifetime Value Analysis
Number 3
Where’s all that oil money going? Which countries are very dependent on oil imports? Which countries have so much oil their citizens will never need to work?
Visual Metrics to Inform: Petro-Wealth Importance by Region and Country
Number 2
A shocker at number 2 since this post is several years old, a testament to the popularity of SAS and the power of SAS Enterprise Guide,
The Joy of SAS Enterprise Guide
Number 1
And, the top blog post with props to Ellie Fields and Chris Stolte at Tableau for their strong editorial review and support, a 100 year dashboard of S&P stock returns and the historic investing environment S&P Composite Stock Market Returns Dashboard
Wishing all of you a happy, successful 2010! Thanks to our many customers and readers for all of your support! Finally, a special thanks to all of our friends at Tableau Software and SAS!
Add Your Comment Here
Follow Freakalytics on Twitter
RSS for Freakalytics.com
RSS for new course registration alerts
