Microsoft Copilot Foundations
1 Available
Power BI
7 Available
Foundations
Power BI environment, data sources, Import vs. DirectQuery, data quality, Power Query transformations, fact & dimension tables, and relationships.
Getting Data & Power Query
Data sources (Excel, SQL, SharePoint, CSV), Power Query transformations, Import vs. DirectQuery, data types, and practical filtering.
Why DAX? A Beginner's Introduction
The real business problems DAX solves — dynamic measures, targets vs. actuals, time comparisons. No syntax required.
DAX Fundamentals
COUNTROWS, CALCULATE, DIVIDE, SAMEPERIODLASTYEAR, TOTALYTD, calculated columns vs. measures — core DAX functions for exam and on the job.
Report Design & Best Practices
Visual selection, layout, conditional formatting, drill-through pages, KPI placement, and designing for different audiences.
Data Modeling & Relationships
Star schema, relationship cardinality, cross-filter direction, date tables, many-to-many patterns, and role-playing dimensions.
Power BI Service & Publishing
Publishing reports, workspace roles, scheduled refresh, data gateway, row-level security, Apps, dashboards vs. reports, deployment pipelines.
SharePoint Online
1 Available
MS Project Desktop 365
2 Available
Scheduling Fundamentals
Auto vs. Manual Schedule, project calendars, WBS & summary tasks, milestone governance, task dependencies, lag time, and resource scope limitations.
Executing, Monitoring & Controlling
Setting baselines, tracking % complete vs. actual work, the critical path, schedule variance, resource overallocation, task constraints, status dates, and project close.
DP-900: Azure Data Fundamentals
4 Available
Core Data Concepts
Structured vs. semi-structured vs. unstructured data, batch vs. streaming, analytics types (descriptive to prescriptive), key data roles, and OLTP vs. OLAP.
Relational Data in Azure
Primary and foreign keys, SQL SELECT fundamentals, normalization, Azure SQL Database vs. Managed Instance, and choosing the right relational service.
Non-Relational Data in Azure
Azure Blob Storage, Cosmos DB global distribution, NoSQL data models (document, key-value, graph), Data Lake Gen2, and Azure Data Explorer for time-series.
Analytics Workloads in Azure
Data warehousing concepts, Azure Synapse Analytics, Azure Stream Analytics for real-time processing, Power BI workflow, and the modern ELT analytics pipeline.
Coming Soon
In Development
Coming Soon
Power BI: Row-Level Security & Governance
Advanced RLS patterns, dynamic security, object-level security, and governance best practices.
