Loading...

Course Description

Connect to and visualize any data using the unified, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight.

Students will examine the various methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. You will learn how to access and process data from various sources, including relational and non-relational data. Implement proper security standards and policies across the Power BI spectrum, including datasets and groups, manage and deploy reports and dashboards for sharing and content distribution, and enable advanced analytic capabilities that provide meaningful business value.

This course covers the objectives for Microsoft Exam PL-300: Microsoft Power BI Data Analyst. This exam is required to fulfil the requirements of the Microsoft Certified: Power BI Data Analyst Associate professional certification.

Students enrolled in this course will be eligible to purchase the Microsoft exam voucher at a discounted rate.

Course Details

Learning Outcomes

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

  • Ingest, clean, and transform data
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and perform advanced report analytics
  • Manage and share report assets

Topics

Module 1: Get Started with Microsoft Data Analytics

Explore the different roles in the data space, outlines the important roles and responsibilities of a Data Analysts, and then explore the landscape of the Power BI portfolio.

Module 2: Getting Data in Power BI

This module explores identifying and retrieving data from various data sources. Learn the options for connectivity and data storage and understand the difference and performance implications of connecting directly to data vs. importing it.

Module 3: Cleaning, Transforming, and Loading Data in Power BI

This module teaches you the process of profiling and understanding the condition of the data. Learn how to identify anomalies, look at the size and shape of their data, and perform the proper data cleaning and transforming steps to prepare the data for loading into the model.

Module 4: Design a Data Model in Power BI

Module four teaches the fundamental concepts of designing and developing a data model for proper performance and scalability. Understand and tackle many of the common data modeling issues, including relationships, security, and performance.

Module 5: Create Model Calculations using DAX in Power BI

This module introduces you to the world of Data Analysis Expressions (DAX) programming language. Students will be exposed to enhancing a model and its true power. Learn about aggregations and the concepts of Measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems.

Module 6: Optimize Model Performance in Power BI

Students are introduced to steps, processes, concepts, and data modeling best practices necessary to optimize a data model for enterprise-level performance.

Module 7: Create Reports in Power BI

Module seven introduces you to the fundamental concepts and principles of designing and building a report, including selecting the correct visuals, creating a page layout, and applying basic but critical functionality. The vital topic of designing for accessibility is also covered

Module 8: Create Dashboards in Power BI

Learn how to tell a compelling story using dashboards and the different navigation tools available to provide navigation. You will be introduced to features and functionality and how to enhance dashboards for usability and insights.

Module 9: Identify Patterns and Trends in Power BI

Apply additional features to enhance the report for analytical insights within the data, equipping you with the steps to use the report for actual data analysis. Perform advanced analytics using AI visuals on the report for even deeper and more meaningful data insights.

Module 10: Create and Manage Workspaces in Power BI

This module will introduce you to Workspaces, including how to create and manage them. Discover how to share content, including reports and dashboards, and then learn how to distribute an App.

Module 11: Manage Files and Datasets in Power BI

This module will introduce you to parameters and datasets. Learn how to manage datasets and parameters, build dynamic reports with parameters, and set dataset refresh options.

Module 12: Row-level Security in Power BI

In Module twelve, students will understand how to implement row-level security using the Static and Dynamic methods.

Who is this course for?

The audience for this course is those individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.

This course is designed for learners who wish to pursue future careers like:

  • Data Analyst
  • Business Analyst
  • Reporting Analyst
  • Power BI Analyst

Notes

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)

Prerequisites

There are no mandatory pre-requisites for this course. However, you are required to perform a self-assessment to ensure you meet the requirements to enroll.

Self-assessment for enrolment

  • Fundamental understanding of core data concepts, knowledge of working with relational data in the cloud 
  • Knowledge of working with non-relational data in the cloud
  • Knowledge of data analysis and visualization concepts. 

Recommended Pre-requisites

Applies Towards the Following Program(s)

Loading...
Enrol Now - Select a section to enrol in
Type
Online Synchronous
Days
T, Th
Time
5:00PM to 8:00PM
Dates
Mar 14, 2023 to Apr 13, 2023
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $975.00
Required Software
This course includes extensive hands-on activities designed to help you learn by working. To complete the labs in this course, you will need: A modern web browser - for example, Microsoft Edge A Microsoft Azure subscription (which will be provided)
Reading List / Textbook

Microsoft official courseware will be provided.

Section Notes

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

This course uses:

  • Desire2Learn (D2L), an online learning management system. The instructor will post the course outline and other materials in D2L.
  • Zoom or MS Teams web conferencing software.

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 registering 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.

Type
Online Synchronous
Days
T, Th
Time
5:00PM to 8:00PM
Dates
May 30, 2023 to Jun 29, 2023
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $975.00
Required Software
This course includes extensive hands-on activities designed to help you learn by working. To complete the labs in this course, you will need: A modern web browser - for example, Microsoft Edge A Microsoft Azure subscription (which will be provided)
Reading List / Textbook

Microsoft official courseware will be provided.

Section Notes

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

This course uses:

  • Desire2Learn (D2L), an online learning management system. The instructor will post the course outline and other materials in D2L.
  • Zoom or MS Teams web conferencing software.

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 registering 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 .