Using Dashboards to Ask Insightful Questions

Table of Contents

Smart Questions

 

In today’s fast changing business environment, one of the hardest tasks of any business manager is learning how to ask ‘smart questions’. 

 

Meaningful Insight

 

By smart questions, I mean questions that when answered, will reveal meaningful ‘insight’ from seemingly disparate information. 

Insightful Questions

 

Monitor Number of Patents for Insights

 

For instance, in his book,  "As the Future Catches You" by Juan Enriquez, Mr. Enriquez makes the point that bioinformatics and by extension, the number of patents filed, increasingly indicate the level of wealth a particular country will achieve. 

Correlation Between Patents and Average Income

 

So I did some research, and no surprise, I find a very direct correlation between the number of patents filed and the average income level of a U.S. state. 

Dashboards are Very Powerful

 

In particular, if you take a look at this xCelsius dashboard, which if you press the button below, you can download and explore for free, you can freely explore the relationship. 

 

Click me

 

We can only break it down by state level but the data at the county level really tells the story. 

Sometimes, for instance, in my home state of Indiana, the relationship between higher incomes and number of patents filed show up in very unexpected counties.

 

Causal or Correlational Relationship?

 

The point of this exercise is that in order to do this analysis, it required me to first ask the question-is there a relationship, whether causal or correlational in nature, between the number of patents filed in a particular state and the average income achieved by the citizens of that state. 

 

Strong Relationship Detected

 

Turns out, there is a strong relationship, but the data that tells you that is located in two separate government agencies, in this case, the U.S. Census Department and the USPTO or United States Patent and Trademark Office. 

  

SAP Dashboard Tool

 

The tool, in this case, SAP’s xCelsius® Dashboard tool, along with a whole series of other tools that were involved in getting this data into the dashboard, such as the internet, Excel®, Flash®, and many others, was great for providing the ‘insight’ revealed by this information.

 

SAP BW Consulting Resources

 

 

SAP BW Consulting has the consulting resources to help you not only ask the right questions, but to deliver the ‘insight’  you are looking for, sometimes finding it in the most unexpected places.

 

More reading:

Take a Deeper Dive into Aircraft Cockpits Vs Dashboards

Learn What is Catch Weight Management

 

 

Thanks 

Topics from this blog:
Insight Smart Questions xCelsius Dashboards

Download SAP BW Mindmap

Learn what SAP Business Warehouse is and what it does in under five minutes

Get this Mindmap

Lonnie D. Ayers, PMP

About the Author: Lonnie Ayers is a Hubspot Certified Inbound Marketing consultant, with additional certifications in Hubspot Content Optimization, Hubspot Contextual Marketing, and is a Hubspot Certified Partner. Specialized in demand generation and sales execution, especially in the SAP, Oracle and Microsoft Partner space, he has unique insight into the tough challenges Service Providers face with generating leads and closing sales using the latest digital tools. With 15 years of SAP Program Management experience, and dozens of complex sales engagements under his belt, he helps partners develop and communicate their unique sales proposition. Frequently sought as a public speaker in various events, he is available for both inhouse engagements and remote coaching.
Balanced Scorecard Consultant

He also recently released a book "How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results", which is available on Amazon.

View All Articles by Lonnie D. Ayers, PMP

The SAP Blog

Subscribe to our blog and receive SAP BW Updates, demand generation, inbound marketing, sales enablement, technology and revenue generation insights and ideas delivered right to your email.