1. Our Universal Power BI Workflow
1.1. ...outside-in followed by inside-out...
1.1.1. Step 0. Design
1.1.2. Step 1. Query
1.1.3. Step 2. Wrangle
1.1.4. Step 3. Models
1.1.5. Step 4. Metrics
1.1.6. Step 5. Visuals
1.1.7. Step 6. Publish
1.1.8. Step 7. Manage
2. Orientation
2.1. Power BI Components in Concept
2.1.1. Microsoft: Comparing Power BI Desktop and the Power BI Service
2.1.2. SQL Dusty: Power BI Architecture
2.2. Working with Power BI Desktop
2.2.1. Microsoft: Get Started with Power BI Desktop
2.3. Working with Power BI Online
2.3.1. Microsoft: Get Started Creating in the Power BI Service
2.3.2. Microsoft: Ways to Collaborate and Share in Power BI
2.3.3. Microsoft: Data Refresh in Power BI
2.3.4. Microsoft: Publish an App in Power BI
3. Starting Points
3.1. Recap Course Objectives
3.2. Access this Mindmap
3.2.1. Copy this Mindmap
3.3. Download Course Datasets
3.3.1. Alternative: Download as Zip
3.4. Download Power BI Desktop
3.4.1. Create a Power BI Online Account
4. Cheat Sheets
4.1. https://docs.microsoft.com/en-us/power-bi/
4.2. https://www.techrepublic.com/article/microsoft-power-bi-a-smart-persons-guide/
4.3. https://pbicheatsheet.blob.core.windows.net/pbicheatsheet/Macaw%20Power%20BI%20cheat%20sheet%20EN.pdf
4.4. https://docs.microsoft.com/en-gb/dax/
4.5. https://docs.microsoft.com/en-gb/powerquery-m/index
4.6. https://oxcrx34285.i.lithium.com/t5/image/serverpage/image-id/10656i1E4A1F0FCD1C4429/image-size/large?v=1.0&px=999
4.7. https://docs.microsoft.com/en-us/power-bi/media/service-azure-and-power-bi/azure_4_complex.png
4.8. https://azure.microsoft.com/en-us/solutions/architecture/modern-data-warehouse/
4.9. https://databricks.com/blog/2019/02/07/high-performance-modern-data-warehousing-with-azure-databricks-and-azure-sql-dw.html
4.10. https://docs.microsoft.com/en-us/power-bi/whitepapers
5. Final Exercise
5.1. A "What If" Dashboard
5.1.1. EnterpriseDNA: Scenario Analysis in Power BI
5.1.2. Microsoft: Data Refresh in Power BI
6. Key Knowledge
6.1. ...need to knows before we start...
6.1.1. Power BI does “Business Intelligence”...
6.1.1.1. Energy Central: Analytics Curve
6.1.1.2. Weekdone: OKRs
6.1.1.3. Agile Analytics: Dashboard Example
6.1.1.4. Few: Why Most Dashboards Fail
6.1.2. Power BI Operates in a Data Pipeline...
6.1.2.1. Microsoft: Big Data Architectures
6.1.2.2. Microsoft: Enterprise Business Intelligence
6.1.2.3. Microsoft: Enterprise Data Warehouse Architecture
6.1.2.4. LearnSQL: Power BI Capabilities
6.1.2.5. Learnen Tech: How to Connect Excel Online To Power BI
6.1.3. Visual Analytics is a Process Discipline...
6.1.3.1. Tibco: What is Data Science?
6.1.3.2. Information is Beautiful: Information Design
6.1.3.3. UX Planet: 10 Rules for Better Dashboard Design
6.1.3.4. Roman Pilcher: Product Management
6.1.3.5. Map and Fire: Jobs to be Done
7. Four Deep Dive Scenarios
7.1. 1. Visual Analytics
7.1.1. Visual Analytics in Concept
7.1.1.1. McKinsey: Analytics Disciplines
7.1.1.2. Tufte: Graphical Excellence
7.1.1.3. Few: Why Most Dashboards Fail
7.1.1.4. PLOS: 10 Simple Rules for Better Charts
7.1.2. Visual Analytics in Practice
7.1.2.1. Hans Rosling
7.1.2.2. The Gapminder Visual
7.2. 2. Dashboard Experiences
7.2.1. Dashboard Experiences in Concept
7.2.1.1. Pediia: What is the Difference Between Slice and Dice
7.2.1.2. Juice: A Guide to Creating Dashboards People Love to Use
7.2.2. Dashboard Experiences in Practice
7.2.2.1. Microsoft: Cards
7.2.2.2. Microsoft: Slicers
7.2.2.3. Microsoft: Bookmarks
7.3. 3. Data Wrangling
7.3.1. Data Wrangling in Concept
7.3.1.1. Microsoft: Database Design Basics
7.3.1.2. Microsoft: Understand Star Schema and the Importance for Power BI
7.3.2. Data Wranging in Practice (pt.1)
7.3.2.1. Microsoft: M Query Language
7.3.2.2. Microsoft: Power Query Editor
7.3.2.3. ExceleratorBI: Data Design in Power BI
7.3.2.4. Global Innovation Index
7.3.3. Data Wrangling in Practice (pt.2)
7.3.3.1. Microsoft: Model Relationships in Power BI Desktop
7.3.3.2. Microsoft: Row Level Security
7.4. 4. Quantitative Analytics
7.4.1. Quantitative Analytics in Context
7.4.1.1. Microsoft: DAX Guide
7.4.1.2. DAX Patterns: Pattern Book
7.4.1.3. Microsoft: DAX Quickstart
7.4.2. Quantitative Analytics in Practice
7.4.2.1. Towards Data Science: Forecasting in Power BI
7.4.2.2. An Advanced DAX Pattern
7.4.2.2.1. XXLBI: Regression in DAX