Monthly Subscription Starting at AED 99 + VAT

Microsoft PL-300 Exam Preparation and Practice
  • Level Foundation
  • Duration 1 hour
  • Course by Microsoft
  • Offered by

About

This course forms part of the Microsoft Power BI Analyst Professional Certificate.This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. This course will help you prepare for the Microsoft PL-300 exam. In this course you’ll refresh your knowledge of all the key areas assessed in the Microsoft-certified Exam PL-300: Microsoft Power BI Data Analyst. In addition, you will prepare for the certification exam by taking a mock exam with similar format and content as in the Microsoft PL-300 exam. You’ll also get tips and tricks, testing strategies, useful resources, and information on how to sign up for the Microsoft PL-300 proctored exam. This course is a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification. Earning a Microsoft Certification is globally recognized evidence of real-world skills. After completing this course, you'll be able to: ● Prepare the data ● Model the data ● Visualize and analyze the data ● Deploy and maintain assets

Modules

Welcome to the course

    • 1 Videos
    • 6 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • How do you prepare for the PL-300 Exam?

1 Videos

  • Course introduction

6 Readings

  • Course syllabus
  • How to be successful in this course
  • How to open an image in a new tab
  • Setting up your Power BI environment
  • New name for Power BI datasets
  • Additional resources: Microsoft PL-300 Exam resources

Microsoft Certification

    • 1 Videos
    • 5 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Have you found any good exam prep materials?

1 Videos

  • Introduction to preparing for the exam

5 Readings

  • How to prepare for the proctored examination
  • How the exam is administered
  • Topics covered in the Exam PL-300: Microsoft Power BI Data Analyst
  • Testing strategy
  • Additional resources: Microsoft certification

Get data from data sources

    • 4 Videos
    • 7 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-review: What did you learn?

4 Videos

  • Identify and connect to a data source
  • DirectQuery, Import, and Dual mode
  • Parameter values
  • Connecting to a dataflow

7 Readings

  • Connectors in Power BI
  • Shared dataset or local dataset
  • Activity: Set up a data source
  • Managing data sources
  • Microsoft Dataverse
  • In-depth: Get data from data sources
  • Additional resources: Get data from data sources

Profiling and cleaning data

    • 2 Videos
    • 4 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-review: What did you learn?

2 Videos

  • Evaluating data, data statistics, and column properties
  • Resolve inconsistencies and data quality issues

4 Readings

  • Activity: Analyze a dataset
  • Activity: Resolve data import errors
  • In-depth: Profiling and cleaning data
  • Additional resources: Profiling and cleaning data

Transform and load data

    • 5 Videos
    • 8 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-review: What did you learn?

5 Videos

  • Create and transform columns
  • Identify when to use reference queries
  • Merge and append queries
  • Table relationships
  • Module summary: Preparing data

8 Readings

  • Activity: Shape and transform tables
  • Activity: Table Transformations in Power Query
  • Splitting column data
  • Activity: Sorting columns
  • Activity: Configure data loading for queries
  • Activity: Find top performing products
  • In-depth: Transform and load data
  • Additional resources: Transform and load data

Design a data model

    • 4 Videos
    • 4 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-review: What did you learn?

4 Videos

  • Designing a schema
  • Implementing role-playing dimensions
  • Using CALCULATE to manipulate filters
  • Cardinality and cross-filter direction

4 Readings

  • Activity: Configure table and column properties
  • Activity: Common date tables
  • In-depth: Design a data model
  • Additional resources: Design a data model

Create model calculations using DAX

    • 4 Videos
    • 7 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-review: What did you learn?

4 Videos

  • Calculated Columns
  • Single aggregation measures
  • Implement time intelligence measures
  • Additive, semi-additive and non-additive measures

7 Readings

  • Activity: Add a SUM aggregation measure
  • Activity: Replacing implicit measures
  • Statistical functions cheatsheet
  • Activity: Create a semi-additive measure
  • Path DAX functions
  • In-depth: Create model calculations using DAX
  • Additional Resources: Create model calculations using DAX

Implement a data model

    • 2 Videos
    • 5 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-Review: What did you learn?

2 Videos

  • Calculated tables
  • Data hierachies

5 Readings

  • Activity: Adding a calculated table
  • Activity: Creating a report hierarchy
  • Activity: Add an Index Column
  • In-depth: Implement a data model
  • Additional Resources: Implement a data model

Optimize model performance

    • 3 Videos
    • 4 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-review: What did you learn?

3 Videos

  • Using the Performance Analyzer
  • Improve performancing via cardinality and summarization
  • Module summary: Modeling data

