Highlights

Here are some of the highlights for this micro-credential.

  • No admission requirements, no application process, no pre-requisites, open to anyone

  • Take up to 90 days to complete the course

  • Learn at your own pace using a computer, tablet or smartphone

  • Receive a certificate of course completion and digital badge for successfully completing the course which can be shared on social media (e.g. LinkedIn, Facebook, Twitter), downloaded as a PDF, or even embedded in an email signature

Overview

In this 8-hour micro-credential you will learn about Power Query and how to use this tool to import, transform, and organize data for analysis. Additionally, you will explore its key features and recognize four important stages (Connect, Transform, Combine, Load), as well as practice linking to data sources, cleaning data, and loading it into Excel. Lastly, you will compare transformation methods for efficiency and create workflows to consolidate data and build interactive reports.

Learners who successfully complete the course will earn a digital badge and certificate of course completion that can be downloaded and shared via social media. 

You will have access to the course for 90 days to work through the content.

Skills & Competencies

Upon successful completion of this micro-credential, you should be able to:

  • Use Power Query to connect to various data sources, transform data (e.g., remove duplicates, change data types), and load data into Excel.

  • Use transformation techniques to optimize data preparation.

  • Create a data consolidation workflow with interactive reports using Power Query.

Curriculum

    1. Land Acknowledgement

    2. Accessibility, Diversity, Equity, and Inclusion (IDEA) Statement

    3. Introduction from Sault College's eLearning Department

    4. What is asynchronous online self-directed learning?

    5. Learner Resources and Supports

    6. Technology Requirements

    7. Privacy and Accessibility Policies

    8. Navigation

    9. Learner Introductions

    10. Technical Discussion Forum

    11. Frequently Asked Questions

    12. Help & Contact Information

    1. Before we begin...

    2. Welcome and Micro-credential Information

    3. Micro-credential Overview

    4. Learning Outcomes & Goals

    5. Modes of Learning

    1. Working with Power Query in MS Excel

    2. Discussion Forum

    3. Final Quiz

    1. Thank you

    2. Before you go...

    3. Congratulations

About this course

  • $125.00