DP-605 : Prepare and visualize data with Microsoft Power BI

To attend this training, it is strongly recommended to have experience working with data in the cloud. Specifically:

• Understand basic data concepts.
• Have knowledge of working with relational or non-relational data in the cloud.
• Have knowledge of data analysis and visualization concepts.
• Attending the “AZ-900 Azure Fundamentals” training is a plus.

Build with Power BI

• Understand how Power BI apps and services work together.
• Explore how Power BI can make your business more efficient.
• Create engaging visuals and reports.

Get data in Power BI

• Log in and connect to a data source.
• Get data from a relational database, such as Microsoft SQL Server.
• Get data from a file, such as Microsoft Excel.
• Get app data.
• Get data from Azure Analysis Services.
• Select a storage mode.
• Troubleshoot performance issues.
• Fix data import errors.

Cleanse, transform, and load data in Power BI

• Resolve inconsistencies, unexpected or null values, and data quality issues.
• Apply user-friendly value overrides.
• Profile data to learn more about a specific column before using it.
• Evaluate and transform column data types.
• Apply data shape transformations to table structures.
• Combine queries.
• Apply user-friendly naming conventions to columns and queries.
• Edit M code in the Advanced Editor.

Design a semantic model in Power BI

• Create common date tables.
• Set up many-to-many relationships.
• Resolve circular relationships.
• Design star schematics.

Design Power BI reports

• Learn about the structure of a Power BI report.
• Learn about report objects.
• Select the appropriate type of visual to use.

Create interactive reports using Copilot for Power BI

• Design a semantic model.
• Create visuals and reports.
• Create summaries.

Describe end-to-end analytics in Microsoft Fabric.

Published on 01/20/2025

In this training, we mix theory with technical workshops to quickly make you operational. Additionally, each participant receives course materials at the end of the training.

One of our consultant trainers conducts the training. With solid field experience, they make the learning process both interactive and enriching.

For assessment, the trainer regularly asks questions and uses various methods to continuously measure your progress. This approach promotes a dynamic and engaging learning experience.

After the training, we ask you to complete a satisfaction questionnaire. Your feedback helps us to maintain and constantly improve the quality of our training.

Finally, we offer the flexibility to deliver this training both in-person and remotely, and it can be customized to meet your company’s specific needs upon request.

You can register for one of our training courses up to two business days before it starts, if there are still available places and you signed quote.

If you have specific needs related to a disability, please do not hesitate to make a request; we are happy to adjust our services according to the type of disability.