Power BI Course • SGM Computer Education

• What is Business Intelligence (BI)?
• Overview of Power BI ecosystem: Desktop, Service, Mobile, Gateway
• Installing Power BI Desktop
• Power BI Interface Overview & Workflow

• Connecting to Excel, CSV, Text, PDF
• Connecting to Databases: SQL Server, MySQL, Access, Oracle
• Connecting to Web, APIs, SharePoint
• DirectQuery vs Import Mode
• Data Refresh Concepts

• Power Query Editor basics
• Combine / Append / Merge Queries
• Remove duplicates, split columns, transform data types
• Data profiling: column quality & distribution
• Parameters, Lookup tables, Advanced Editor & M language basics

• Understanding Data Models & Relationships
• Cardinality: 1:1, 1:M, M:M
• Star Schema vs Snowflake Schema
• Fact & Dimension tables, Hierarchies
• Normalization, Denormalization & Performance optimization

• What is DAX? Calculated Columns vs Measures
• Common functions: SUM, AVERAGE, COUNT

• Logical, Text, Date & Math functions
• Filter functions: FILTER, ALL, CALCULATE
• Time intelligence: YTD, MTD, QTD, SamePeriodLastYear

• Row context vs Filter context, Context transition
• Using VAR for variables
• Virtual tables: SUMMARIZE, ADDCOLUMNS
• Optimization and troubleshooting techniques

• Choosing the right chart & formatting
• Bar, Column, Line, Pie, Map, Waterfall, Funnel, TreeMap, Gauge, KPI, Matrix & Table
• Slicers, Filters, Tooltips (Basic & Advanced)
• Bookmarks, Buttons, Navigation & Report UX
• Custom visuals, infographics & dashboard design best practices

• Q&A (Natural Language Queries)
• Decomposition Tree & Key Influencers
• Smart Narratives, Forecasting & Trend Analysis
• Row-level predictions & Integration with Azure/Machine Learning

• Publishing reports to Power BI Service
• Workspaces, Dashboards vs Reports, Apps
• Sharing, Permissions & App creation
• Scheduling data refresh & Power BI Gateway
• Collaboration features & comments

• Mobile Layout View
• Designing mobile-responsive dashboards
• Mobile app usage & features

• Row-Level Security (RLS): Static & Dynamic
• Workspace roles & access control
• Data layer security best practices

• Integrating Power BI with Excel & SharePoint
• Embedding Power BI in web applications
• Exporting to PDF, PPT, Excel
• Power Automate + Power BI workflows

• Model size optimization & removing unused columns
• Aggregations & query diagnostics
• DAX optimization & report rendering improvements

Choose industry projects such as:

• Sales Dashboard
• Finance Dashboard
• HR Analytics
• Retail Superstore MIS Dashboard
• Inventory & Logistics Dashboards
• Education / Healthcare / Marketing Dashboards

Hands-on workflow: requirement gathering → data cleaning → modeling → DAX → visualization → publish → RLS → final presentation.

• PL-300 / DA-100 exam blueprint & topics
• Practice questions & mock tests
• Interview Q&A & practical assessment