Power BI is a business intelligence tool developed by Microsoft that transforms raw data into interactive dashboards and meaningful insights. It allows users to:
- Connect to multiple data sources
- Clean and transform data
- Build data models
- Create powerful visual reports
- Share insights securely
Introduction & Setup
Build a strong foundation in Power BI by understanding its core features, applications, installation, data sources and data types.
- Introduction
- Installation
- Applications
- Data Sources
- Data Types
- Power BI Free vs. Power BI Pro vs. Power BI Premium
Power Query
Develop practical data preparation skills by learning to clean, transform and reshape data using Power Query, Query Editor and M language.
- Query Editor
- Data Extraction & Transformation
- Working with Numbers
- Working with Dates
- Replacing Values
- Custom Columns
- Conditional Columns
- Pivot & Unpivot
- Merge & Append Queries
- M language
- Data refresh
- Excel Integration
Data Modeling
Learn to design efficient Power BI data models by understanding tables, star schema, relationships, filters and relationship management.
- Introduction
- Data Tables & Lookup Tables
- Star Schema
- Creating Table Relationships
- Editing Table Relationships
- Connect Multiple Data Tables
- Filters
- Active & Inactive Relationships
- Hiding tables, columns & fields
DAX (Data Analysis Expressions)
Learn to create dynamic calculations and measures with DAX by understanding measures, row context, filter context and commonly used functions.
DAX Functions
Dashboard & Visualization
Learn to turn data into meaningful insights by creating interactive reports and dashboards with visualizations, filters, slicers, formatting, drillthrough and forecasting
- Creating Dashboard
- Creating Reports
- Slicer
- Basic Charts & Visuals
- Conditional Formatting
- How to add Reports to Dashboards
- Using Charts: Bar, Column, Area, map, Waterfall, Treemap, Table
- Adding Trend Lines & Forecasts
- Power BI Report Filtering Options
- Exploring Data with Matrix Visuals
- Editing Power BI Report Interactions
- Adding Drillthrough Filters
Power BI Service
Learn to manage and collaborate on Power BI content by publishing reports, working with workspaces, securing data, configuring gateways and deploying apps.
- Publishing reports
- Workspaces
- Row Level Security (RLS)
- Data Gateway
- Publishing Power BI Apps
- Administration Role
- Self-Service Business Intelligence (SSBI)
Practice
Apply your Power BI skills through practical projects and strengthen your interview preparation with commonly asked Power BI questions.
