course

NL/EN
This training is available in Dutch and English.More information

Design and manage analytics solutions using Power BI (PL-300)

Build quick, effective and interactive visuals, reports and dashboards to analyse your data.

Not yet scheduled
-No location
-
3 days
2175 (excl. VAT)

Description

In this course, you learn the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. Using a range of data source including both relational and non-relational, you access and process data with Power BI. Finally, you learn how to manage and deploy reports and dashboards for sharing and content distribution.

Audience Profile

The audience for this course is data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted at those individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.

Certification

This course also helps you prepare for the Associate exam PL-300 (Microsoft Certified: Power BI Data Analyst Associate)

Learning Goals

CheckmarkExplain how Power BI's components work together to turn raw data into actionable insights
UnderstandLogo InfoSupport
CheckmarkApply Power Query to extract, transform, and load data from multiple sources into Power BI
ApplyLogo InfoSupport
CheckmarkExplain how a semantic model uses relationships and calculations to represent business logic
UnderstandLogo InfoSupport
CheckmarkExplain how filter context determines the results of calculations in a data model
UnderstandLogo InfoSupport
CheckmarkImplement Power BI reports and dashboards that communicate findings clearly and support self-service exploration
ApplyLogo InfoSupport
CheckmarkApply data visualization and storytelling principles to enhance Power BI report usability
ApplyLogo InfoSupport
CheckmarkExplain how Power BI workspaces, apps, and row-level security control who can access and interact with published content
UnderstandLogo InfoSupport
For the above learning goals we use Bloom's Taxonomy

Prior Knowledge

Familiarity with data analysis concepts. No specific courses or certifications are required.

Subjects

  1. Get started with Microsoft data analytics
  2. Prepare data for analysis with Power BI
  3. Model data with Power BI
  4. Design effective reports in Power BI
  5. Manage and secure Power BI

1: Get started with Microsoft data analytics

Explore the role of a data analyst and how Power BI tools transform data into impactful reports and dashboards that support trusted, data-driven decisions across the business.

Lessons

  • Roles in data
  • Data Analysis tasks
  • Building blocks of Power BI
  • End-to-end analytics with Microsoft Fabric

2: Prepare data for analysis with Power BI

You'll learn how to use Power Query to extract data from different data sources, choose a storage mode, and connectivity type. You'll also learn to profile, clean, and load data into Power BI before you model your data.

Lessons

  • Get data in Power BI
  • Clean, transform, and load data

3: Model data with Power BI

Data modeling configures and shapes your prepared data to design a semantic model with the necessary relationships and calculations using Data Analysis Expressions (DAX). This process ensures accurate analysis and sets you up to create clear, impactful Power BI reports.

Lessons

  • Configure a semantic model
  • Create DAX calculations in semantic models
  • Modify DAX filter context
  • Use DAX time intelligence functions
  • Create visual calculations

4: Design effective reports in Power BI

Use data visualization and storytelling techniques to create insightful, dynamic Power BI reports that engage users, highlight key findings, and help inform decisions based on data.

Lessons

  • Design Power BI reports
  • Enhance reports for user experience
  • Perform analytics in Power BI
  • Get started with Copilot in Power BI
  • Optimize model performance (optional)

5: Manage and secure Power BI

Ensure content is accessible and distributed effectively in Power BI to foster collaboration and informed decision-making. Protect sensitive information with robust security, building trust across your organization.

Lessons

  • Manage workspaces in Power BI
  • Manage semantic models
  • Choose a content distribution method
  • Secure data access in Power BI

Schedule

All courses can also be conducted within your organization as customized or incompany training.

Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.

Prior knowledge courses

Follow-up courses

Certification

The knowledge from this training aligns with these certifications.

"Very pleasant teacher, gave a very good interpretation of the course in their own way. It was nice to follow the course like that."
Marieke
  • icon

    Hoge waardering

  • icon

    Praktijkgerichte trainingen

  • icon

    Gecertificeerde trainers

  • icon

    Eigen docenten