In the words of mighty Julius Caesar, “Divide and conquer”, and data is no different. We can break down any complex problem into buckets and forge a path to purposefully resolve it. In this example, the KPI Breakdown dashboard looks at an enterprise that does business across the globe and boils it down to six summary viewpoints across 12 KPIs. By breaking down the analysis, it will enable the enterprise to understand what is driving their company’s success or impeding it at any given time.
Having a holistic understanding of a business, with many driving key performance indicators can be tough to manage. You could view this information from a simple table with your insights just out of reach. This becomes increasing more difficult when you want to see these KPIs across all the countries you have a presence in.
This can be eased by using Microsoft’s Power BI dashboarding abilities to integrate new business perspectives.
Drive Insight with Flow:
With the objective being to observe 12 KPIs across many different dimensions that have many different attributes, this objective could be rather difficult to visualize on the surface. So, to keep this easy for users to consume, starting with the most basic value, an unsliced and all-up measure gives users a firm grasp of the KPIs fullest potential.
Then taking said KPI and divvying it up by region, takes the slice one step deeper. Naturally flowing from region and breaking it down by country, users are logically guided into its next stage in the hierarchy. To dovetail this country breakdown, summarizing the countries into a histogram, gives a shape to the data. Following all of it with trending, which will be relative to the filters and dashboard selections.
Moreover, these 12 KPIs are logically grouped. First, by what can be controlled (Financial). Secondly, by what cannot be controlled (Market), and third, all the while moving into more granular trends (Supply) creating an intuitive workflow. These three buckets further break down the information by clustering like measures into manageable chunks.
These 12 KPIs are simplified into three sections Financial, Market and Supply (Sup).
- Financial: KPIs that are driven by internally controlled factors, such as Net Profit.
- Market: KPIs that are factors beyond the business’s control, such as the Current Share of the Market and the company’s Relative Share of that Market.
- Supply (Sup): KPIs that are primarily expense based, such as COGs and their relative Resupply Variance, etc.
The previously mentioned elements go across these clustered measures, and are defined as the following:
- All-Up: The basic sum, average or percentage of the KPI. This is the metric at its most simple of states.
- Regional: A breakdown by the highest level of geo division. A good starting point for senior managers and executives to begin making decisions.
- Country Relative Performance: A lens for the relative clustering of countries based them being above or below the line. Color is used to drive the health of the country.
- Distribution: A simplified summary of the Country Relative Performance, which clusters said countries.
- Trending: Timeline analysis, filtered based on your choices. A key feature for finding growth.
- Summary Ranking: A statistic which weighs, combines and simplifies the 12 KPIs into a single summary metric. Summary statistics can help channel your data perceptions into data-driven actions. Know a summary statistic would need business user agreement, as well proper weighting for each relative KPI.
By breaking up the KPIs into various buckets, leadership and analysts alike can communicate in a targeted manner, saving both parties time and encouraging open conversation for strategic actions.
Make it Engaging with Interactions:
The beauty of dashboards is that they empower users to touch their data. Users can explore and drill at their very whim. Interaction allows users to find their own insights pertinent to their use cases.
A couple key exploratory features in this dashboard, would be having categorical filtering at the top of this view, including region and country. Similar functionality can be found by simply selecting data points within each graph. Numeric and date slicers can be found at the bottom.
Perhaps the more interesting interactions would be the use of bookmarks to have an embedded FAQ, as well a selector for a Top 10, 20 and All-Up relative summary rankings. These rankings are further enriched with a Report Tooltip to show relative success over time. Bookmarks and Report Tooltip are features that place Power BI as one of the best BI tools for intuitive analysis.
One of the most valuable aspects of growing in digital maturity, is to use data to provide insights into our area of influence. The use of Power BI to build this KPI Breakdown dashboard is a powerful example of how new technology can transform a leader’s ability to track their company’s performance and identify strategies for improving their company’s health, by leveraging dashboarding and more advanced features, to breakdown their problems into actionable metrics.
The Power BI practice at Decisive Data will help you visualize and share your data. We strive to deliver solutions that not only let you make sense of your data, but lead you to the next step of taking action and driving process improvement at your company. If you'd like to learn more about how we can help you deliver actionable insight’s please contact us.
Posted by Jacob Olsby