Program Roadmap

1. Program at a Glance

2. The Roadmap: Three Learning Tracks

3. Foundational Track – Academic Classes

Module 1: Induction Class

• Introduction to Power BI

• Downloading Power BI and adjusting settings

• Introduction to the curriculum

• Exploring the Power BI Desktop interface and workflow

Module 2: Power Query

Getting data

• Getting started with Power Query

• Get data from file sources – Excel tables, PDF invoices and others

• Get data from online sources – SharePoint, Outlook, Dynamics 365, Web APIs and default connectors

• Get data from Fabric Warehouse – Dataflow

• Data access, path and permission settings

Cleaning and transforming

• Data validation steps and basic statistics

• Automate daily reports, timesheets and invoices using Append and Combine

• Prepare summary tables and aggregates

• Reshape operational data using Pivot and Unpivot

• Transform tables and generic columns

• Derive KPIs and flags using conditional and custom columns

• Apply logical transformations on values

Automating the workflow

• Build a reporting workflow and enable process automation using Applied Steps

• Automate lookup, filtering and reconciliation using Merge Query (SQL-style joins)

• Query settings, selective load and performance troubleshooting

• Case studies – practice with real business data scenarios

Module 3: Data Modelling

Model fundamentals

• What is data modelling?

• Jump start – connect to an existing semantic model

• Fact vs dimension tables; primary key vs foreign key

• Naming and sorting columns

• Normalization vs denormalization

• Difference between Merge and Relate

• Relationship types, cardinality and cross-filter direction

Model design

• Design a consistent star schema

• Snowflake schema for parent-child hierarchical reporting

• Date dimensions for automated monthly, weekly, daily and yearly reporting

• Bridge tables and many-to-many relationships for group-of-companies or portfolio reporting

• Hierarchies, groups and bins for categorical analysis

Model deployment

• Import vs DirectQuery from the source

• Row-level security – control access to reports and data by role

• Publish and manage automated data refresh to the semantic model in Fabric

• Optimize model performance

Module 4: DAX Functions & KPIs

• Simplify multi-dimensional KPI reporting using DAX, Quick Measures, Visual Calculations and Copilot

• Use DAX for columns, measures, tables and functions

• Display core business-process KPIs using Quick Measures

• Monthly, quarterly and yearly growth metrics

• Cross-functional KPIs – FinTech, Marketing Ops, Sales Tech

• Dynamic and real-time reporting

• Forecast future trends using historical data

Module 5: Visualization I

• Charts and graphs

• Tables and matrices

• Cards and KPIs

• Gauges

• Maps and geographic visualizations

• Slicers

• Filters

Module 6: Visualization II

• Drill-through and drill-down

• Bookmarks and interactivity

• Tooltips

• Themes and formatting

• Waterfall and funnel charts

• Custom visuals

4. Technical Track – Special Classes

Special Class 1: Microsoft Fabric

• Introduction to the Microsoft Fabric workspace

• Connecting Fabric to Power BI

• Sharing and scheduling Power BI reports

• Opening and presenting reports in PowerPoint

• Setting alerts for KPIs and performance tracking

• Analyzing data models in Excel and embedding reports

• Publishing and sharing dashboards on Power BI Service

• Managing workspaces, roles, refresh schedules and governance

Special Class 2: Power Apps & Power Automate Integration

• Introduction to the Power Platform

• Converting Excel data into a Power App

• Embedding Power Apps in Power BI dashboards

• Creating app-driven data entries and updates

• Setting up Power Automate flows for alerts and emails

• Automating tasks using BI data and KPI triggers

Special Class 3: Power BI MCP & AI with Claude and Copilot

• Connect Power BI semantic models to Claude and GPT models via native Power BI Model Context Protocol (MCP) – build AI-native semantic models, documentation and DAX using natural language

• Create enterprise AI agents and agentic frameworks with Power BI MCP data agents and Fabric connectors

• Prompt engineering for Power BI

• Connect Power BI semantic models to Excel pivots with Copilot

• Machine learning techniques and predictive analytics using Copilot, Claude and GPT models

PL-300 Exam Preparation

• Coverage aligned to Microsoft PL-300 exam guidelines, with Copilot for Excel

5. Speciality Track – Applied Internship Projects

6. Tools You Will Use

Power Query · SQL queries · Semantic modelling · DAX query · Visualization · Power Automate · Microsoft Fabric · Power Apps

7. Certification Pathway

Skills endorsed: Statistical and predictive analysis | DAX syntax | Data storytelling | Semantic modelling | Power BI & Fabric navigation | Data validation

8. Learning Support Included

• Comprehensive curriculum

• Live instructor-guided modules

• Weekly lecture uploads

• Lifelong LMS access

• Lifelong community access

• Certified Microsoft instructors

9. Need Help?

• Phone (Qatar): +974 70797089

• WhatsApp: +974 70797089

• Email: [email protected]

• Website: www.teamacademy.qa

Connect with us for requesting a free demo class