1. Introduction to Power BI
• Why Power BI?
• Power BI vs. Tableau
• Power BI architecture & workflow
2. Connecting and Transforming Data
• Power BI’s front-end vs. back-end
• Types of data connectors (on-premise and online)
• Types of connection modes (import, directquery, live connection)
• Power Query interface & workflow
• Data profiling tools
• Table Transformations
o M language
o Creating Calendar table
o Appending/Merging queries
o Grouping/Aggregating
o Indexing
o Conditional Columns
o Pivoting/Unpivoting
o Transposing
o Appending files from a folder
o Data source settings
o Disabling queries from a load
• Best practices
3. Creating a data model
• What is a data model?
• What is NOT a data model?
• Database normalization
• Fact and Dimension Tables
• Primary and Foreign Keys
• Relationship creation
• Active vs. Inactive relationships
• Relationships cardinality
• Start and Snowflake Schemas
• Filter context and flow
• Hiding fields
• Model layouts
• Data formats and categories
• Hierarchies (Data granularity)
• Best practices
4. Advanced DAX calculations
• What is DAX?
o DAX syntax
o DAX operators
o Function categories (math&stats, counting, logical, text, date&time, time
intelligence)
o Interator functions
• M vs. DAX
• Calculated columns
• Measures
• Implicit and explicit measures
• Calculated columns vs. Measures
• Quick measures
• Measure table
• Filter context
• Best practices
5. Advanced Data visualization
• 3 key questions (type of data, communication, end-user)
• Data visualization principles and best practices
• Report Design Framework
• Types of visualization categories
• Types of visualization
o Cards, Multi-row cards
o KPIs
o Line charts, Bar charts etc.
o Donut, pie charts
o Table and matrix
o Slicers
o Maps
o Importing custom visuals
o Text box
o Shapes
o Buttons
o AI Visuals
- Parameters
• Condition formatting
• Drill Up&Down
• Interactions
• Bookmarks
• Tooltips
• Mobile layout
• Filters
o Basic
o Advanced
o TOPn
6. Optimization and Power BI Service
• Optimization best practices
• Power BI Service Interface
o Report publishing
o Distribution
o Power BI Service artifacts
o Collaboration
o Integration with Teams, Power Point, Excel, Share Point
o Integration with Power Apps and Copilot