PL-300: Microsoft Power BI Data Analyst

1.–3.9.2026 | hybrid: Keilaranta 1 Business Park, Espoo

Ohjelma

Tiistaina 1.9.

09:00

Module 1: Get Started with Microsoft Data Analytics

  • Lessons
    • Data Analytics and Microsoft
    • Getting Started with Power BI
  • Lab : Getting Started in Power BI Desktop
    • Getting Started

Tauko

Module 2: Prepare Data in Power BI

Lessons

  • Get data from various data sources

Lab : Preparing Data in Power BI Desktop

  • Prepare Data

Lounastauko

Module 3: Clean, Transform, and Load Data in Power BI

  • Lessons
    • ORDER BY -komento
    • Harjoitukset
    • Data shaping
    • Enhance the data structure
    • Data Profiling
  • Lab : Transforming and Loading Data in Power BI Desktop
    • Loading Data

Kahvitauko

Module 4: Design a Data Model in Power BI

  • Lessons
    • Introduction to data modeling
    • Working with tables
    • Dimensions and Hierarchies
  • Lab : Data Modeling in Power BI Desktop
    • Create Model Relationships
    • Configure Tables
    • Review the model interface
    • Create Quick Measures
  • Lab : Advanced Data Modeling in Power BI Desktop
    • Configure many-to-many relationships
    • Enforce row-level security
16:00

Huomiseen! Ensimmäinen koulutuspäivä päättyy

Keskiviikkona 2.9.

09:00

Module 5: Create Model Calculations using DAX in Power BI

  • Lessons
    • Introduction to DAX
    • DAX context
    • Advanced DAX
  • Lab : Advanced DAX in Power BI Desktop
    • Use the CALCULATE() function to manipulate filter context
    • Use Time Intelligence functions
  • Lab : Introduction to DAX in Power BI Desktop
    • Create calculated tables
    • Create calculated columns
    • Create measures

Tauko

Module 6: Optimize Model Performance in Power BI

  • Lessons
    • Optimze the model for performance
    • Optimize DirectQuery Models
    • Create and manage Aggregations

Lounastauko

Module 7: Create Reports in Power BI

  • Lessons
    • Design a report
    • Enhance the report
  • Lab : Designing a report in Power BI Desktop
    • Create a live connection in Power BI Desktop
    • Design a report
    • Configure visual fields and format properties
  • Lab : Enhancing reports with interaction and formatting in Power BI Desktop
    • Create and configure Sync Slicers
    • Create a drillthrough page
    • Apply conditional formatting
    • Create and use Bookmarks

Kahvitauko

Module 8: Create Dashboards in Power BI

  • Lessons
    • Create a Dashboard
    • Real-time Dashboards
    • Enhance a Dashboard
  • Lab : Creating a Dashboard in Power BI Service
    • Create a Dashboard
    • Pin visuals to a Dashboard
    • Configure a Dashboard tile alert
    • Use Q&A to create a dashboard tile
16:00

Huomiseen! Toinen koulutuspäivä päättyy

Torstaina 3.9.

09:00

Module 9: Enhance reports for usability and storytelling in Power BI

  • Lessons
    • Paginated report overview
    • Create Paginated reports
  • Lab : Creating a Paginated report in Power BI Desktop
    • Use Power BI Report Builder
    • Design a multi-page report layout
    • Define a data source
    • Define a dataset
    • Create a report parameter
    • Export a report to PDF

Tauko

Module 10: Perform Advanced Analytics in Power BI

  • Lessons
    • Advanced Analytics
    • Data Insights through AI visuals
  • Lab : Data Analysis in Power BI Desktop
    • Create animated scatter charts
    • Use the visual to forecast values
    • Work with Decomposition Tree visual
    • Work with the Key Influencers visuals

Lounastauko

Module 11: Manage Datasets in Power BI

  • Lessons
    • Parameters
    • Datasets
    • Security in Power BIen

Kahvitauko

Module 12: Create and Manage Workspaces in Power BI

  • Lessons
    • Creating Workspaces
    • Sharing and Managing Assets
  • Lab : Publishing and Sharing Power BI Content
    • Map security principals to dataset roles
    • Share a dashboard
    • Publish an AppACTION
16:00

Kiitos! Koulutus päättyy