← Course overviewPower BI: Raw Data to Professional Business Dashboards
MODULE 1 / 13LESSON 1 OF 83
Welcome: what you will build and how this course works
Start Here · 4 min
The business scenario
Summit Home & Outdoor runs 20 stores in four US regions plus Summit Online. Its sales live in 30 monthly CSV exports and a few Excel lists, and every Monday someone rebuilds the same spreadsheet by hand. By the end of this course you turn those raw files into one refreshable Power BI report: 50,547 order lines, $15,929,951.95 of sales, three pages that answer where the money comes from.
What you will learn
- See the finished Executive Overview, Products and Stores pages you will build
- Understand the course map: 12 modules, an assessment after every module and a final capstone
- Know where the lesson files, notes, quizzes and solution videos live and how to use them
Key steps in this video
- Tour the finished Summit report: Executive Overview, Products and Stores pages
- The course files: Course Data folder and a lesson folder
Common mistakes to avoid
- Skipping Module 0 and later finding dates read as day/month because of regional settings.
- Saving your work over the Base files - always use File > Save as into your own folder.
- Watching without building: pause the video and do every step in your own copy.
Practice resources
Course-Data.zip5 MB
Enroll to downloadModule-00-Start-Here-Practice-Files.zip4 KB
Enroll to downloadModule-00-Start-Here-Solutions.zip1,011 KB
Enroll to downloadModule-01-Foundations-Practice-Files.zip109 KB
Enroll to downloadModule-01-Foundations-Solutions.zip1 MB
Enroll to downloadModule-02-Get-Data-Practice-Files.zip53 KB
Enroll to downloadModule-02-Get-Data-Solutions.zip1 MB
Enroll to downloadModule-03-Power-Query-Practice-Files.zip239 KB
Enroll to downloadModule-03-Power-Query-Solutions.zip2 MB
Enroll to downloadModule-04-Data-Modeling-Practice-Files.zip77 KB
Enroll to downloadModule-04-Data-Modeling-Solutions.zip3 MB
Enroll to downloadModule-05-DAX-Foundations-Practice-Files.zip48 KB
Enroll to downloadModule-05-DAX-Foundations-Solutions.zip4 MB
Enroll to downloadModule-06-CALCULATE-and-Time-Intelligence-Practice-Files.zip164 KB
Enroll to downloadModule-06-CALCULATE-and-Time-Intelligence-Solutions.zip5 MB
Enroll to downloadModule-07-Visuals-Practice-Files.zip202 KB
Enroll to downloadModule-07-Visuals-Solutions.zip4 MB
Enroll to downloadModule-08-Interactivity-Practice-Files.zip47 KB
Enroll to downloadModule-09-Dashboard-Design-Practice-Files.zip100 KB
Enroll to downloadModule-10-Security-and-Sharing-Practice-Files.zip2 MB
Enroll to downloadModule-10-Security-and-Sharing-Solutions.zip3 MB
Enroll to downloadModule-11-AI-Features-Practice-Files.zip101 KB
Enroll to downloadModule-11-AI-Features-Solutions.zip2 MB
Enroll to downloadModule-12-Capstone-Practice-Files.zip31 KB
Enroll to downloadModule-12-Capstone-Solutions.zip951 KB
Enroll to downloadModule-09-Dashboard-Design-Solutions.zip5 MB
Enroll to downloadModule-08-Interactivity-Solutions.zip5 MB
Enroll to downloadFREE EXCEL LESSONS BY EMAIL
Not ready to enroll yet?
Join the Academy email list for practical Excel and AI tips, free preview lessons and news when a new course opens. Unsubscribe at any time.
