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
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 »
Add Your Comment Here
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 »
→ 2 Comments- Add Yours
Practical tips for quickly building and maintaining these data insight tools
Tuesday, March 2, 2010- 2:00 PM Eastern Time / 11:00 AM Pacific Time
Read the rest of this entry »
Add Your Comment Here
Implement and practice these seven habits to make your work relevant, timely and actionable for the business and your customers!
- Collect, discuss and understand the questions that matter for your customers and business owners. Working with the business, determine how valuable the various questions are and whether they can be acted upon. How much time should be spent on this work? Is it better to take a simple approach and deliver a rapid answer and then revisit it more in-depth? Remember that the first step is the most important step! If you don’t actively engage in this step, you will lose a lot of your time and opportunity to positively impact the business.
- Collect and clean the best available data for the identified questions. Implement a strategy to capture and enrich the analytic data used across multiple projects.
- Explore the data sources to understand high level trends and exceptions. Leverage rapid graphs and simpler analytic methods here…
- Understand key interactions, trends, sources of effect & possible causes. Use clear graphs in a simple, short presentation to explain key findings for business owners.
- Communicate the right amount of information and conclusions in the language of the audience. What matters to them? Don’t be afraid to make recommendations based on your work! Don’t be offended if they don’t follow all of your recommendations, there are many factors beyond your findings that will affect what is implemented. When creating your presentation, apply the 10/20/30 rule of Guy Kawasaki- no more than 10 slides in 20 minutes and no text smaller than 30 point font!
- Collaborate with the business to act on the findings. Seek long-term business opportunities to seamlessly integrate analytics.
- Continue to learn from and listen to the business! The more you listen to the business the more they will listen to you!
As you practice these habits, especially step 1, you will eliminate one of the biggest complaints I hear from analysts- that their work isn’t appreciated or understood often enough in the business. Step 1 is about active listening, understanding context of problems and prioritization. Unfortunately, most analysts and statistical experts have never received any training in this area!
At Freakalytics, we are pleased to offer custom training for your technical and analytic teams. Using a series of short workshops, we can coach your team to better understand, practice and gain confidence in applying these habits. Please contact us for more details.
→ 1 Comment- Add Yours
This 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 Yours