Power BI Training – Certification

মডিউল – ১ : Power BI পরিচিতি

• Business Intelligence (BI) কী
  
• Power BI Overview (Desktop, Service, Mobile, Report Server)
  
• Power BI Licensing (Free, Pro, Premium)
  
• Power BI Workflow / Architecture
  
• Installing Power BI Desktop
  
• Power BI Interface Basics

মডিউল – ২ : Data Loading & Power Query (ETL)

• বিভিন্ন উৎস থেকে ডেটা লোড (Excel, CSV, SQL, Web, Cloud)
  
• Power Query Editor পরিচিতি
  
• Data Cleaning & Shaping
  
• Transformations: Merge, Append, Pivot/Unpivot
  
• Calculated Columns, Conditional Columns
  
• M Language Concepts (Basic)

মডিউল – ৩ : Data Modeling

• Fact Table ও Dimension Table
  
• Relationship Creation (One-to-Many, Many-to-Many)
  
• Star Schema Model Design
  
• Hierarchy তৈরি (Date, Geography, Product)
  
• Calculated Tables & Columns
  
• Model View Best Practices

মডিউল – ৪ : DAX (Data Analysis Expressions) – Fundamentals

• DAX পরিচিতি
  
• Measure vs Calculated Column
  
• Basic DAX: SUM, COUNT, AVERAGE
  
• Logical Functions: IF, SWITCH
  
• Time Intelligence: YTD, MTD, QTD, Same Period Last Year
  
• Filter Context vs Row Context

মডিউল – ৫ : Visualization & Report Design

• Basic Visuals: Bar, Line, Pie, Table, Matrix
  
• KPIs, Cards, Maps, TreeMap
  
• Custom Visuals ব্যবহার
  
• Formatting & Themes
  
• Slicers, Filters, Drill-Through
  
• Bookmarks, Buttons & Navigation
  
• Dashboard UI/UX Best Practices

মডিউল – ৬ : Power BI Service

• Report Publish করা
  
• Workspaces & Apps
  
• Dataset Schedule Refresh
  
• Data Gateway (On-Premises)
  
• Sharing & Collaboration
  
• Row-Level Security (RLS)

মডিউল – ৭ : Advanced Analytics

• AI Visuals: Key Influencer, Decomposition Tree
  
• Forecasting & Trend Analysis
  
• What-If Parameters
  
• Python & R Visual Integration
  
• Advanced Data Modeling Tips

মডিউল – ৮ : Performance Optimization

• Model Optimization Techniques
  
• Reduce Model Size
  
• Efficient DAX (Variables, SUMX vs SUM)
  
• Incremental Refresh
  
• Large Dataset Handling

মডিউল – ৯ : Admin & Governance

• Power BI Admin Portal
  
• Tenant Settings
  
• Licensing & Capacity Planning
  
• Workspace Governance
  
• Usage Monitoring & Audit Logs

মডিউল – ১০ : Real-World Capstone Project

• Business Case সংগ্রহ
  
• End-to-End Build: Ingest → Transform → Model → Visualize
  
• Dashboard Finalization
  
• Publish, Share & Optimize
  
• Presentation & Evaluation