Microsoft Power BI Data Analyst

Course PL-300T00

  • Duration:
    • 3 days

Dates:

  • Implementation guarantee - still places available
  • 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.
  • Dates with this symbol are bookable both on-site and in the Virtual Classroom.
24.06.2024 - 26.06.2024 Virtual Classroom
  • 1990 EUR / Person
 German
12.08.2024 - 14.08.2024 Munich, Virtual Classroom
  • 1990 EUR / Person
 German
09.09.2024 - 11.09.2024 Leipzig, Virtual Classroom
  • 1990 EUR / Person
 German
07.10.2024 - 09.10.2024 Munich, Virtual Classroom
  • 1990 EUR / Person
 German
18.11.2024 - 20.11.2024 Virtual Classroom
  • 1990 EUR / Person
 German
09.12.2024 - 11.12.2024 Berlin, Virtual Classroom
  • 1990 EUR / Person
 German
27.01.2025 - 29.01.2025 Leipzig, Virtual Classroom
  • 1990 EUR / Person
 German
24.02.2025 - 26.02.2025 Cologne, Virtual Classroom
  • 1990 EUR / Person
 German
24.03.2025 - 26.03.2025 Virtual Classroom
  • 1990 EUR / Person
 German
28.04.2025 - 30.04.2025 Berlin, Virtual Classroom
  • 1990 EUR / Person
 German
26.05.2025 - 28.05.2025 Munich, Virtual Classroom
  • 1990 EUR / Person
 German
23.06.2025 - 25.06.2025 Virtual Classroom
  • 1990 EUR / Person
 German
This course explains the different methodologies 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 datasets and groups. This course also explains how to manage and deploy reports and dashboards for content sharing and distribution. Finally, this course will demonstrate 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 acquire the following skills:
  • Ingest, cleanse and transform data
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and run advanced report analysis
  • Manage and share reporting 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

Cleaning, transforming and loading data in Power BI
  • Structuring data
  • Improving the data structure
  • Creating data profiles
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 (enhanced)
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
  • Enhancing a dashboard
Enhancing reports for ease of use and content delivery in Power BI
  • Overview of paginated reports
  • Creating paginated reports
Performing advanced analysis in Power BI
  • Advanced Analysis
  • Data insights using AI visuals
Managing datasets in Power BI
  • Parameters
  • Datasets
  • Security in Power BI
Creating and managing 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 analysis using Power BI. This course is also for people who develop reports that visualise data from data platform technologies that exist both in the cloud and on-premises.
Successful Data Analysts need experience working with data in the cloud for this role.

This is especially true in the following cases:
  • Understanding of the main database concepts
  • Knowledge of working with relational data in the cloud
  • Knowledge of working with non-relational data in the cloud
  • Knowledge of data analytics and visualisation concepts.
You can meet the prerequisites and gain greater insight into working with data in Azure by taking the DP-900T00 Microsoft Azure Data Fundamentals course before taking this course.
This course prepares you for the PL-300 Microsoft Power BI Data Analyst exam.
The course price includes:
  • The original Microsoft training materials in English and digital form
  • Break catering for face-to-face training: drinks, biscuits, and lunch
We are also happy to conduct this training as an in-house seminar. Please ask for your individual 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!