# Program Roadmap

1. PROGRAM AT A GLANCE

Item

Details

Format

Live, instructor-led training

Duration

4 weeks, 38 hours

Schedule

Weekdays ( Monday & Wedesnday ) or ( Sunday & Tuesday ) - 7 to 9.30 PM Qatar /
Saudi Time )

Alignment

Microsoft PL-300 exam guidelines

Structure

3 learning tracks: Foundational, Technical, Speciality


2. THE ROADMAP: THREE LEARNING TRACKS

Track

What it covers

Purpose

Foundational

Power Query, Data Modelling, DAX & KPIs, Visualization

Core Power BI skills – from raw data to dashboards

Technical - Special Classes

Microsoft Fabric, PL-300 exam guidelines with Copilot for Excel, Power Automate,
Power Apps

Publishing, automation, AI and certification readiness

Speciality

Project Management, Financial Modelling, HR & Operations, Marketing & Sales

Applying skills to real business functions


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

Business area

Project you will build

Project Management

Portfolio management dashboard showing KPIs for all projects

Financial Modelling

Financial dashboard showing 3 years of revenue vs expenses

HR & Operations

HR dashboard with core KPIs for decision-making

Marketing & Sales

Sales and marketing dashboard to measure performance

Reporting automation

Automate daily, weekly and monthly reporting

Data refresh

Enable auto-sync between data sources and dashboards


6. TOOLS YOU WILL USE

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


7. CERTIFICATION PATHWAY

Certification

What it validates

Microsoft PL-300 – Power BI Data Analyst Associate

Power BI data analysis expertise

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 [https://wa.me/97470797089]

 * Email: Info@Teamacademy.net [info@teamacademy.net]

 * Website: www.teamacademy.qa [www.teamacademy.qa]

Connect with us [/article/1041-team-academy-connect-with-us] for requesting a
free demo class