1. Starting Points
1.1. Accessing Power BI
1.1.1. Create a Power BI Online Account
1.1.2. Download Power BI Desktop
1.2. Accessing Course Materials
1.2.1. Access this Mindmap
1.2.1.1. http://bit.ly/3qwj8GQ
1.2.2. Download Datasets
1.2.3. Access Course Crib Sheet
1.3. Recapping Course Objectives
2. Cheat Sheets
2.1. https://docs.microsoft.com/en-us/power-bi/
2.2. https://www.techrepublic.com/article/microsoft-power-bi-a-smart-persons-guide/
2.3. https://pbicheatsheet.blob.core.windows.net/pbicheatsheet/Macaw%20Power%20BI%20cheat%20sheet%20EN.pdf
2.4. https://docs.microsoft.com/en-gb/dax/
2.5. https://docs.microsoft.com/en-gb/powerquery-m/index
2.6. https://oxcrx34285.i.lithium.com/t5/image/serverpage/image-id/10656i1E4A1F0FCD1C4429/image-size/large?v=1.0&px=999
2.7. https://docs.microsoft.com/en-us/power-bi/media/service-azure-and-power-bi/azure_4_complex.png
2.8. https://azure.microsoft.com/en-us/solutions/architecture/modern-data-warehouse/
2.9. https://databricks.com/blog/2019/02/07/high-performance-modern-data-warehousing-with-azure-databricks-and-azure-sql-dw.html
2.10. https://docs.microsoft.com/en-us/power-bi/whitepapers
3. Final Exercise
3.1. ...a view of Power BI as a decision support tool that ties together models, metrics, and visuals...
3.1.1. Background
3.1.1.1. Scenario Analysis in Power BI
3.1.2. Scenario
3.1.2.1. Building a "what-if" sales scenario builder...
4. Key Knowledge
4.1. Purpose of Power BI
4.1.1. Business Intelligence
4.2. Placement of Power BI
4.2.1. ...business intelligence solutions take the form of "pipelines" with standard components: "Source-Sort-Store-Science-Serve"...
4.2.1.1. Data Pipelines
4.2.2. ...Power BI typically fulfills the "Serve" role...
4.2.2.1. Microsoft BI Pipelines
4.2.2.2. Microsoft Big Data Pipelines
4.2.3. ...but Power BI can be stretched...
4.2.3.1. Power BI Capabilities
4.3. Anatomy of Power BI
4.3.1. Overview Architecture
4.3.2. Component Comparison
4.4. Working with Power BI
4.4.1. ...analytics has some standard workflows...
4.4.1.1. CRISP-DM
4.4.2. ...we need to employ different approaches when designing and building with Power BI...
4.4.2.1. Design: Outside-In
4.4.2.1.1. ...creating value for users, specific answers to specific questions...
4.4.2.2. Build: Inside-Out
4.4.2.2.1. ...engineering a solution...
4.4.3. ...ultimately, success requires an "information design" mindset...
4.4.3.1. Information Design
5. Scenarios
5.1. ...three sets of projects revealing different dimensions of Power BI...
5.1.1. Visual Analytics
5.1.1.1. ...revealling patterns and enabling insight...
5.1.1.1.1. Key Concepts
5.1.1.1.2. Illustrative Scenarios
5.1.1.1.3. Takeaways
5.1.2. Data Wrangling
5.1.2.1. ...getting data "fit" for analysis...
5.1.2.1.1. Key Concepts
5.1.2.1.2. Illustrative Scenarios
5.1.2.1.3. Takeaways
5.1.3. Quantitative Analytics
5.1.3.1. ...introducing statistics and metrics...
5.1.3.1.1. Key Concepts
5.1.3.1.2. Illustrative Scenarios
5.1.3.1.3. Takeaways
6. Orientation
6.1. ...working with Power BI Desktop...
6.1.1. Craft reports, data, and models in Power BI Desktop...
6.1.1.1. ...key guides...
6.1.1.1.1. Basics
6.2. ...working with Power BI Online...
6.2.1. Access, manage, and share resources in Power BI Online...
6.2.1.1. ...key guides...
6.2.1.1.1. Basics
6.2.1.1.2. Sharing
6.2.1.1.3. Sharing Apps
6.2.1.1.4. Scheduling