Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Build 45 Real-World Power BI Projects for BI & Data Analysts
Rating: 3.9 out of 5(236 ratings)
3,824 students

Build 45 Real-World Power BI Projects for BI & Data Analysts

Power BI projects for analysts: KPI dashboards, budget variance, churn and customer segments with Power Query and DAX
Last updated 11/2026
English
English [Auto],

What you'll learn

  • Build Power BI KPI dashboards that compare actual results with targets, budgets and forecasts
  • Clean and shape raw Excel and CSV data in the Power Query Editor, fixing nulls, merging queries and adding index columns
  • Design star schema data models with fact tables, dimension tables and a calendar table
  • Write DAX measures for YTD, MTD, running totals, variance and current year versus previous year
  • Analyze customer churn, and segment and rank customers with DAX into groups such as VIP and loyal
  • Analyze employee attrition and build HR dashboards for workforce reporting
  • Track web marketing and email campaign performance with sessions, bounces and rate measures
  • Use KPI visuals, the Q&A visual, maps, slicers and conditional formatting in business dashboards
  • Create multi-page Power BI reports with page navigators for managers and stakeholders
  • Assemble a Power BI portfolio of KPI, variance and churn reports for BI and data analyst roles

Course content

46 sections • 225 lectures • 37h 6m total length
  • Course Introduction1:12

Requirements

  • No prior experience needed.Power BI Desktop, free from Microsoft, installed on a Windows computer
  • Everyday experience with Excel or a similar spreadsheet tool
  • Curiosity about how businesses track sales, budgets, customers and staff

Description

This Power BI course is built around the reports a BI analyst or data analyst is asked to deliver at work: a KPI dashboard for managers, a budget versus actual review, a churn analysis, a customer segmentation, a trend report that compares this year with last year. You build each one in Microsoft Power BI Desktop, from the raw data file to a finished, formatted dashboard, and every project comes with its files so you can follow along step by step.

Every project runs through the same Power BI workflow, so it becomes routine: shape the raw file in Power Query, model it as a star schema with fact and dimension tables, write the DAX measures the report needs, and arrange visuals around the question a manager asked.

KPI and executive dashboards

  • A finance KPI dashboard with actual versus target, variance, variance percentage and monthly target status

  • An advanced Superstore sales KPI dashboard with maps, cards, a top-five filter and currency conversion

  • A Coca-Cola sales dashboard with retailer, brand and year slicers, conditional formatting, and year-to-date and month-to-date totals

  • A web marketing KPI dashboard that tracks sessions, exits, bounces and average time on site

Budget, variance and financial reports

  • Planned versus actual spend reviews, including IT spend variance with running totals for budget, actuals and forecast

  • A personal finance insights dashboard and a Netflix stock price business analysis

Customers, churn and segmentation

  • Churn studies on a real-world business problem and on bank customers, with an advanced version built on data modeling

  • A customer performance dashboard that groups customers with DAX into segments such as VIP and loyal, ranks top buyers and breaks down revenue by region and gender

  • Credit card defaulter analysis and an email campaign dashboard with rate measures

Attrition and workforce reports

  • Attrition analysis with HR data transformation, plus HR dashboards and an employee data analysis for workforce reporting

  • A benchmarking report on data professionals around the world

Sales performance and operations dashboards

  • Sales performance reports for pizza, toy, car, food and beverage, supermarket and online superstore businesses

  • A food delivery app business insights project in two parts

  • Property management, hotel reservation and electric vehicle dashboards

Trends over time and public data

  • Road accident analysis with time intelligence cards that compare the current year with the previous year

  • Public dataset reports: COVID-19 from the WHO, air quality in Beijing, and crime trends in Chicago and Los Angeles

  • Patient summary, patient ER and healthcare data dashboards

  • Housing in Boston and apartments in Daegu, plus an IMDB movie comparison

Power BI skills you use across the projects

  • Import data from Excel and CSV files, and compare Import mode with DirectQuery mode

  • Clean data in the Power Query Editor: fix nulls, remove unused columns, merge queries and add index columns

  • Build star schemas with fact and dimension tables, a calendar table and one-to-many relationships

  • Write DAX measures with CALCULATE, a key measures table, YTD and MTD totals, running totals and time intelligence

  • Add KPI visuals, the Q&A visual, maps, slicers and conditional formatting

  • Build multi-page reports with page navigators so managers can move between views

Who this course is for:

  • Beginners in Power B.IBI analysts and data analysts who build KPI, budget and customer reports at work and want more Power BI practice
  • Excel users ready to build KPI and variance reports in Power BI
  • Business analysts who want to add DAX, data modeling and Power Query to their toolkit
  • Students and career changers building a Power BI portfolio for data analyst roles