Freakalytics®

Practical Analytics for Better Decisions

Freakalytics™ header image
 
 

Freakalytics Timeline since 2007

Freakalytics_Timeline_Since_2007_Map

Click for the detailed timeline of Freakalytics activities

 

Since 2007, we have traveled 365,000 miles
to help tens of thousands of people via

8 books,
24 conference talks,
47 public trainings,
26 on-site trainings,
5 conference seminars,
15 analytic advisory engagements
and 36 consulting projects.

Click to review our detailed timeline.

Comments Off

Alteryx Inspire 2013 Tableau Talk

0 Picture This

Download the presentation Picture This! Your Data in Tableau.

Watch my big data talk here and download the example workbooks here (requires Tableau 8 to open).

Attending this conference was a great experience. Based on multiple customer discussions at the conference, Alteryx is a great product for personal data integration, data enrichment and predictive analytics. Some amazing things we saw in Alteryx includes upcoming direct integration with the Tableau Data Engine, interactive location mapping to generate demographic profiles in Tableau, support of Revolution R 3.0 and integration with social data API’s including Yelp, Google + and Facebook.

Here is a screenshot of one of the marketing performance dashboards built in Tableau. It was based on data built with Alteryx. Alteryx was used for data integration, data enrichment and predictive modelling of customer likelihood to respond to future coupon offers. Enrichment included fuzzy matching of customer demographics using Alteryx-bundled 3rd party data sources from Experian.

Tableau 8 Dashboard where are we performing well

If you are looking for a great compliment to Tableau, I recommend that you consider Alteryx.

Add Your Comment Here

Groupon madness, estimate your short and long-term profit or loss

It seems that you can’t avoid Groupon in the news lately. Consumers are mad about using Groupon since they can find great deals at often unheard of discounts. Even for customers, there is a often a down-side with reports of customers mobbing unprepared businesses and leaving frustrated or unhappy with the experience.

My review of multiple profit estimates shows that without a high rate of repeat business, your Groupon gains will likely end up as a big loss! However, if you can handle the volume of business and are considering offering Groupon at your business, you should download my spreadsheet to estimate the short and long term profitability of your participation.

1) The example used in the spreadsheet is based on a local restaurant. Their standard entree cost is $32.55 with the Groupon deal offered at $14.79. The fee to Groupon is half of the $14.79, leaving the business with $7.40 to cover $8.90 in marginal food and staff costs.

Read the rest of this entry »

→ 7 Comments- Add Yours

Dashboard tips by example- bar charts as cascading filters

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

Upcoming April presentations and books by Freakalytics

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

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.

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

Webinar – Achieve Marketing Dashboard Nirvana

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

The seven habits of analyst rock stars!

Implement and practice these seven habits to make your work relevant, timely and actionable for the business and your customers!

  1. 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.
  2. 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.
  3. Explore the data sources to understand high level trends and exceptions. Leverage rapid graphs and simpler analytic methods here…
  4. Understand key interactions, trends, sources of effect & possible causes. Use clear graphs in a simple, short presentation to explain key findings for business owners.
  5. 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!
  6. Collaborate with the business to act on the findings. Seek long-term business opportunities to seamlessly integrate analytics.
  7. 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