Audience: Analysts and managers who report from Excel today and are new to Power BI.
Prerequisites: Power BI Desktop installed. Sample Excel file downloaded from the link sent before class. Basic Excel helps.
License and software: A Windows PC with Power BI Desktop installed. It is free. It does not run on a Mac. No paid license is needed for the hands-on work. Sharing or publishing a report needs Power BI Pro or Premium Per User and is shown by the instructor.
YOU LEAVE WITH A report file with a dashboard page: four KPI cards, a year slicer, a trend line chart and a drill-down bar chart.
BY THE END, STUDENTS WILL BE ABLE TO
-
Find their way around Power BI Desktop: canvas, panes, ribbon, and Report, Table and Model views
-
Connect Power BI Desktop to an Excel sales file and clean the data in Power Query
-
Format the numbers and add a product hierarchy and two measures
-
Build a dashboard page with KPI cards, a year slicer, a trend line chart and a drill-down bar chart
-
Control which visuals a slicer filters
-
Explain what is needed to publish and share a report
Module 1: Introduction to Power BI
-
Start a blank report and look through the Get Data dialog
-
The four work areas: canvas, Visualizations pane, Data pane, ribbon
-
Report, Table and Model views
-
Build a quick first report: a bar chart, a card and a slicer
-
List what needs fixing before anyone sees it
-
Lab 1: Interface tour and a quick first report from SalesData.xlsx
Module 2: Connecting to Data and Power Query Essentials
-
Connect with Transform Data instead of Load
-
Check the data first: headers, blanks and columns you will not use
-
Profile the data: column quality, distribution and profile
-
Remove columns, rename columns and set data types
-
Name the query Sales, then Close & Apply
-
Lab 2: Connect to SalesData.xlsx and clean it in Power Query
Module 3: Preparing the Data for Reporting
-
Format prices, sales, cost and profit as currency, and discount as a percentage
-
Build a Category, Subcategory, Product hierarchy
-
Write two measures: Number of Orders and Number of Customers
-
Why counting rows overstates orders
-
Lab 3: Format the fields, build the product hierarchy and write two measures
Module 4: Building an Interactive Dashboard Page
-
Four KPI cards: Total Sales, Total Profit, Total Orders, Total Customers
-
A year slicer from Order Date
-
A sales trend line chart that drills from year to quarter to month
-
A sales-by-category bar chart that drills to subcategory and product
-
Edit Interactions: keep the trend line unfiltered by the slicer
-
Name the page and save the file
-
Lab 4: Build the dashboard page and test every filter
Module 5: Saving and Sharing (instructor demonstration)
-
Saving a .pbix file versus publishing to the Power BI service
-
Publishing and sharing need Power BI Pro or Premium Per User
-
Publish to a workspace and open the report in the service
-
Share the report and refresh the data