Course Description

Microsoft Azure and Power BI are essential tools. Maximizing data insights with enterprise-scale analytics is vital for driving business growth.

Learn the methods and practices for performing advanced data analytics at scale using Microsoft Azure and Microsoft Power BI. You will learn how to design, create, and deploy enterprise-scale data analytics solutions.

Students will learn how to clean and transform data, design and build enterprise data models, incorporate advanced analytics capabilities, integrate with IT infrastructure, and apply development lifecycle practices. Additionally, you will acquire advanced Power BI skills, such as Power Query and Data Analysis Expressions (DAX).

This course covers the objectives for Microsoft Exam DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions using Microsoft Azure and Microsoft Power BI.

The University of Calgary is Microsoft Education Global Training Partner.

Course Details

Learning Outcomes


By the completion of this course, students will be able to:

  • Query and transform data
  • Implement and manage data models.
  • Explore and visualize data.
  • Implement and manage a data analytics environment.


  • Introduction to data analytics on Azure
  • Model, query, and explore data in Azure Synapse
  • Prepare data for tabular models in Power BI
  • Design and build tabular models
  • Implement advanced data visualization techniques using Power BI
  • Implement and manage an analytics environment
  • Manage the analytics development lifecycle
  • Govern data across an enterprise


This course includes hands-on activities to reinforce the concepts taught and provide a practical learning experience.

Lab access will be provided at no additional cost.


No mandatory pre-requisite. 

Self-assessment for enrolment: 

A minimum of 6 months relevant working experience and knowledge in: 

  • Core data concepts and how they are implemented using Azure data services 
  • Designing and building data models, cleaning and transforming data, and enabling advanced analytic capabilities using Microsoft Power BI 


Recommended prerequisites: 

  • ICT-902/ICT-906 Microsoft Azure Data Fundamentals   
  • DAT 350 Microsoft Power BI Data Analyst 

Applies Towards the Following Program(s)

Enrol Now - Select a section to enrol in
Online Synchronous
8:00AM to 4:30PM
Jun 01, 2024 to Jun 22, 2024
Schedule and Location
Delivery Options
Course Fees
Flat Fee non-credit $979.00
Required Software
This course includes extensive hands-on activities designed to help you learn by working with Azure. To complete the labs in this course, you will need: A modern web browser such as Microsoft Edge Microsoft Azure Lab Access (will be provided at no additional cost)
Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

Students will require access to a computer with the required software, Internet connection, a headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Microsoft Teams or Zoom web conferencing software. The instructor will post the course outline and other materials in D2L. For more information, please visit our Online Learning Resources.

Unless notified, all online courses are available at 9 am MT the day before the start date. Students registered on (or after) the start date will receive access within one day of registration.

Students unfamiliar with online learning are encouraged to take our free Digital Skills for Learning Online course.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Required fields are indicated by .