Posts

5 Takeaways from Tableau

In October, SIGMA Data Scientist, Adam Smith attended Tableau’s coveted conference in New Orleans. Today he shares his biggest takeaways:

1. Mobile is now

One theme across many conference sessions included the importance of creating dashboards that work across screen sizes: desktop, tablet, and mobile. Fortunately, Tableau has a Dashboard Layout tool that allows you to create multiple versions of the same dashboard to optimize the display on different device sizes. Coming in 2019, there will be a default mobile view so that even if a dashboard never had a mobile version created, it will automatically transform into a mobile friendly view. This not only helps with older views but can make it faster to create custom mobile dashboards for your new projects.

2. Natural Language Processing (NLP) is next

Tableau’s mission is to help people see and understand data, but when they say people, they don’t just mean data scientists and spreadsheet wizards, they mean everyone. Even if you’re the type of person who thinks pie chart sounds like a tasty snack, they want to help you. An upcoming version of Tableau will have NLP built right in. This means you can write questions in English like “What are our sales in Q3 2018?” and Tableau will return the data in the best visualization. From there you can add additional text like “in the northeast region” to filter and drill-down or adjust it with the standard Tableau tools.

3. Interactive is best

I was reminded again that we need to make sure our SIGMA dashboards are interactive, flexible, and easy to use. It’s simple to put together a few charts, add a few filters and think you have a great dashboard, but it’s important to put yourself in the end user’s shoes and see what happens when you click on a bar chart (filter actions) and think “how can I make this dashboard work for a lot of people at once (parameters)?”

Here is a dashboard SIGMA created for SIGMA. It outlines work hours for each week and identifies when it gets off balance.

Of course you want to get feedback from your end user, but they may not know how to articulate their experience when it comes to options for interactivity.  Consider giving your dashboard to a colleague who is familiar with Tableau without telling them much about it to get feedback not only about interactivity, but anything else they may notice.  Looking at a dashboard with fresh eyes can help you really make it shine.

4. Who is this dashboard for?

Amid all the deeply technical sessions that I attend, I always try to make room for at least one session on soft skills.  Last year that was Design with the user in mind.  This year I checked out Start at the beginning | Gathering requirements for dream dashboards.  The presenter had lots of great ideas for making sure you’re building what your end user really wants.  Here are my top takeaways:

  1. Find the end user – Make sure you find who will really use your dashboard. Ask them open-ended questions about what they are trying to accomplish.
  2. Do it in their style – Use colors and chart types that work well for them.
  3. 3 x 1 rule – For every three things we do for our audience, we can do one thing for ourselves.
  4. Easter eggs – Put in something that will surprise and wow the user.

5. Fun!

There are hundreds of breakout sessions at Tableau, not to mention the hands-on training, Tableau Doctor, and insightful conversations in the hallways with fellow attendees. But it’s not all work and no play for attendees.  There’s plenty of fun to be had at receptions, mixers, and happy hours, and that’s even before you check out the jazz clubs on Bourbon Street! That is all just prologue to the last night of the conference and the party with 17,000 data nerds: Data Night Out.  This year it was at the Superdome.  We ran out onto the field where the Saints play each Sunday and had a huge, nerdy party.

The Tableau Conference is a great way to stay on top of what’s new and next at Tableau.  If you weren’t able to attend, but would like to learn more, many sessions were recorded and are available for free on the Tableau Conference website. And if you’re really excited, it’s not too early to sign up for 2019 when Tableau Conference returns to Las Vegas.

9 Key Marketing Metrics Every Company Should Measure

When organizations begin to standardize marketing measurements across their sales channels, business units and media, they will better track Brand Equity, Market Share, Marketing ROI, and Product and Customer Profitability.

Here are 9 metrics every marketing organization can be measuring:

  1. Multichannel marketers are tracking the costs to generate traffic to their sites from all possible sources. These often include the costs to complete the transaction, which can include a call center or technical support of the site itself.
  2. Marketing Spending Metrics are often looked at to try to establish the ROI value of incremental spending. Some of the measurements in this area include cost per impression, reach, frequency, share of voice.
  3. Visitor Acquisition KPIs are used to understand the health of the sales funnel. Definitions begin to get very important here – what is a visit, what is the source of the visitor, what is a return visitor, what is a unique visitor, etc. Tracking sources often require the integration of multiple reporting tools – the ad serving provider, the web tracking tools, the ad tracking tools, etc.
  4. Site Effectiveness Measurements look at the conversion effectiveness of the site. The sales funnel is critical here – how efficiently can a visitor be turned into a customer?
  5. Definitions are critical in conversion metrics – especially if the conversions of one channel are to be compared to others. What does a conversion mean? The problem of properly attributing conversions to their sources is common and must be consistent across each channel.
  6. Buyer Metrics includes the frequency of purchases, or the retention rates of customers that can be rolled up to overall market share, brand equity and/or customer lifetime value. The most quoted Buyer Metric is typically the Average Order Value, or the AOV, which is used to understand and compare different groups of buyers.
  7. Revenue — Multichannel and e-commerce marketers track revenue carefully to compare the margin generated from each channel, to determine the value of incremental sales, and to guide pricing and promotion decisions.
  8. Customer Loyalty and Customer Profitability Metrics — Companies use these metrics to understand the value of their individual customers, regardless of which sales outlet they have chosen. Definitions are critical from one channel to the next, and the methodology for the measurement of loyalty and customer-level profitability can vary considerably from company to company, depending upon the purchase dynamics of the product.
  9. Profitability and ROI — Each of these categories of metrics can include components such as:
    • Channel margin
    • Performance compared to a sales target
    • Net Profit
    • Return on Sales
    • Return on Investment
    • Net Present Value (NPV)
    • Return on Marketing Investment (ROMI)

Any one of these metrics are difficult to measure without integrated databases to create definitions across channels. As data tools advance and simplify the process, marketers increasingly have the ability to measure such metrics easily. Today, smart decisions across the marketing organization can and should be commonplace.