Dashboards – Mouse-over summary with drill-down different insightful piecharts and data exports

Speed to Insight

A good dashboard will quickly present results that matter to your success. A great dashboard will then allow a simple mouse-over and drill-down to provide insights or the data you need to do additional analytics to get to the reasons for the results.

The best of both worlds

Drill-downs are intended to provide quick access to relevant data without obscuring the summary data. In management terms, the initial dashboard is the 50,000 foot view and the drill down zooms into a lower level of detail. More importantly the details are specifically related to the performance results that are of interest. Once identified a nice dashboard will allow a simple mouse click to the detail that you need.

Different levels

A drill-down zooms into lower levels of detail. When there is a lot of data with either lots of stores, sales staff or machines it may benefit to break down into incremental levels. Here are three samples of how to use different types of drill-downs. Each level shows different insights that help find top selling items, stores, sales team or high quality machines. The data is there and different views show different perspectives.

Image of Convenience Store Performance Dashboard drilldown options showing details of foods sales Focus on one item –   In this example breakfast is the item of interest. Sales for retail are very easily categorized. Here the next level shows how many of each type of breakfast item was sold. It is important to see the details of why sales categories are increasing or decreasing. The pie chart show perspective. Notice, however that too many items make the pie chart clumsy – it becomes difficult to match the color in the pie chart to the item in the key.


Image of drilldown details of gallons sold for the week.
3-5 items show well in a pie chart
Many feel that a bar chart is better once the item count exceeds 5 or 6. In this example, the type of gas that is included in the total gallons is very clear.


Image of export format of tracked items sold in a convenience store in a week.
Do it yourself Sometimes we just need more analysis. Having the ability to grab raw data to analyze as you like or just print and share is really nice when you must get down to ‘ground level’.

Related topics

Creating dashboards that work for you
Convenience Store Performance Dashboards – Data Analytics Using Filters
Convenience Store Performance Analytics like Google Dashboard
Convenience Store Accountability Rules – Oh Yeah!
Convenience Store Performance Dashboards – KPIs with Drilldowns

Dashboards – Mouse-over summary with drill-down different insightful piecharts and data exports

Related Posts

7 Success Factors for Retail Analytics
7 Success Factors for Retail Analytics

BandyWorks work with dozens of retail chains and growing businesses. We have found the following 7 critical success factors for driving continuous improvement through retail analytics. 1. Key Performance Indicators – executives and managers should focus intently on their very most important performance metrics. For example, an Executive Dashboard should...

Six Signs That You Have Confused Your Spreadsheets With a Database
Six Signs That You Have Confused Your Spreadsheets With a Database

Green industry executives know full well that using the right tool the right job is key to a successful job. It would be pretty hard to cut most yards if you only had a string trimmer. Every company needs technology to maintain their information and work flow. Most small companies...

Winston Churchill’s Wisdom of Ongoing Analysis
Winston Churchill’s Wisdom of Ongoing Analysis

Winston Churchill said, “However beautiful the strategy, you should still occasionally look at the results.”   Day to day life typically becomes a routine.  We know what works, what doesn’t and we follow the plan that years of experience has taught us.  Then one day, things come up that we did not...