Course Description
For decades, Excel has been the primary reporting tool of choice for businesses to develop data analytics solutions. While those skills are still important, learning Power BI opens you up to a more interactive and visually appealing experience by offering more powerful analytics and reporting features.
In this session, Jonathon Silva will teach you about some of the most advanced capabilities available in Excel, and how to bridge those skills into a new world within Microsoft Power BI where manual, complex, and arduous reports are a thing of the past. You’ll also learn how Excel and Power BI best work together and understand the migration path to take your existing Excel work into Power BI.
Prerequisites: (to follow along or review later)
✔️ Install Power BI Desktop (https://tinyurl.com/33rcb3rn)
✔️ Download student files (https://tinyurl.com/2755arf4)
After you finish this course:
📄 If you have completed this class and would like a certificate, fill out this form - https://share.hsforms.com/1JYYgjCoITT-7M3O8SMRTjg8xue
- 0:00 - Intro
- 4:31- Session starts
- 22:31 - Power Query Explanation and Import Files from a Folder
- 41:15 - PowerPivot and the Data Model in Excel
- 49:15 - Power Query: Using Unpivot
- 58:16 - Power Query: Splitting Column by Delimiter and Fill Down
-
- Full Report Demo:
- 1:10:32 - Part 1: Data Cleansing in Power Query
- 1:54:48 - Part 2: Data Modeling
- 2:02:50 - Migrating from Excel to Power BI
- 2:09:35 - Part 3: Data Visualizations
- 2:29:27 - Part 4: Publishing a Power BI Report
-
- 2:36:03 - Using Analyze in Excel
- 2:50:15 - Adding Excel charts to a Power BI Dashboard and App