📞 +91-9456968800
✉️ contact@pixelcomputer.co.in
Introduction to Power BI
▶
- What is Power BI?
- Power BI vs Excel
- Power BI Desktop & Power BI Service
- Installation and Interface Overview
Data Loading & Transformation
▶
- Connecting to Data Sources
- Power Query Editor
- Data Cleaning & Transformation
- Data Types and Column Operations
Data Modeling
▶
- Relationships Between Tables
- Star & Snowflake Schemas
- Creating Calculated Columns & Measures
- Using DAX Basics
DAX Functions
▶
- Calculated Columns vs Measures
- Basic DAX Functions (SUM, AVERAGE, COUNT)
- Time Intelligence Functions (YTD, MTD, SAMEPERIODLASTYEAR)
- Filter Functions (CALCULATE, FILTER, ALL)
Visualizations
▶
- Bar, Column, Line, Pie Charts
- Cards, Gauges, and KPI Visuals
- Maps and Matrix Tables
- Custom Visuals from Marketplace
Interactive Dashboards
▶
- Creating Dashboards in Power BI Desktop
- Slicers and Filters
- Drill Through and Drill Down
- Bookmarks and Tooltips
Publishing & Sharing
▶
- Publishing to Power BI Service
- Creating and Sharing Reports Online
- Workspaces and Apps
- Scheduled Refresh and Gateway
Advanced Features
▶
- Row-Level Security
- Performance Analyzer
- Paginated Reports
- AI Visuals and Q&A
