3 Tips For More Effective Data Insights

Posted by Sue Nicholls, CPSA Founder & President CMKG | Jul 7, 2015 7:29:25 AM

Data is one of the biggest requirements in category management for moving toward a more strategic, fact-based organization.

Many organizations spend millions of dollars on data and sometimes even more money to mine the data through software and front-end reporting systems.

But then they forget to train their organization on some of the most important things about data.

This is what can lead to misinterpretations and frustrations when using data.

Here are some of the key data sources used in category management: 

  1. Retail point of sale (POS) or scanned sales data
  2. Syndicated data
  3. Consumer panel data
  4. Warehouse / shipment data
  5. Other data sources

Before you start understanding the different data sources available, you need to learn some of the basics when using data. Here are some ways to get started on understanding and using category management data:

  1. Download a great resource to understand data availability: Market Data Availability Grid
  2. Check out our accredited, online course on “Understanding and Using Data
  3. View our “Understanding and Using Data” course preview

3 tips for more effective data insights:

The following tips will help you to draw better insights from your data—without knowing these things, your team may draw incorrect conclusions or lose credibility when using data.

1. Use Proper Data References.

Whenever you use or refer to data in a presentation, make sure you source the data appropriately, including the geography, time period, product, measure and data source (see the data cube below). As a Retailer you should define the time period and geography standards for category reviews and business reviews so that there are consistent views of your data (and share these standards with your Vendor partners). As a Vendor, don’t try to find the data that makes your brand look better—stay consistent with the most standard time periods and geographies most relevant for the business issue. Remember that negative trends or numbers can also represent a big opportunity.

Category Management Data Cube

2. Use Comparisons for Benchmarks and Relativity.

When reviewing results in a business review or category review, include relevant comparisons rather than sharing sets of numbers that have no meaning on their own or assuming “good” or “bad” based on norms. This will help to make your numbers come alive. For example,

LESS MEANINGFUL MORE MEANINGFUL
“Category X has a 90% penetration at Retailer A which is very high.” “Retailer A’s penetration of 90% is behind Competitive Retailer B’s penetration of 92.5%. This represents an opportunity for Retailer A to increase penetration.”
“Category X is doing well at Retailer A, up 2% vs a year ago.”  Retailer A is losing market share in the category, despite growing at 2% last year. This means their competitors are growing in this category at a faster rate.”

3.  Don’t Just Rely on Others—Know Your Stuff!

Regardless of what level you’re at or your role, you should know how to read and interpret numbers—and in particular, those that affect your business or help you make more strategic decisions and recommendations.

Retailers, don’t be naïve about the numbers and don’t rely on your Vendors to tell you what’s happening in your categories and business. You should be well-versed in your categories and understand all of the numbers that are presented to you. Lead the collaborative discussions and make the appropriate decisions for your categories.

Vendors, start looking at different data sources and beyond your brand results to discover category opportunities for both you and your Retailers. This is a necessary step if you want to move to a more collaborative business approach with your partners. 


 

Benefits of Strategically Understanding and Using Data

Business Wins:

  • Make more fact-based, strategic insights to grow your business and your collaborative partner’s business
  • Create new strategic solutions and uncover new opportunities for your business
  • Add value to your team, organization and/or customers
  • Make better decisions than the competition, focused on Shopper

Personal Wins:

  • Lead your team
  • Stand out among your peers
  • Get that next promotion
  • Land that new job 

By training your team (or preferably your whole organization) on proper data usage, data sources available and how and when to use different data sources, you will take the first step in moving your organization to a more fact-based, strategic organization (and improve your data return on investment!). Don’t assume that everyone knows or understands these important foundations—skipping this step may result in limited results. Once you create this level of data understanding, it’s time to start analyzing data—moving data to insights!  


Looking for more data insights? Category Management Knowledge Group can help you to move your team to the next level through custom category management training programs. 

Check out our accredited course on “Understanding and Using Data”, which shares more tips and walks through the key category management data sources and how you can maximize their use. It also gives an 8-step process to analytic success so you can plan your bigger analysis projects before you start.

 

 

   

Link to Purchase “Understanding and Using Data” Category Management Training Course

$125 USD
INCLUDES:

30-day Access

Hands-On
Workshops

Downloadable
Notes

Reference Guide

Knowledge Checks

Course Test

 

Topics: Category Management Training, Data ROI, Category Management, Category Definition

Written by Sue Nicholls, CPSA Founder & President CMKG

Category Management is my passion.

Since beginning with P&G in the late 1980s, I have dedicated my work life to building and sharing this passion with others through active involvement in the industry, including long-term business relationships with large Retailer and Vendor executives, development and influence on Category Management Association certification standards and curriculum, thought leadership publishing and presentations at CSP News’ Convenience University, CMA’s Annual Conference and LinkedIn, and as a member of DePaul University’s Center for Sales Leadership Advisory Board.

Through this blog and other channels, I share this expertise and believe that an open and ongoing conversation can improve any team’s capacity to implement business strategies that achieve their strategic priorities.