From Data to Insights: Make Better Business Decisions

You’ve pulled the data, built the charts, and checked the numbers. But when someone asks, “So what should we do?” the answer still isn’t clear. I see this often. Teams put a lot of work into reporting results, but the connection between the analysis and the business decision gets lost.
Read More

Unlocking the Secrets of Index Calculation: A Journey into Data Insights

Welcome to the exciting world of category management! This is where data transforms into gold for both Retailers and Suppliers/Manufacturers. With heaps of data at our fingertips, there are some key measures you should know about to make the most of it. In this blog I'll be covering the "Index" calculation.
Read More

Excel - The Foundations for Great Analysis

Do your team members possess the essential Excel skills for basic tasks? Excel stands as a crucial tool for analysts, sales professionals, category managers, and business individuals at large. While it might seem that everyone is familiar with Excel, the reality is different. Without foundational Excel skills, sales teams and category managers struggle to analyze their business effectively, administrators face challenges in creating comprehensive worksheets, and analysts may find fundamental concepts difficult to grasp. Additionally, there's the risk of errors and incorrect conclusions stemming from poorly constructed formulas and PivotTables. You might wonder, with automated reports available, why is Excel training necessary for organizations? The answer lies in the limitations of automated reports—they can't meet all needs. Meaningful analysis often requires data manipulation, cutting, formatting, and customization, necessitating strong foundational Excel skills. Consider a recent scenario where a client approached me about providing Excel skills training for their sales team. A sales manager had expressed concern about the team's inability to perform essential Excel tasks like formula writing, building PivotTables, and creating charts. Despite the assumption that everyone knows Excel, this proficiency was lacking. In response, I crafted a virtual training session covering Excel basics, including spreadsheet navigation, data sorting, formula writing (SUM, COUNT, RANK, UNIQUE), and creating charts and PivotTables. The session was optional, allowing those with existing proficiency to choose whether to attend. RESULTS? Due to high interest, I conducted two 3-hour sessions. The hands-on exercises focused on relevant scenarios for the sales team, incorporating data and item rank reports. Participants not only learned to create formulas but also gained insights into interpreting different KPIs. We used one of their extensive automated reports to build a practical PivotTable, bridging the gap between learning and application. Feedback from the sessions speaks volumes: "Best 3-hour lecture/class I’ve attended." "Time went by way too quickly!" "I learned many new things, i.e., formula building, shortcuts, and the importance of being clear on what I’m trying to say." "Handouts were helpful, and I will go back to reference them." Ask your team if they need Excel basics training! The response might surprise you. Learn more about Excel Virtual Team Training
Read More

The Secret Sauce for Better Strategy in Your Analysis

Integrating strategy into your analytics is one of the main areas most struggle with when doing their analytics — knowing what's relevant and what's not, what's a true insight and what's not. But if you know the secret sauce to bringing strategy into your analytics you’ll be able to turn your data and analysis into effective action to grow your business. And so I want to talk about pizza. Yes, you read that right — pizza.
Read More

9 Ways To Get Out of Your Rut and Innovate Your Category Management Approach (CMA+SIMA Conference Recap)

Last week I had the pleasure of attending the Category Management Association’s annual conference in Las Vegas, where category management and shopper insights professionals gathered to learn, share and network. It was particularly exciting for us at CMKG, because the CMA announced our new partnership at the conference. This venture will allow us to get our training into even more brilliant minds around the world. I facilitated 9 live training sessions over the course of the 3-day conference, spanning topics like: Identifying Growth Opportunities in Your Business, Fact-Based Presentations and Storyboarding, Shopper Insights (co-developed and facilitated with Leslie Warsaw from SIMA), Category Management in On-Premise (2-part session), and many more!
Read More

Identifying Growth Opportunities In Your Business

In a previous blog, I wrote about the importance of business acumen, which is the ability to assess an external market and make effective decisions. Or more simply put, it’s understanding how YOU and the work you do fit into the bigger picture.
Read More

Category Management with Limited Data: Start with What You Have

