Create a Refreshable KPI Dashboard in Excel with Power Query

Learn how to create a powerful and refreshable KPI Dashboard in Excel! In this tutorial, I’ll guide you through using Power Query to combine multiple data sources, creating pivot tables and pivot charts for insightful visuals, and building a dynamic customer KPI card using sparklines. By the end, you'll have a streamlined dashboard that updates automatically with new data, perfect for tracking key performance indicators and making data-driven decisions in real time. Whether you’re new to Power Query or looking to expand your Excel skills, this step-by-step guide has you covered. Subscribe for more Excel tips and tricks!

Workbook Download Link: https://docs.google.com/spreadsheets/...


0:00 Introduction
0:35 Dataset Introduction
1:20 Loading Table into Power Query
3:20 Unpivot in Power Query
5:10 Append Tables in Power Query
5:54 Custom Column in Power Query
7:00 Load to Pivot Table
8:52 Create Pivot Charts
16:25 Create KPI Card
26:50 Refresh Data