Power BI Reporting and Dashboard Creation
Turn business data into interactive reports and dashboards with Power BI Desktop and the Power BI service.
Course overview
Build a practical foundation in Power BI during this two-day introductory instructor-led course. Labs use sales data from a company that sells products online. Connect to Excel, CSV, and database sources, clean and shape data with Power Query, build a data model with relationships, create measures with DAX, design interactive reports in Power BI Desktop, then publish to the Power BI service and build dashboards that your team can share.
Course coverage
Progress from raw data files to a published, shareable sales dashboard.
- 01 Power BI overview: Desktop, service, mobile, and the interface
- 02 Getting data from Excel, CSV, folders, and SQL databases
- 03 Cleaning and shaping data with Power Query
- 04 Data modeling: star schemas, relationships, and date tables
- 05 DAX basics: calculated columns, measures, and CALCULATE
- 06 Report visuals: charts, cards, tables, matrices, and maps
- 07 Interactivity: slicers, filters, drillthrough, and bookmarks
- 08 Publishing, dashboards, sharing, and scheduled refresh
Participants will learn to
- Navigate Power BI Desktop and the Power BI service.
- Connect to common data sources and choose import or DirectQuery.
- Clean, combine, and reshape data with Power Query.
- Build a data model with relationships and a date table.
- Write DAX measures for totals, ratios, and year-over-year results.
- Design clear reports with the right visuals and formatting.
- Add slicers, drill-downs, drillthrough pages, and bookmarks.
- Publish reports, build dashboards, and share them securely.
Two-day course outline
Day 1 - Getting, shaping, and modeling data: Understand the Power BI workflow and the roles of Power BI Desktop, the Power BI service, and Power BI Mobile, and navigate the Report, Table, and Model views. Connect to Excel workbooks, CSV files, folders, and SQL Server databases, and compare import and DirectQuery modes. Use Power Query to remove errors and duplicates, set data types, split and merge columns, add columns from examples, unpivot data, and merge and append queries. Build a star schema model with fact and dimension tables, create relationships, set cardinality and filter direction, add a date table, and create hierarchies. Labs: import and clean online store orders, products, and customers, and build the sales data model.
Day 2 - Reports, DAX, and dashboards: Compare calculated columns and measures, and write DAX measures with SUM, COUNTROWS, DISTINCTCOUNT, DIVIDE, CALCULATE, and time intelligence functions such as TOTALYTD and SAMEPERIODLASTYEAR. Build reports with bar, line, card, table, matrix, and map visuals, apply themes and conditional formatting, and add slicers, the filters pane, drill-downs, tooltips, drillthrough pages, buttons, and bookmarks. Publish to the Power BI service, work with workspaces, pin visuals to a dashboard, use Q&A and data alerts, share content, set up scheduled refresh, and review row-level security. Final lab: publish the sales report and build a shared sales dashboard.
Format and audience
For: Business analysts, managers, Excel users, finance and operations staff, and technical staff who want to create reports and dashboards with Power BI.
Prerequisites: Comfort working with Excel and business data; no Power BI, SQL, or programming experience is required. Participants need a Windows computer with Power BI Desktop installed and a Power BI account with Pro or trial access for publishing and dashboard labs.
How it works: Two days of instructor-led lectures, demonstrations, and hands-on labs using online store sales data. Contact us to discuss dates and virtual or onsite delivery.
Explore the course
Request a quote for the two-day Power BI Reporting and Dashboard Creation course and discuss your team's training needs.