Module 01: Introduction to Power BI
- Overview of Power BI
- Power BI Ecosystem and Components
- Combining Tables to Create a Model
- Power BI Licensing Options
- Power BI Desktop, Power BI Service, and Power BI Mobile App
- Power BI Service
- Power BI Mobile App
Module 02: Data Sources and Connections
- Types of Data Sources
- Template Apps
- Connecting to Data Sources
- For Power BI Desktop
- Importing Data from Various Sources
- Import Data from Online Services into Power BI
- Querying and Transforming Data
Module 03: Data Modeling
- Introduction to Data Modeling
- Creating Relationships between Tables
- Managing Data Relationships
- Creating Calculated Columns and Measures
Module 04: Data Visualization
- Introduction to Data Visualization
- Creating Basic Visualizations
- Customizing Visualizations
- Adding Shapes, Images, and Text box
- Formatting and Designing Reports
Module 05: Data Analysis
- Introduction to Data Analysis
- Filtering Data
- Sorting and Grouping Data
- Using Slicers, Timelines, and Charts
- Timelines
Module 06: Advanced Data Visualization
- Advanced Visualization Techniques
- Using Maps and Geographic Data
- Azure Maps
- Using Tables and Matrixes
- Using KPIs, Gauges and Cards
Module 07: Power BI Service
- Overview of Power BI Service
- Uploading and Sharing Reports
- Collaborating and Working with Others
- Using the Power BI Mobile App
Module 08: Power BI Data Gateway
- Introduction to Power BI Data Gateway
- Installing and Configuring Gateway
- Connecting to On-Premises Data Sources
- Managing Data Gateway
Module 09: Data Analysis Expressions (DAX)
- Introduction to DAX Language
- DAX Formula – Syntax
- DAX Functions for Power BI
- Advanced DAX Concepts
Module 10: Power BI Security and Administration
- Introduction to Power BI Security and Administration
- Managing User Access and Permissions
- Creating Security Roles and Rules
- Configuring Power BI Tenant Settings
Module 11: Power BI Embedding
- Introduction to Power BI Embedding
- Embedding Power BI Reports and Dashboards
- Embedding Power BI Tiles and Visuals
- Embedding Power BI in Websites and Applications
Module 12: Power BI and Excel Integration
- Introduction
- Import Excel to Power BI
- Using Excel as a Data Source for Power BI
- Embedding Power BI Reports in Excel
Module 13: Power BI Best Practices
- Best Practices for Data Modeling
- Best Practices for Data Visualization
- Best Practices for Report Design and Layout
- Best Practices for Performance Optimization
- Minimize Data Model Complexity
Module 14: Advanced Power BI Features
- Introduction to Advanced Power BI Features
- Using Power BI API
- Creating Custom Visuals
- Using Machine Learning in Power BI
Module 15: Power BI Case Studies
- Case Studies on How Power BI Is Used in Different Industries and Organizations
- Real-Life Examples of Power BI Solutions
- Best Practices for Building Power BI Solutions
- Tips for Success in Power BI Implementation
