Microsoft Fabric Analytics Engineer (DP-600)
Description
In this four-day training we focus on enterprise scale analytics and how you can shape this in your organization using Power BI and Azure.
In a good mix of theory and practice, we look at working with Azure Synapse , properly transforming and preparing data, and smartly building tabular models . We also pay attention to advanced data visualisations and the analytics lifecycle : the well-structured building, management and maintenance of your analytical solutions.
The content of the "Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI" training is aligned with the Microsoft exam of the same name , Exam DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI .
The training "Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI" is aimed at data analysts who have good working experience with Power BI.
As a participant, you are interested in how you can apply analytics in larger solutions within your organization, with all associated peripheral matters: from cleaning and transforming data to building larger data models and integrating with existing IT infrastructure.
After this training:
- You can query and transform data yourself
- You can implement and manage data models yourself
- You know how exploring and visualizing data can be done on a larger scale in the organization
- You know how a data analytics environment can be set up and managed efficiently
- Do you know the Azure ecosystem, and can products such as Synapse, Purview and Azure Data Lake Storage provide a place
- Do you know how Data Governance can be supported using Purview
- Do you know the difference between various Synapse services (Serverless SQL, Apache Spark, Dedicated SQL Pools)
- Do you know the difference between various Synapse services (Serverless SQL, Apache Spark, Dedicated SQL Pools)
- Know your storage and modeling considerations for Power BI data models.
Prerequisites to follow the Enterprise-Scale Analytics using Azure and Power BI (DP-500) training
To be able to follow the Enterprise-Scale Analytics using Azure and Power BI (DP-500) training, it is important that you are well versed in Power BI. You know how to build reports, and how to create reports yourself.
Prior knowledge of DAX, SQL or Power Query is not necessary (but everything is a bonus).
Course outline
- Introducing Analytics in Azure
- Azure Services for Analytics
- Analytics concepts
- Analytics- at-scale
- Data Governance in Large Organizations
- Introduction Data Governance and Microsoft Purview
- Find reliable data with Microsoft Purview
- Using the Data Catalog in Microsoft Purview
- Manage Power BI assets with Microsoft Purview
- Modeling, querying and exploring data in Azure Synapse
- Introducing Azure Synapse Analytics
- Use Azure Synapse serverless SQL
- Analyzing data with Apache Spark
- Analyzing data in a data warehouse
- Prepare data for Tabular Models in Power BI
- Choices for a Power BI model framework
- Scalability in Power BI
- Create and manage scalable Power BI Dataflows
- Designing and building Tabular Models and Power BI Datasets
- Relationships in Power BI
- DAX concepts
- calculation groups
- Power BI model security
- Tools to improve Power BI performance
- Advanced data visualization techniques in Power BI
- Advanced data visualization concepts
- Real time data in Power BI
- Set up and manage an Analytics environment
- Governance in a Power BI environment
- Facilitate collaboration and sharing in Power BI
- Monitor and audit Power BI usage
- Use premium capacity in Power BI
- Set up a data access infrastructure in Power BI
- Broaden the scope of Power BI
- Automate Power BI management
- Analytics Development Lifecycle: management and deployment of new analytics solutions
- Design an application lifecycle management (ALM) strategy for Power BI
- Power BI deployment pipelines
- Create and manage Power BI assets
Course material
In the training "Enterprise-Scale Analytics using Azure and Power BI (DP-500)" we use Microsoft Official Courseware. We will ensure that you receive this (digital) material at the start of the course.
Available dates
| Title | Date |
|---|---|
| DP-600 certificeringstraject dag 1/4 | |
| DP-600 certificeringstraject dag 2/4 | |
| DP-600 certificeringstraject dag 3/4 | |
| DP-600 certificeringstraject dag 4/4 |
| Title | Date |
|---|---|
| DP-600 certificeringstraject dag 1/4 | |
| DP-600 certificeringstraject dag 2/4 | |
| DP-600 certificeringstraject dag 3/4 | |
| DP-600 certificeringstraject dag 4/4 |
| Title | Date |
|---|---|
| DP-600 certificeringstraject dag 1/4 | |
| DP-600 certificeringstraject dag 2/4 | |
| DP-600 certificeringstraject dag 3/4 | |
| DP-600 certificeringstraject dag 4/4 |
