Power BI Course
por Baraa Khatib Salkini
1. #1 Introduction
1.1. What is Data Visulization & BI
1.2. What is Power BI
1.3. How companies use Power BI today
1.4. Power BI vs Excel vs Tableau
1.5. Why Power BI
1.6. Power BI Products
1.6.1. Power BI Desktop
1.6.2. Power BI Service
1.6.3. Power BI Mobile
1.7. Power BI Architecture
2. #2 Power BI Essentials
2.1. Setting Up Power BI
2.2. Import Data
2.3. Tour into the Interface
2.4. Visuals 101
2.4.1. Bar
2.4.2. Line
2.4.3. Table
2.4.4. Card
2.5. Building Your First Dashboard
3. #3 Data Modeling
3.1. Basics
3.1.1. Dimension vs Fact tables
3.1.2. What is Data Modeling
3.1.3. Star vs Snowflake Schema
3.1.4. Normalization vs Denormalization
3.1.5. Creating Relationships in Model View
3.2. Power BI Modeling
3.2.1. Role-playing Dimensions
3.2.2. Relationships & Cardinality
3.2.3. Hiding , Formatting, Best Practices
4. #4 DAX - Analytics
4.1. What is DAX?
4.2. Calculated Columns vs Measures
4.3. Aggregation Functions
4.4. Time Intelligence
4.5. FILTER + CALCULATE + ALL
4.6. Variables & Performance Tips
4.7. Using SWITCH, IF, and Logical Functions
4.8. Error Handling & Debugging
5. #5 Power Query - ETL
5.1. What is Power Query
5.2. Query Folding & Performance
5.3. Column Transformations
5.4. Merge vs Append
5.5. Data Filtering
5.6. Parameters & Functions
5.7. Grouping & Aggregation
5.8. Best Practices & Tips
6. #6 Report Design UX
6.1. Report Layout
6.2. Themes & Templates
6.3. Elements: Titles, Shapes, Text
6.4. Navigation & Buttons
6.5. Bookmarks
6.6. Dynamic Page Navigation
6.7. Dynamic Titles & KPIs
6.8. Slicers
6.9. Drill-down & Drill-through
6.10. Tooltips
6.11. Best Practices & Tips
7. #7 Advanced Topics
7.1. What-if Parameters & Forecasting
7.2. Power BI & AI
7.3. Power BI & Python, R
7.4. Power BI & Excel
7.5. Power BI & Azure ML
7.6. Embeddding Power BI
7.7. Security
7.7.1. RLS