‍Topics: connecting to multiple data sources, cleaning data with Power Query, analyzing data with Power Pivot, and setting up Power BI

Prerequisites: Part 2 (or you will be lost)
What you need to attend: PC or Mac with Zoom
Materials: available for download
‍
Participation: Questions are welcome. We'll also have several hands-on exercises to do during class.
‍
Recording: Will be available after class so you can review the material and exercises.

• The proper way to connect to other workbooks in your office
• Creating simple queries within the workbook
• Pre-cleaning a messy data source
• Pre-filtering massive datasets
• Automating Complex Data Transformations

• Combining data from several tabs into one table
• Automatically combining several files from one folder into one table!
• Combining several disparate datasets into one coherent table
• Using Merge to perform "vlookups" between your queries

Power Pivot takes us to the Moon

• An introduction to Power Pivot and the data model
• Combining several datasets into one pivot table!
• Building simple measures to perform calculations in Power Pivot
• Working with datasets that have millions of rows with no problem
• How to use Power Query and Power Pivot Togther

You Now Understand Power BI!

• An introduction to Power BI, which allows you to keep your data in the cloud
• Establishing a single source of truth for the numbers in your office
• Transferring your Power Query and Power Pivot Models to Power BI

• What to do with all of your new free time now that you're no longer fixing garbage spreadsheets