PL-300 Design and manage analytics solutions using Power BI

PL-300 Design and manage analytics solutions using Power BI

Course overview

The course provides you with a comprehensive overview of data analysis with Power BI and Microsoft Fabric – from raw data to insights.

You will learn the roles and responsibilities of a data analyst, how Power BI services and applications are connected, and how to connect, cleanse, and transform data. The course covers semantic modeling, DAX, advanced analytics and report design, and how to optimize model performance.

Advanced modules cover workspaces, dashboards, row-level security, and AI tools like Copilot in Power BI. The course concludes with an introduction to end-to-end analytics with Microsoft Fabric.

Course Objective

After the course, you can:

  • Retrieve, clean, and transform data
  • Modeling 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 course is aimed at those who:

  • Working with data or business intelligence and want to learn data analysis with Power BI
  • Develop reports that visualize data from cloud or on-premises platforms

Prerequisites

Microsoft does not impose any formal requirements, but to get the most out of the course you should have:

  • Basic understanding of data concepts, such as tables, relationships, and common visualization types
  • Knowledge of basic statistical concepts such as averages, sums, and trends
  • Some experience with Excel, such as pivot tables, charts, and formulas
  • Basic knowledge of data structures and various data sources, such as SQL databases, Excel files, and cloud services
  • General IT experience

Experience with Power BI Desktop and the Power BI service is an advantage but not a requirement. Introductory modules on Power BI on Microsoft Learn are good preparation.

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

Course content

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

  • Handle 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: Modify 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

  • Using 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

Examination and practical learning

The course does not include a formal exam, but the content largely follows the Microsoft Certified: Power BI Data Analyst Associate certification. During the course, you conduct interactive labs and knowledge checks where you apply key concepts in a real-world 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

Expression of interest