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

This 20-hour micro-credential offers an in-depth exploration of advanced techniques in Power BI, focusing on Power Query, data visualization, and integration with Microsoft tools. You will enhance your skills in transforming and optimizing data, creating custom visualizations, and seamlessly integrating Power BI with Excel, SharePoint, and Teams.

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.

Learning Outcomes

Upon successful completion of this course, learners should be able to:

  • Sketch a detailed plan of action explaining the steps to optimize the Power Query related to a scenario considering strategies like filtering data, removing unnecessary columns, simplifying transformations, and any other techniques that could enhance the performance of the dashboard.

  • Plan a Power Query approach to ensure optimized performance and data quality.

  • Configure the right custom visuals in Power BI to enhance the functionality and user experience of a dashboard while ensuring optimal performance and security.

  • Describe designing interactive elements in the dashboard to enable the customer support team to effectively analyze and gain insights from the data.

  • Explain ways to ensure data accuracy and consistency in Excel and steps to be taken in Power BI to optimize the performance of the dashboard.

  • Discuss the process to import the SharePoint data into Power BI ensuring it is properly loaded and transformed.

  • List strategies that can be used to ensure that all team members can easily access and effectively use the Power BI reports within Teams.

  • Integrate Power BI with Microsoft Excel, SharePoint, and Teams to streamline data workflows and enhance collaboration.

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. Discussion Forum: Learner Engagement

    11. Technical Discussion Forum

    12. Frequently Asked Questions

    13. 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. Integrating Advanced Power BI Features and Techniques

    2. Quiz

    1. Power BI Integration with Microsoft Tools

    1. Thank you

    2. Before you go...

    3. Congratulations

About this course

  • $260.00