Detailed Syllabus

Every module strictly restored for full technical accuracy.

  • What is Business Intelligence (BI)?
  • Ecosystem: Desktop, Service, Mobile, Gateway
  • Installing and UI Workflow Overview
  • Excel, CSV, PDF and Web data connectors
  • SQL Server, MySQL, and Oracle integration
  • Import vs DirectQuery vs Live Connection modes
  • Query Editor basics and data profiling
  • Merging and Appending queries
  • Parameterization and M Language basics
  • Relationships and Cardinality (1:1, 1:M, M:M)
  • Star vs Snowflake Schemas
  • Hierarchies and Performance Optimization
  • Calculated Columns vs Measures
  • Time Intelligence: YTD, MTD, SamePeriodLastYear
  • Filter Context: CALCULATE, FILTER, ALL
  • Advanced Variables & Virtual tables
  • Waterfall, Funnel, Treemap, KPI charts
  • UX Design: Bookmarks and Navigation
  • Slicers, Advanced Tooltips, and custom visuals
  • Natural Language Queries (Q&A)
  • Decomposition Trees and Key Influencers
  • Smart Narratives and Forecasting Trends
  • Workspaces, Apps, and Dashboard publishing
  • Data Refresh Scheduling and Gateway setup
  • Collaboration and permission management
  • Mobile Layout design
  • Optimizing responsive dashboard UX
  • Static and Dynamic Row-Level Security (RLS)
  • Role-based access control and workspace layers
  • SharePoint and Excel integration
  • Power Automate and Power BI workflows
  • Query Diagnostics and Aggregations
  • DAX Optimization for high-volume datasets
  • Sales & Finance Dashboards
  • HR Analytics and Logistics Case Studies
  • Cleaning → Modeling → Presentation workflow
  • PL-300 Exam Blueprint review
  • Practice tests and Interview Q&A