A dashboard full of numbers isn't useful unless the numbers answer a real question. Metrics are the things you can measure; KPIs are the few that tell you whether the business is on track toward a goal. Choosing them well is one of the most valuable skills a BI analyst has.
You'll start by learning the difference between metrics and KPIs and how to tie each one to a business goal, a target and a decision. Then you'll look at how to choose the right KPIs, avoid vanity metrics, and design a dashboard that gives each audience what they need at a glance.
Now that you can build in Power BI and Tableau, this module helps you decide what to build. In the next module, ETL & Cloud Data Platforms, you'll learn how the data behind your dashboards gets collected, moved and prepared.
The fundamentals of metrics and key performance indicators, including how a metric differs from a KPI, explained in a Power BI context.
How to pick the KPIs that really matter, starting from goals and avoiding vanity metrics, with a product-management angle.
Twelve practical tips from Geckoboard, such as knowing the purpose, grouping related metrics and giving numbers context. They apply to any dashboard tool.
A beginner-friendly walkthrough of building a Power BI dashboard that visualizes business KPIs.
A step-by-step Tableau example of a KPI dashboard for business users, built around a comparison of two months.