
Explore a beginner Power BI workflow from importing an Excel data set to transforming sales data with Power Query, checking column quality, and preparing data for visualization.
Clean and validate data by checking and correcting data types, removing nulls, converting revenue to decimal, and checking for negative values to prepare visuals.
Learn to build Power BI visuals with DAX measures for total and average revenue, transactions, and country counts; create cards, a region revenue donut, and a country line-and-stacked-column chart.
Visualize rank by revenue with a tree map, then explore ribbon charts, matrix views, and slicers to analyze sales reps and monthly revenue with a line and stacked column chart.
Explore revenue by rank using a tree map and ribbon chart, analyze sales reps with a matrix, and enhance with slicers and a monthly line and stacked column chart.
Import foods and beverages sales dataset in Power BI, load sales and product tables, and use Power Query editor to clean data and define relationships between fact and dimension tables.
clean and verify datasets in the power query editor, assess column quality, ensure correct data types, convert unit price to currency, and set up DAX measures for visualizations.
Learn to create Dax measures for revenue and average ticket price, build a sales amount column, and visualize with donut charts and line and stacked column charts in Power BI.
Explore Power BI data visualizations, including line and stacked bar charts for monthly revenue by order date, and a dashboard with donut charts, and slicers for category, channel, and quarter.
Analyze IT spend with power BI by comparing actual, budget, and forecast; import Excel and CSV files, transform in Power Query, build fact and dimension tables, and prepare for visuals.
Build a calendar table and establish table relationships to create a datamaster table, connect dates across budget, forecast, and actuals, and prepare Power BI visuals for real-world insights.
Leverage Power BI to generate AI-assisted visualizations with Q&A, comparing actuals to budget using KPI indicators. Build matrix and scatter visuals with DAX quick measures for budget versus forecast.
Build an HR analytics dashboard in Power BI to analyze employee attrition, clean data with Power Query Editor, and differentiate import vs direct query while modeling fact and dimension data.
We clean and prep data for visualization by renaming, removing unused columns, and setting correct data types in Power Query to enable DAX calculations and cards.
Learn to build Power BI visuals from prepared data, use Power Query for prep, add a conditional attrition count, and create measures for attrition rate, active employees, and avg age.
Explore Power BI visualizations to analyze attrition by department, age group, and gender using pie, column, matrix, donut, stacked bar, and gauge charts.
Import and compare Power BI import mode and direct query mode. Clean and transform data with Power Query Editor, and build KPI dashboards using DAX for Global Superstore 2016.
Learn to build dashboards driven by key performance indicators in Power BI using Power Query Editor to create year slicers and cards for sales, average delivery time, quantity, and returns.
Build a Power BI e-commerce dashboard by visualizing top five products by profit with a clustered bar chart, and analyze customers by sales, segment, market, and maps.
Build a patient information dashboard in Power BI, showing admission numbers and test results; import data, use Power Query, and model relationships between master data and fact and dimension tables.
Transform and clean data in Power BI with Power Query Editor, build one-to-many relationships, refine data types, and create smoker and alcoholic indicators for clearer visualizations.
Design a patient summary dashboard in Power BI by using a slicer for admission numbers, a multi-row card for key details, and a test-summary matrix.
Load and transform data in Power BI using Power Query editor, set correct data types, and identify missing values with column quality to prepare visuals and reports.
Create a Power BI visualization report for global sales data by building formatted visuals, cards for gross sales with callout values, background styling, and a slicer for interactive analysis.
Learn to build a multi-visual sales dashboard in Power BI, including total sales, total profit, units sold, year slicers, segment and product analyses, discounts, and a country map.
Explore a guided Power BI project using the Boston Housing Dataset, transforming data in Power Query, cleaning columns, correcting types, and preparing for visualizations.
Build Power BI visualizations by binning crime rate into 16 bins, creating a stacked column chart of crime count by place in Boston, and adding data labels and color.
Build donut and stacked visualizations for the Boston housing dashboard: represent categories like tracks near the Charles River, switch to count, customize colors, and analyze pupil-teacher ratio and highway proximity.
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