“We don’t have the data to do category management.” If that sounds familiar, I’d start with a question. What decision are you trying to make—and what information do you already have that could help? You may not have item-level Retailer sales, consumer panel data, or a complete view of the market. You may have shipment reports, a few customer scorecards, store observations, and people who know the business well. That isn’t the same as having a full category data set. But it doesn’t mean there’s nothing useful you can do. The opportunity is to work with what you have, understand what it leaves out, and make recommendations that fit the evidence. Waiting for perfect data won’t build that capability for your team. What decision are you trying to make? “Understand the category” can turn into a long list of reports you wish you had. A more specific question helps you decide where to start. Are you trying to understand why a customer is ordering less? Whether an item deserves a wider listing? Where the assortment may be missing a Shopper need? Each question needs different information. Before asking for another data source, write down the decision, what you already know, and what you would need to check. For example, declining shipments might give a supplier a reason to investigate a customer’s business. They don’t prove that Shoppers are buying less. The customer may have changed its ordering pattern, reduced inventory, or bought ahead in an earlier period. That distinction matters. It changes both your explanation and the conversation you should have next. Know what your data can tell you A useful starting point is to sort your information by the question it can help answer—not just by the name of the report. Shipment and order data: What did we sell to the customer, when, and in what quantities? Check returns, timing, and inventory changes before treating that as Shopper demand. Retailer sales and scorecards: What happened in the business covered by the report? Confirm the measures, periods, stores, and channels included. Store and online observations: What can Shoppers find, compare, and buy at the locations or pages you checked? A store visit can reveal a question worth investigating, but it doesn’t establish how common the issue is. Customer discussions and internal knowledge: What do people closer to the work know about changes in listings, promotions, availability, or execution? Use that knowledge to develop explanations you can check. Market or Shopper research, where available: What wider context does it add? Make sure its category definitions, coverage, and timing fit your question. Then ask: Where is the gap that could change our decision? You don’t need to fill every gap at once. If you’re investigating an availability issue, confirming whether stock reached the shelf may be more useful than purchasing a broad market report. Match the recommendation to the evidence Imagine a supplier sees lower shipments for a range over the last quarter. The team also visits a few stores and notices empty shelf positions for two items. Would you recommend cutting the range? I wouldn’t start there. The shipment decline and store observations give you reasons to ask questions, not enough evidence for a broad assortment change. A more useful recommendation might be to review customer inventory, confirm the current listings, and check availability across a defined group of stores. If the customer can share sales for those items, you can compare what sold with what was ordered and delivered. You’ve moved the discussion forward without pretending you know more than you do. When presenting your findings, separate three things: What we know. State the finding and the period or locations it covers. What might explain it. Identify possible explanations without presenting them as established causes. What we recommend next. Propose a focused check, a small test, or an action supported by the evidence. Limited data should influence the scope and confidence of your recommendation. It doesn’t mean you have to abandon a fact-based approach. Build capability alongside your data It can be helpful to think about category management as a continuum. As access to information, team skills, resources, and collaboration develops, the questions you can answer may become more detailed. But I’d be careful about putting an entire organization into one tier based on its data access. A team may have detailed sales data for one customer and very little for another. It may have strong analytical skills but limited time, or useful information that different functions haven’t connected. More data, more capability, and more collaboration don’t always arrive together. Ask your team: Can we interpret the measures and comparisons we already use? Do we understand the Retailer’s strategy and the Shopper needs behind the category? Are we connecting information across sales, category management, marketing, finance, and supply chain? Can we explain what our recommendation could mean for sales, profit, and execution? A new dashboard won’t answer those questions for you. Neither will AI. Tools can help organize information and explore possible explanations, but they can’t make missing evidence appear. Your team still needs to check the inputs and judge what the output supports. Before investing in more data, identify what it would help you decide and whether your team is ready to use it. Sometimes the priority is a new source. Sometimes it’s learning how to get more value from the information already available. Take the next step with your team At your next category discussion, bring one business question and the information you have today. Work through what it tells you, what it doesn’t, and which gap matters most to the decision. Agree on a next step, who will own it, and when you’ll review what you learned. That is category management work. It may be a more focused analysis than a team with access to a full range of data could complete, but it can still help you ask better questions and make a more informed recommendation. Through CMKG’s Learn → Connect → Apply approach, we can create learning using your own data, reports, and business examples. Pair online learning with a virtual session focused on interpreting the information you have, identifying its limitations, and turning findings into practical next steps. Explore Our Learning Approach to see how we can support your objectives, whether you’re developing your own analytical skills, working with a small team, or building a shared approach across your commercial organization. Happy learning! Sue
Read More

Injecting Shopper Into Your Category Management Foundations

Many of us “forget” the Shopper in our category reviews, business reviews, assortment reviews, space planning, sales presentations, internal presentations … So why should we incorporate "Shopper" into just about everything that we do? According to the CMA’s recent “CatMan 2.0” initiative,
Read More

Interpreting Index: Category Development Index and Fair Share Index

A dashboard shows a sales index of 110. Is that a good result? If the benchmark is last year’s sales, you’re up 10%. If it’s this year’s plan, you’re 10% ahead of plan. And if you’re looking at an index of out-of-stock rates, a 110 means your rate is 10% higher than the benchmark. That could be a reason to investigate.
Read More

Retailer Market Share as a Strategic Benchmark

When using data and analysis, the numbers on their own don’t tell the whole story. By applying thought and strategy to the interpretation of the data, you will come up with better category solutions. One of my favorite examples of this is the use of the “Retailer Market Share” number in category management. If you’ve ever heard, “You are underdeveloped in a brand, subcategory or category, and you need to fix this!”, then read on …
Read More