Find hidden insights in your data: Ask why and why again

Find hidden insights in your data: Ask why and why again

We’ve all encountered a curious little kid who wouldn’t stop asking “why.” But did you ever think that, in the business world, you should actually aim to bethat kid? That’s because people -- whether we’re talking about children, journalists, scientists, managers or data analysts -- don’t succeed by simply asking “what.”

Let’s say sales are down, costs are high and resources are underused -- all familiar scenarios, right? Being able to identify these problems is the easy part. The hard but crucial part is actually getting to the root cause of a problem so you can take action.

How do you do that? By asking why, and then asking it again.

There’s a good chance you’re familiar with something called the “5 Whys” technique. Sakichi Toyoda, who’s known in Japan as the "King of Japanese Inventors" and the founder of Toyota Motors, created it. In a nutshell, you ask “why” of a problem that’s been identified, and then continue asking “why” for each answer or explanation given. The primary goal of the technique is to determine the root cause of a defect so you can fix it.

Many businesses don’t enable this, to their detriment. Lots of businesses have dashboards or reports. They’re great at answering the “what” questions but what happens when you need to know more about what the data is showing? To apply the “5 Whys” technique, you need to be able explore the data beyond the limits of the dashboard. This way, you can answer the unexpected questions.

Put another way, dashboards should be the start, not the end.

Let’s walk through an example. Pretend you are a big-box retailer and you have a beautiful dashboard showing your sales and profits. As you can see in the figure below, a bar chart answers the question: How are sales and profits in our main categories? It reveals a problem: as you can see, furniture is far from its profit target.

So, what do we do? We ask why.

One thing we can do is filter down to different regions or click on a category to show more detail in the map and line chart at the bottom:

But while this gives us more information, as seen above, it doesn’t really answer the question “Why are furniture profits low?” And that illustrates a key point: Investigating a question may start with drilling down and filtering. But with those steps, all we’re really getting is new views of the same question.

 

Share it:
Share it:

[Social9_Share class=”s9-widget-wrapper”]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

You Might Be Interested In

Informatica announces industry’s first intelligent healthcare data lake

19 Feb, 2017

Data management solutions and big data companyInformatica LLChas announced the debut of the industry’s first intelligent data lake, a repository …

Read more

Building a foundation for innovation: A guide for the CIO

6 May, 2019

Innovation is of central importance in almost any vertical sector you can think of. It dominates the thinking of most …

Read more

When The Rise Of AI Meets The Ease Of No-Code

23 Sep, 2022

Not too long ago, professional web designers wouldn’t dream of using a no-code website builder—if you didn’t personally write each …

Read more

Do You Want to Share Your Story?

Bring your insights on Data, Visualization, Innovation or Business Agility to our community. Let them learn from your experience.

Get the 3 STEPS

To Drive Analytics Adoption
And manage change

3-steps-to-drive-analytics-adoption

Get Access to Event Discounts

Switch your 7wData account from Subscriber to Event Discount Member by clicking the button below and get access to event discounts. Learn & Grow together with us in a more profitable way!

Get Access to Event Discounts

Create a 7wData account and get access to event discounts. Learn & Grow together with us in a more profitable way!

Don't miss Out!

Stay in touch and receive in depth articles, guides, news & commentary of all things data.