4 Readings

  • Activity: Optimal data types and reducing data
  • Best practices for SQL data sources
  • In-depth: Optimize model performance
  • Additional resources: Optimize model performance

Creating reports

    • 3 Videos
    • 9 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-Review: What did you learn?

3 Videos

  • Using appropriate visualizations
  • Configuring and formatting visualizations
  • Slicing and filtering

9 Readings

  • Activity: Format and configure visualizations
  • Activity: Conditional formatting
  • Activity: Configure the report page
  • Activity: Use a custom visual
  • Activity: Using the Play Axis visualization
  • Export and printing reports
  • Activity: Exporting and Importing Themes
  • In-depth: Creating reports
  • Additional Resources: Creating reports

Enhance reports for usability and storytelling

    • 5 Videos
    • 9 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-review: What did you learn?

5 Videos

  • Report navigation and sorting
  • Interactions between visuals
  • Sync slicers
  • Group and layer visuals by using the Selection pane
  • Design reports for mobile devices

9 Readings

  • Activity: Configure a bookmark
  • Activity: Create custom tooltips
  • Conditional formatting for buttons
  • Activity: Apply sorting
  • What is published with a report?
  • Activity: Using the Q&A feature for reports
  • Activity: Add the Q&A feature to a dashboard
  • In-depth: Enhance Reports for usability and storytelling
  • Additional resources: Enhance reports for usability and storytelling

Identify patterns and trends

    • 6 Videos
    • 6 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-Review: What did you learn?

6 Videos

  • Detect outliers and anomalies
  • Grouping and binning data
  • AI visuals
  • Reference lines and error bars
  • Scorecards and metrics
  • Module Summary: Visualize and Analyze data

6 Readings

  • Activity: Anomaly detection
  • Activity: Grouping data
  • Activity: Binning data
  • Activity: Using the Analyze feature
  • In-depth: Identify patterns and trends
  • Additional Resources: Identify patterns and trends

Create and manage workspaces and assets

    • 4 Videos
    • 7 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-Review: What did you learn?

4 Videos

  • Workspaces and workspace roles
  • Workspace apps
  • Subscriptions and data alerts
  • Promote or certify Power BI content

7 Readings

  • Activity: Create a workspace
  • Publish, import, or update assets in a workspace
  • Activity: Create dashboards
  • Activity: Apply sensitivity labels
  • Global options for files
  • In-depth: Create and manage workspaces and assets
  • Additional Resources: Deploy and maintain assets

Manage datasets

    • 4 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Self-Review: What did you learn?

4 Videos

  • Data gateways
  • Row-level security
  • Providing access to datasets
  • Module Summary: Deploy and maintain assets

3 Readings

  • Activity: Configure a dataset scheduled refresh
  • In-depth: Manage datasets
  • Additional Resources: Manage datasets

PL-300 Practice Exam

    • 1 Videos
    • 3 Readings
    • 2 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • PL-300 Mock Exam

2 Discussions

  • Which study techniques and strategies were the most helpful?
  • Exam reflections

1 Videos

  • Introduction to the PL-300 Exam

3 Readings

  • Preparing for the exam
  • Microsoft PL-300 Practice Assessment
  • Sign-up for the proctored exam

Role-specific Generative AI

    • 4 Videos
    • 3 Readings
    • 1 PeerReview
    • 2 Assignment
Show info about module content

2 Assignment

  • Troubleshooting DAX Formulas with Bing Copilot
  • Lesson Quiz: Microsoft Generative AI for Power BI

1 Peer Review

  • Peer Review

4 Videos

  • Understanding Microsoft Copilot
  • Understanding Copilot for Power BI Specialists
  • Enhancing Report Design with AI-assisted Tasks
  • Mastering DAX Formulas with Copilot

3 Readings

  • Navigating the risks and challenges when using Generative AI tools
  • Enhancing Power BI Reports with Copilot
  • Congratulations and looking forward

Course Wrap-up

    • 2 Videos
    • 2 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Reflect on learning

2 Videos

  • Congratulations
  • Day in the life

2 Readings

  • Career opportunities through learning
  • Next steps

Auto Summary

Prepare for the Microsoft PL-300 exam with this foundational course on Coursera, focusing on Big Data and Analytics. Taught by experts, this course is part of the Microsoft Power BI Analyst Professional Certificate. It covers key areas such as data preparation, modeling, visualization, and deployment. You'll also take a mock exam and receive tips and strategies for the real test. Ideal for aspiring data analysts, the course lasts 1 month and offers a Starter subscription. Earn the globally recognized Microsoft Power BI Data Analyst certification upon passing the exam.

Microsoft
Instructor

Microsoft