Loading...

Course Description

This course teaches you how to use Power BI to transform raw data into meaningful insights. Learn how to connect to different data sources and apply transformations like merging and joining tables.

Students will learn about model relationships, and how you can connect different data tables in Power BI by creating relationships between them. Additionally, learn how to add calculations to your model using quick measures and work with dates and times in Power BI. This course will provide hands-on training and practical exercises.

This course is designed for non-technical business users.

Course Details

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

  • Use Power Query to extract, transform and load data (ETL)
  • Build data models using Power BI modelling and relationships
  • Connect PowerBI dashboards with Microsoft Forms and data sources on the Web

Topics:

  • Introduction to Power Query
  • Merge and append queries
  • Data modeling
  • Build relationships between tables
  • Calculated columns, measures and quick measures
  • Working with Dates and Time in Power BI
  • Connect Power BI with Microsoft Forms and online data sources on web

Prerequisites

There are no mandatory prerequisites for this course. You are expected to have fundamental understanding of core Microsoft Excel concepts such as worksheets, tables and formula.

Applies Towards the Following Program(s)

Loading...
Enrol Now - Select a section to enrol in
Type
Online Synchronous
Days
M
Time
6:00PM to 8:45PM
Dates
Sep 09, 2024 to Oct 07, 2024
Schedule and Location
View Details
Hours
14.0
Delivery Options
Online Synchronous  
Course Fees
Flat Fee non-credit $649.00
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 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 .