Power BI Syllabus Advanced
Module 1: Introduction to Power BI
- Overview of Power BI and its components
- Understanding Power BI architecture
- Installation and setup of Power BI Desktop
- Exploring Power BI Interface
Module 2: Data Transformation Using
- Introduction to power query
- Data import and connections
- Data cleaning and Transformation
- Data shaping and Structuring
- Advanced Data transformations
Module 3: Data Exploration & Modeling
- Power BI Desktop Models: Star Schema, Analytic Queries, Report Visuals
- Choosing a Model Framework: Import, DirectQuery, Composite Models
- Designing a Semantic Model: Tables, Date Tables, Dimensions, Relationships, Cardinality
- Introduction to Dax
- Adding Measures: Simple, Compound, Quick Measures, Calculated Columns
- Using DAX Time Intelligence Functions
- Optimizing Model Performance
- Enforcing Model Security(RLS)
Module 4: Data Visualization & Storytelling
- Introduction to Power View – Visualization Basics
- Creating Basic Charts (Column, Bar, Pie, Map, etc.)
- Formatting Visuals and Report Pages
- Hierarchies: Drill-Up and Drill-Down
- Conditional Formatting (Background Color, Font Color, Data Bars, Icons)
- Grouping, Edit Interaction, Tooltips, and Drill-Through Reports
- Using ALLSELECTED, ALL, and IF Functions
- Creating What-if Parameters
Module 5: Advanced Analytics in Power BI
- Performing Analytics: Statistical Summary, Outliers, Clustering, Time Series, AI Visuals
- AI Features in Power BI:
- Q&A Visual
- Key Influencers
- Decomposition Tree
- Smart Narratives
- Performance Analyzer
- Analytics Pane: Adding Dynamic Reference Lines & Forecasting
Module 6: Dashboarding and Power BI
- Creating and Managing Workspaces and Dashboards
- Managing Semantic Models and Query Caching
- Data Refresh Using Data Gateways
- Creating and Publishing Reports to Power BI Service
- Implementing Row-Level Security (RLS) and Object-Level Security (OLS)
- Sharing Reports: Share & Subscribe Options
Module 7: Python in Power BI
- Running Python Scripts in Power BI Desktop
- Using Python in Power Query Editor
- Creating Power BI Visuals with Python
- External Python IDEs for Power BI
- Supported Python Packages
Module 8: Connecting to Data Sources & Databases
- Import Mode vs. DirectQuery Mode
- Connecting to Databases (SQL Server, Excel, Web, etc.)
- Automatic Page Refresh in DirectQuery Mode
- Connecting to AppSource for Custom Visuals
Module 9: Securing and Optimizing Reports
- Implementing RLS & OLS in Power BI
- Performance Optimization Strategies