Microsoft Power BI Data Analyst

Course PL-300T00

  • Duration:
    • 3 days

Dates:

  • Durchführung geplant – noch Plätze verfügbar
  • Implementation - probability high - still places available
  • There are no more seats available. For many courses, it may still be possible to participate online, via virtual classroom.
  • Course times: As a rule, our seminars are held from 10:00 am to 5:00 pm on day 1 and from 9:00 am to 4:00 pm on the following days. Changes are possible. The concrete seminar times you will find in the binding order confirmation.
09.12.2024 - 11.12.2024 Berlin
  • 1990 EUR / Person
 German
27.01.2025 - 29.01.2025 Leipzig
  • 1990 EUR / Person
 German
24.02.2025 - 26.02.2025 Cologne
  • 1990 EUR / Person
German
24.03.2025 - 26.03.2025 Virtual Classroom
  • 1990 EUR / Person
 German
28.04.2025 - 30.04.2025 Berlin
  • 1990 EUR / Person
 German
26.05.2025 - 28.05.2025 München (Garching)
  • 1990 EUR / Person
 German
23.06.2025 - 25.06.2025 Virtual Classroom
  • 1990 EUR / Person
 German
11.08.2025 - 13.08.2025 Leipzig
  • 1990 EUR / Person
 German
13.10.2025 - 15.10.2025 Berlin
  • 1990 EUR / Person
 German
03.11.2025 - 05.11.2025 Virtual Classroom
  • 1990 EUR / Person
 German
08.12.2025 - 10.12.2025 Leipzig
  • 1990 EUR / Person
 German

This course explains the different methods and best practices that meet the business and technical requirements for modelling, visualising and analysing data with Power BI. The course also shows how to access and process data from a range of data sources, including relational and non-relational data. This course also explains how to implement appropriate security standards and policies across the Power BI spectrum, including data sets and groups. This course also explains how to manage and deploy reports and dashboards for content sharing and distribution. Finally, this course demonstrates how to create paginated reports within the Power BI service and publish them to a workspace for inclusion in Power BI.

In this course, participants will gain the following skills:
  • Ingest, cleanse and transform data
  • Modelling data for performance and scalability
  • Design and create reports for data analysis
  • Apply and run advanced report analyses
  • Manage and share report resources
  • Create paginated reports in Power BI
First steps with Microsoft data analysis
  • Data analysis and Microsoft
  • Getting started with Power BI
Preparing data in Power BI
Cleansing, transforming and loading data in Power BI
  • Data structuring
  • Improving the data structure
  • Data profiling
Designing a data model in Power BI
  • Introduction to data modelling
  • Working with tables
  • Dimensions and hierarchies
Creating model calculations using DAX in Power BI
  • Introduction to DAX
  • DAX context
  • DAX (extended)
Optimising model performance in Power BI
  • Optimising the model for performance
  • Optimising DirectQuery models
  • Creating and managing aggregations
Creating reports in Power BI
  • Designing a report
  • Improving the report
Creating dashboards in Power BI
  • Creating a dashboard
  • Real-time dashboards
  • Extending a dashboard
Improve reports for ease of use and content delivery in Power BI
  • Overview of paginated reports
  • Create paginated reports
Performing advanced analyses in Power BI
  • Advanced analysis
  • Data insights using AI visuals
Managing datasets in Power BI
  • Parameters
  • Datasets
  • Security in Power BI
Create and manage workspaces in Power BI
  • Creating workspaces
  • Sharing and managing resources

The target audience for this course is data professionals and business intelligence experts who want to learn how to perform accurate data analyses with Power BI. This course is also intended for individuals who develop reports that visualise data from data platform technologies that exist both in the cloud and on-premises.

Successful data analysts need experience of working with data in the cloud for this role.

This is especially true in the following cases:

  • Understanding of key database concepts
  • Knowledge of working with relational data in the cloud
  • Knowledge of working with non-relational data in the cloud
  • Knowledge of data analysis and visualisation concepts

You can fulfil the prerequisites and gain a better insight into working with data in Azure by attending the DP-900T00 Microsoft Azure Data Fundamentals course before attending this course.

Multi-factor authentication: Please note that enabling multi-factor authentication (MFA) is required to access the labs. The use of a mobile phone is essential for setup and verification with MFA. You will also need an app that can generate authentication codes - we recommend the free Microsoft Mobile Phone Authenticator. Please note that it will no longer be possible to use the Labs in future if you do not carry out this procedure.

This course prepares you for the PL-300 Microsoft Power BI Data Analyst exam.
The course price includes
  • The original Microsoft training documents in English and digital form
  • Break catering for face-to-face training: drinks, biscuits and lunch
We are also happy to organise this training as an in-house seminar. Please request a customised offer.

The course is offered in German and English.

Contact us

SoftwareONE

IT CAMPUS
Customer Training Solutions

Blochstraße 1
D-04329 Leipzig
*The services of SoftwareONE Deutschland GmbH directly serving school and educational purposes are predominantly VAT-exempt according to § 4 No. 21 a) bb) UStG. Contact us - we are happy to help!