Course Summary

This CertPREP Microsoft Power BI Data Analyst course focuses knowledge and understanding of the Microsoft Power BI data analysis tool, including preparing the data; modeling the data; visualizing and analyzing the data; and deploying and maintaining assets. Designed for data analysts, business intelligence professionals, and report creators who are seeking to validate their skills and knowledge in analyzing data with Power BI.

The goal of this course is to provide you with all the tools you need to prepare for the PL-300 Microsoft Power BI Data Analyst exam — including text explanations, video demos, lab activities, self-assessment questions, and a practice exam— to increase your chances of passing the exam on your first try.  

Methodology:

  • Lessons
  • Video learning
  • MeasureUp Practice Test for Microsoft PL-300. Practice Mode with remediation and Certification mode to simulate the test day experience.
  • Labs

Duration: 

Approximately 24 hours of primary content. Each learner will progress at their own pace.

Audience:  

Participants who are familiar with how to get, model, and visualize data in Power BI Desktop, as well as share reports with other people.

Prerequisites:  

  • 1-2 years of experience working in the field
  • Experience working with Microsoft Power BI

Required course materials:  

One seat of self-paced CertPREP Microsoft Power BI Data Analyst (PL-300) Courseware for each student.

Course objectives:  

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

  • Prepare the data
  • Model the data
  • Visualize and analyze the data
  • Deploy and maintain assets

Course Outline:

Lesson 1: Prepare the data
  • Skill 1.1: Get data from different data sources
  • Skill 1.2: Clean, transform, and load the data
Lesson 2: Model the data
  • Skill 2.1: Design a data model
  • Skill 2.2: Develop a data model
  • Skill 2.3: Design governance
  • Skill 2.4: Design identities and access for applications
Lesson 3: Visualize and analyze the data
  • Skill 3.1: Create reports
  • Skill 3.2: Create dashboards
  • Skill 3.3: Enhance reports for usability and storytelling
  • Skill 3.4: Identify patterns and trends
Lesson 4: Deploy and maintain assets
  • Skill 4.1: Manage files and datasets
  • Skill 4.2: Manage workspaces