Written by

Bernard Marr

Bernard Marr is a world-renowned futurist, influencer and thought leader in the fields of business and technology, with a passion for using technology for the good of humanity. He is a best-selling author of 20 books, writes a regular column for Forbes and advises and coaches many of the world’s best-known organisations. He has over 2 million social media followers, 1 million newsletter subscribers and was ranked by LinkedIn as one of the top 5 business influencers in the world and the No 1 influencer in the UK.

Bernard’s latest book is ‘Business Trends in Practice: The 25+ Trends That Are Redefining Organisations’

View Latest Book

How Do You Create Great Data Exploration Dashboards To Democratize Analytics?

2 July 2021

With all the data that’s created each day and the possibilities for making data-driven decisions in business, every company must have a way to present data to business users in a user-friendly and informative way.

 | Bernard Marr

In my experience, a lot of organizations get this wrong. In the pursuit of making data accessible to everyone, many organizations simply add a nice user interface on top of a huge data lake and consider the job done. Voila! They think this allows business users to find the data and analyze it in a self-serve environment.

In practice, I find that instead of empowering business users, this actually makes them feel threatened and overwhelmed. I often meet business users that don’t know exactly what data to use and how to use it.

You must do more than just provide decision-makers with access to data.

Provide a User-Friendly Buffet of Data Choices to Decision-Makers

Think of your data exploration dashboard like a self-service buffet restaurant.

Do buffet restaurants pile a bunch of raw ingredients into a massive trough without any order and then provide you with a fork to sort through the mess?

No. Rather they set up an orderly arrangement of starters, salads, and main courses where you can easily walk around the buffet to develop the dining experience you prefer. Some even have an omelet, prime rib, or other cooking stations to make it really easy for patrons to construct their own meals.  

How can this buffet analogy apply to data exploration dashboards?

Think about the business questions the business users might need to have answered. For example, a marketing manager might want to understand what accounts are doing really well and what accounts are in danger of churning.

By doing some analysis of the data in advance of the business users accessing it, you guide business users to insights and help them find the data they need. This pre-defined analysis or these pre-defined questions make data more useful.

Self-Exploration is not useful for all your data

Another error many organizations make is not reporting their most strategic information in a meaningful way. While much time and energy go into selecting the appropriate data points and KPIs (Key Performance Indicators) for an organization and then tracking data and numbers, the insights are often lost when the communication is simply based on self-service analytics. When reporting your most strategic insights, it’s important that it’s done in a way that allows decision-makers to easily understand the key insights.

The most effective way to communicate performance is by using numbers, tables, and charts as well as words to put the performance in context. Organizations that carefully curate KPI dashboards are the ones who use data and KPIs effectively.

To be sure data isn’t lost in translation, subject matter experts should carefully curate the data points and the insights that data delivers to share with execs. Consider this step like a fine dining experience. When you enjoy an outing to a fine dining establishment, the entire experience is curated from the ingredients selected to the entrees and accompaniments to how everything is presented on the plate.

Apply this fine-dining thinking to your KPI dashboard. Instead of giving execs all the data that’s gathered, showcase and focus decision-makers’ attention on the data that matters. This should be the data that helps business users understand progress toward a strategic objective and the insights execs need to make data-informed decisions.

The most effective KPI dashboards use a combination of words, numbers, and visuals to communicate key messages and progress toward achieving strategic objectives. Unfortunately, when insights aren’t communicated, disaster can result.

When NASA was developing the space shuttle Challenger, there were some engineers who had grave concerns about the O-rings used. While the data was communicated to decision-makers, the insight about the potential failure of the O-ring was lost in translation. As you know, this was more than a communication failure; it was catastrophic.

Don’t report data and fail to report insights to decision-makers. Ensure understanding by decision-makers by carefully curating your KPI dashboards. To learn more about how to do so, please check out my YouTube channel.

It’s important to lead business users to the data that they will find the most useful instead of providing access to all data and expecting them to uncover what they need. When reporting KPIs, also be sure that your organization curates the data and insights and presents them to decision-makers through the use of a KPI dashboard that uses visuals, words, and numbers to communicate.

Where to go from here

If you would like to know more about , check out my articles on:

Or browse the Artificial Intelligence & Machine Learning library to find the metrics that matter most to you.

Data Strategy Book | Bernard Marr

Related Articles

How To Set SMART Goals To Help You Succeed | Bernard Marr

How To Set SMART Goals To Help You Succeed?

When I work with companies, one of the things I do is help them establish goals that will give them the best possible chance of success [...]

What Skills Are The Most Needed Right Now | Bernard Marr

What Skills Are The Most Needed Right Now?

The annual Coursera Global Skills Report helps leaders and [...]

The 10 biggest mistakes companies make with performance management

The ability to manage employee performance well is a critical […]

How Do You Set The Right Targets For Your Business? Here Are Some Top Tips

Every business needs to set targets for success, but how […]

OKRs vs KPIs: What is the Difference?

Have you noticed that OKRs (management speak for ‘objectives and […]

The Benefits of a Balanced Scorecard

What are the Benefits of using Balanced Scorecards? Research has […]

Stay up-to-date

  • Get updates straight to your inbox
  • Join my 1 million newsletter subscribers
  • Never miss any new content

Social Media



View Podcasts