Training: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

Ref. DP-500T00
Duration:
4
 days
Exam:
Optional
Level:
Intermediate

Description

This course covers methods and practices for performing advanced data analytics at scale. You will build on existing analytics experience and you will learn to implement and manage a data analytics environment, query and transform data, implement and manage data models, and explore and visualize data. You will use Microsoft Purview, Azure Synapse Analytics, and Power BI to build analytics solutions.

Participant profiles

  • Solution architects
  • Data engineers
  • Data scientists
  • AI engineers
  • Database administrators
  • Power BI data analysts

Objectives

  • Implement and manage a data analytics environment
  • Query and transform data
  • Implement and manage data models
  • Explore and visualise data

Prerequisites

  • A foundational knowledge of core data concepts and how they’re implemented using Azure data services
  • Experience designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value using Microsoft Power BI

Course content

Module 1: Introduction to data analytics on Azure

  • Explore Azure data services for modern analytics
  • Understand concepts of data analytics
  • Explore data analytics at scale

Module 2: Govern data across an enterprise

  • Introduction to Microsoft Purview
  • Discover trusted data using Microsoft Purview
  • Catalog data artifacts by using Microsoft Purview
  • Manage Power BI artifacts by using Microsoft Purview

Module 3: Model, query, and explore data in Azure Synapse

  • Introduction to Azure Synapse Analytics
  • Implement star schema design and query relational data in Azure
  • Analyze data with a serverless SQL pool in Azure Synapse Analytics
  • Optimize data warehouse query design
  • Analyze data with a Spark Pool in Azure Synapse Analytics

Module 4: Prepare data for tabular models in Power BI

  • Choose a Power BI model framework
  • Understand scalability in Power BI
  • Optimize Power Query for scalable solutions
  • Create and manage scalable Power BI dataflows

Module 5: Design and build scalable tabular models

  • Create Power BI model relationships
  • Enforce model security
  • Implement DirectQuery
  • Create calculation groups

Module 6: Optimize enterprise-scale tabular models

  • Optimize performance using Synapse and Power BI
  • Improve query performance with hybrid tables, dual storage mode, and aggregations
  • Use tools to optimize Power BI performance

Module 7: Implement advanced data visualization techniques by using Power BI

  • Understand advanced data visualization concepts
  • Customize core data models
  • Monitor data in real-time with Power BI
  • Create and distribute paginated reports in Power BI report builder

Module 8: Implement and manage an analytics environment

  • Recommend Power BI administration settings
  • Recommend a monitoring and auditing solution for a data analytics environment
  • Configure and manage Power BI capacity
  • Establish a data access infrastructure in Power BI

Module 9: Manage the analytics development lifecycle

  • Recommend a deployment strategy for Power BI assets
  • Recommend a source control strategy for Power BI assets
  • Perform impact analysis of downstream dependencies from dataflows and datasets
  • Recommend automation solutions for the analytics development lifecycle, including Power BI REST API
  • Deploy and manage datasets by using the XMLA endpoint
  • Deploy reusable assets

Module 10: Integrate an analytics platform into an existing IT infrastructure

  • Recommend and configure a Power BI tenant or workspace
  • Identify requirements for a solution, including features, performance, and licensing strategy
  • Integrate an existing Power BI workspace into Azure Synapse Analytics

Documentation

  • Access to Microsoft Learn (online learning content)

Lab / Exercises

Official Microsoft Labs

  • Lab 1 : Model, query, and explore data in Azure Synapse
  • Lab 2 : Prepare data for tabular models in Power BI
  • Lab 3 : Design and build scalable tabular models
  • Lab 4 : Optimize enterprise-scale tabular models
  • Lab 5 : Implement advanced data visualization techniques by using Power BI
  • Lab 6 : Manage the analytics development lifecycle

Exam

  • This course prepares you to the DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI exam. If you wish to take this exam, please contact our secretariat who will let you know the cost of the exam and will take care of all the necessary administrative procedures for you.

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.
Prix de l'inscription
CHF 3'000.-
Inclus dans ce cours
  • 180 days lab access included
  • Up-to-date course materials with Microsoft Learn
  • Microsoft digital badge

lun27mar(mar 27)09:00jeu30(mar 30)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-500T00

lun27mar(mar 27)09:00jeu30(mar 30)17:00VirtuelVirtual Etiquettes de sessionDP-500T00

lun08may(may 8)09:00jeu11(may 11)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-500T00

lun08may(may 8)09:00jeu11(may 11)17:00VirtuelVirtual Etiquettes de sessionDP-500T00

lun12jun(jun 12)09:00jeu15(jun 15)17:00VirtuelVirtual Etiquettes de sessionDP-500T00

lun12jun(jun 12)09:00jeu15(jun 15)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-500T00

lun10jul(jul 10)09:00jeu13(jul 13)17:00VirtuelVirtual Etiquettes de sessionDP-500T00

lun10jul(jul 10)09:00jeu13(jul 13)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-500T00

lun14aug(aug 14)09:00jeu17(aug 17)17:00VirtuelVirtual Etiquettes de sessionDP-500T00

lun14aug(aug 14)09:00jeu17(aug 17)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-500T00

lun11sep(sep 11)09:00jeu14(sep 14)17:00VirtuelVirtual Etiquettes de sessionDP-500T00

lun11sep(sep 11)09:00jeu14(sep 14)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-500T00

lun09oct(oct 9)09:00jeu12(oct 12)17:00VirtuelVirtual Etiquettes de sessionDP-500T00

lun09oct(oct 9)09:00jeu12(oct 12)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-500T00

lun13nov(nov 13)09:00jeu16(nov 16)17:00VirtuelVirtual Etiquettes de sessionDP-500T00

lun13nov(nov 13)09:00jeu16(nov 16)17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-500T00

lun11dec(dec 11)09:00jeu14(dec 14)17:00VirtuelVirtual Etiquettes de sessionDP-500T00

lun11dec(dec 11)09:00jeu14(dec 14)17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-500T00

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X