Lifelong learning for working professionals

PL-300 Design and manage analytics solutions using Power BI

Course overview

This course provides an all-encompassing walkthrough in data analytics, Power BI, and Microsoft Fabric, equipping participants with the skills needed to turn raw data into actionable insights. Based on basic concepts, the course introduces the roles and responsibilities of a data analyst, the integration of Power BI services and applications, and methods for connecting, cleaning, and transforming data.
Participants will master semantic modeling, DAX functions, advanced analytics, and report design while optimizing model performance. Advanced modules cover workspace management, dashboard creation, row-level security, and leveraging AI-powered tools like Copilot in Power BI.
The course concludes with an introduction to end-to-end analytics using Microsoft Fabric, empowering participants to drive efficiencies in data-driven business environments.

Datum

Plats

Språk

Clear

Course Objective

After completing this course, 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 analysis
Managing and sharing report assets

Target Group

The target audience for this course is data professionals and business intelligence professionals who want to learn how to perform data analysis with Power BI in a proper way.
The course is also aimed at those people who develop reports that visualize data from data platform technologies that reside both in the cloud and on-premises.

Prerequisites

The PL-300: Microsoft Power BI Data Analyst course and exam is designed for individuals who want to demonstrate their expertise in analyzing data with Power BI. While there are no strict requirements from Microsoft, the following basic skills and knowledge are highly recommended to ensure success:

Prerequisites for the PL-300 course:

Basic Data Analysis Knowledge:
Understanding of data concepts, such as data tables, relationships, and common visualization types.
Familiarity with basic statistical concepts such as averages, sums, and trends.
Knowledge of Microsoft Excel:

Some experience with Excel functions such as pivot tables, charts and formulas is meritorious.
Understanding data sources:
Basic knowledge of data structures and how to work with different data sources, such as SQL databases, Excel files or cloud services.
Technical skills:

Ability to navigate and use software applications comfortably.
Familiarity with Power BI Desktop and Power BI Service is beneficial but not required.
General IT skills:

Awareness of basic IT concepts such as file systems, basic networking, and application installation.
Before starting the PL-300 course or attempting the exam, candidates should spend time familiarizing themselves with Microsoft Power BI through self-study or hands-on practice. Completing free or introductory Power BI training modules from Microsoft Learn can serve as an excellent starting point.

You can gain prior knowledge and a better understanding of working with data in Azure by completing the Microsoft Azure Data Fundamentals before taking this course.

Certification

Certification for this course can be purchased separately.

Trainer

This course is delivered in collaboration with one of Informator’s partners.

More about the course

Module 1: Getting started with Microsoft Data Analytics

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

Module 2: Retrieving data in Power BI

Identify and connect to a data source
Choosing a storage mode
Data profiling options
Resolving import errors

Module 3: Clean, transform, and load data

Address inconsistencies, unexpected or null values, and data quality issues
Apply data transformations to columns and table structures
Use user-friendly naming conventions

Module 4: Configuring a Semantic Model

Setting Modeling Options
Create and configure relationships
Configure table and column properties
Create hierarchies
Create quick metrics
Create numeric ranges and field parameters

Module 5: Creating DAX Calculations in Semantic Models

Understanding DAX concepts and syntax
Create calculated tables and columns
Create metrics
Using iterator functions

Module 6: Modifying DAX Filter Context

Understanding filter context
Using CALCULATE to change filter context
Using inactive relationships in DAX
Perform context transition

Module 7: Use DAX Functions for Time Intelligence

Create custom date tables for time intelligence
Using DAX functions for time intelligence

Module 8: Creating Visual Calculations

Understand visual calculations and how they differ from metrics
Create visual calculations in Power BI Desktop
Using parameters in visual calculations

Module 9: Designing Power BI Reports

Report structure
Report objects
Different visualization types
Filtration techniques

Module 10: Improving User Experience Reports

Present details and highlight key values
Build intuitive navigation and app-like experiences
Enhance the user experience with bookmarks, visual headers, and built-in assistance
Use specialized visualizations for unique reporting needs

Module 11: Performing Analytics in Power BI

Using the Analyze Feature
Group, create ranges, and cluster data
Identify patterns and trends

Module 12: Getting Started with Copilot in Power BI

Use Copilot in Power BI during report development
Prepare semantic models for use with AI
Interact with natural language data in Copilot Chat

Module 13: Managing Workspaces in Power BI

Describe the Power BI service and its building blocks
Create workspaces, choose license mode, and manage permissions
Publish reports to the Power BI service

Module 14: Managing Semantic Models

Use a Power BI gateway to connect to on-premises data sources
Configure scheduled refresh for a semantic model
Configure incremental refresh settings
Manage and promote semantic models
Improve performance with query caching
Using lineage and influence analysis

Module 15: Choose Your Content Distribution Method

Understand the different content distribution methods in Power BI
Create a Power BI app
Enforce data governance policies
Follow a report or dashboard item

Module 16: Ensuring Data Access in Power BI

Configure row-level security with static method
Configure row-level security with dynamic approach

Examinations and assessments
There are no formal exams included in this course, but the content is broadly aligned with the Microsoft Certified: Power BI Data Analyst Associate certification.
Participants complete interactive labs and knowledge checks to strengthen learning.
Hands-on learning
The course includes:

Hands-on labs to apply key concepts in a real-life environment.

Course overview

34500 kr

4 days

Advanced

Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to get an opportunity that suits.

För samtliga utbildningar gäller våra
Allmänna Villkor.

Company-adapted course

The course can be adapted from several perspectives:

Content and focus area
Scope of application
Structure

In collaboration with the course leader, we make sure that the course meets your wishes