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 »
I read with fascination that this visualization won the Sunlight Foundation’s $5,000 prize for “Best Visualization Using Data about US Spending”.
Read the rest of this entry »
This graphic is
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 »
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 »
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-
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 »
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 HereThis was presented at the Tableau Conference 2009. It is about the tremendous opportunities to leverage customer segmentation and lifetime value data at the individual customer level. Click here for the presentation.
Identifying segments for every customer can unlock long-hidden value for your marketing team. Combining this information with Tableau creates a simple means for marketing owners to evaluate and improve their decisions.
A second opportunity is adding lifetime value estimates to each customer as you acquire them and as their behavior adds additional information to inform their value. With lifetime value estimates, you will gain a huge competitive advantage in evaluating your the long-term value of your marketing investments and product decisions. Are your most expensive programs just impacting short-term outcomes and only reaching lower value customers? How are your customers being affected by a blend of marketing programs over time?
Click here to see a summary view on Tableau Public which was constructed from part of the Tableau workbook used in this presentation. Many thanks to Ellie Fields at Tableau for selecting the views and publishing this summary!
→ 1 Comment- Add YoursIt is frustrating to see valuable information hidden in well-meaning, but uninformative charts. FlowingData.com referenced just such an article, “How The Average U.S. Consumer Spends Their Paycheck“.
The chart in the original article at Visual Economics is indeed attractive. Unfortunately, it is also very hard to understand. Key data relationships that should jump off of the chart are obscured by the donut chart and excessive chart text or “chart junk”.
Here are several accessible and simple ways to present this fascinating data. All of these examples were created with Tableau.
→ 4 Comments- Add YoursThanks for all of your kind comments and wonderful feedback! I will try to get back to as many of you as the last few weeks of writing the book allows!
Visual Data Mining: Finding Patterns and Key Insights in Online Marketing Data
Date/Time: Already Occured- 6/11/2009 Read the rest of this entry »
Presented by: American Marketing Association
Sponsored by: Tableau Software
Executive Summary
Which “green” activities are consumers performing in their everyday lives? Activities that-
• Save them money?
• Are easy to do?
• Are the most beneficial to the environment?
• Some combination of the three?
By combining insights from a recent survey of consumer behavior with expert opinion on green activities I found that:
• Activities that experts rank as the most beneficial for the environment are not always performed frequently by consumers.
• Economic benefit to the consumer is a stronger predictor of frequently-performed activities than environmental benefit.
• However, convenience to the consumer is the best predictor of green behavior!
Decision-makers for sustainability programs can tailor this method to their particular location by:
• Compiling a list of green activities specific to their region.
• Surveying local consumers and experts.
• Altering which dimensions are included in assessing the importance of various green activities.
“Newcomer” communities can maximize the impact of launching their green programs by:
• Prioritizing activities that are convenient and economical for the consumer.
• Motivating consumers with educational programs and incentives.
• Waiting until the environmental program has gotten off the ground before encouraging activities that are low in convenience and economic benefit- unless they can be financially subsidized.
Newcomer Communities
Read the rest of this entry »
→ 1 Comment- Add Yours
Follow Freakalytics on Twitter
RSS for Freakalytics.com
RSS for new course registration alerts
