*2025 - Intermediate Data Analytics on MS PowerBI (learn AI integration)

Course Description

In today’s highly competitive and data-driven business environment, business intelligence (BI) is crucial for informed decision-making. As organizations generate vast amounts of data through digital tools and increased storage capabilities, the need for powerful BI solutions to summarize, visualize, and extract meaningful insights becomes increasingly critical. Microsoft Power BI has emerged as an indispensable platform for transforming raw data into actionable insights and intelligence to support decision-making.

Over six weeks and four comprehensive modules, participants will gain practical experience working with real-world data and realistic case studies, focusing on both Power BI Desktop and Power BI Service. The course covers advanced topics such as enhancing data models with DAX, securing reports with row-level security (RLS), transforming data using the Power Query M language, and turning business questions into charts and dashboards. Learners will also explore the integration of AI features for text analytics, interactive report design with bookmarks and filters, and effective report sharing through Power BI Service.

Learning Outcomes

On successful completion of this course, learners will be able to:

1. Apply the Extract, Transform, Load (ETL) process in Power BI Desktop using data from various sources, including flat files, web content, folders, and databases.

2. Clean, transform, and shape data using Power Query and the M language to prepare it for analysis.

3. Enhance data models using Data Analysis Expressions (DAX) to create calculated columns and measures.

4. Design and customize reports in Power BI Desktop by integrating interactive elements such as buttons, shapes, text boxes, images, filters, and Q&A features.

5. Create and apply bookmarks to enable storytelling and improve report navigation.

6. Implement row-level security (RLS) to control access to data within Power BI reports.

7. Build and publish interactive reports and dashboards in Power BI Service.

8. Collaborate by sharing reports and dashboards securely with colleagues and stakeholders.

Course Format:

• Duration: 5-6 weeks (25 hours)
• Schedule: 1 session per week (Saturdays, 9am-2pm EST)
• Delivery: Fully online
• Time Commitment: Approx. 5 hours/week + optional assignments

The course includes assignments, in-class discussions, and a capstone project to help you apply what you’ve learned in a real-world context.

Who Should Apply:

This course is ideal for:

• Jobseekers looking to build in-demand analytical skills
• Newcomers interested in data analytics
• Small business owners and solopreneurs
• Anyone looking to strengthen their analytical skills

Eligibility:

• 18+
• Living in Canada
• Comfortable using a computer with a stable internet connection
• English language level CLB 6 or higher

Topics Covered Include:

Module 1: Connecting to External Sources in PowerBI Desktop

Module 2: Cleaning, Transforming and Shaping Data in Power Query

Module 3: Enhancing Reports in Power BI Desktop

Module 4: Creating Reports and Dashboards with Power BI Services

Evaluation Modalities

1. Individual in-class assignment

2. Weekly Quizzes

3. Home assignments

4. Individual Capstone Project

📝 Registration is now open. Space is limited—sign up today to reserve your spot!