logo

Microsoft Certified: Azure Enterprise Data Analyst Associate (DP500)

In this four-day course, students will build on existing analytics experience and will learn to implement and manage a data analytics environment, query and transform data, implement and manage data models, and explore and visualize data. In this course, students will use Microsoft Purview, Azure Synapse Analytics, and Power BI to build analytics solutions.

Microsoft

A preferential rate (-15%) applies to the regular cost for non-profit organizations, as well as the government sector. In addition, you can benefit from additional advantages through a corporate agreement when you need to train several people or teams in your company. Contact us for details.

Public class

Virtual classroom
Tentative dateTentative date
To be determined 
1600 €
 
English
Virtual classroom
Tentative dateTentative date
April 24 2023
1600 €
 
English
1600 €
Duration: 
4 days / 28 hours

Private class

Virtual classroom
Minimum no. of participants: 4
4 days / 28 hours
Price on request
English or Serbian
Training plan: 

Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI (DP-500T00)

Module 1: Introduction to data analytics on Azure
This module explores key concepts of data analytics, including types of analytics, data, and storage. Students will explore the analytics process and tools used to discover insights and learn about the responsibilities of an enterprise data analyst and what tools are available to build scalable solutions.

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

Module 2: Govern data across an enterprise
This module explores the role of an enterprise data analyst in organizational data governance. Students will explore the use of Microsoft Purview to register and catalog data assets, to discover trusted assets for reporting, and to scan a Power BI environment.

  • 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
This module explores the use of Azure Synapse Analytics for exploratory data analysis. Students will explore the capabilities of Azure Synapse Analytics including the basics of data warehouse design, querying data using T-SQL, and exploring data using Spark notebooks.

  • Introduction to Azure Synapse Analytics
  • Use Azure Synapse serverless SQL pool to query files in a data lake
  • Analyze data with Apache Spark in Azure Synapse Analytics
  • Analyze data in a relational data warehouse
  • Lab : Query data in Azure
  • Lab : Explore data in Spark notebooks
  • Lab : Create a star schema model

Module 4: Prepare data for tabular models in Power BI
This module explores the fundamental elements of preparing data for scalable analytics solutions using Power BI. Students will explore model frameworks, considerations for building data models that will scale, Power Query optimization techniques, and the implementation of Power BI dataflows.
Lesson
Choose a Power BI model framework
Understand scalability in Power BI
Optimize Power Query for scalable solutions
Create and manage scalable Power BI dataflows
Lab : Create a dataflow

Module 5: Design and build scalable tabular models
This module explores the critical underlying aspects of tabular modeling for building Power BI models that can scale. Students will learn about model relationships and model security, working with direct query, and using calculation groups.

  • Create Power BI model relationships
  • Enforce model security
  • Implement DirectQuery
  • Create calculation groups
  • Use tools to optimize Power BI performance
  • Lab : Create model relationships
  • Lab : Enforce model security
  • Lab : Design and build tabular models
  • Lab : Create calculation groups
  • Lab : Use tools to optimize Power BI performance

Module 6: Implement advanced data visualization techniques by using Power BI
This module explores data visualization concepts including accessibility, customization of core data models, real-time data visualization, and paginated reporting.

  • 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
  • Lab : Monitor data in real-time with Power BI
  • Lab : Create and distribute paginated reports in Power BI Report Builder

Module 7: Implement and manage an analytics environment
This module explores key considerations for implementing and managing Power BI. Students will understand key recommendations for administration and monitoring of Power BI, including configuration and management of Power BI capacity.

  • Provide governance in a Power BI environment
  • Facilitate collaboration and sharing in Power BI
  • Monitor and audit usage
  • Provision Premium capacity in Power BI
  • Establish a data access infrastructure in Power BI
  • Broaden the reach of Power BI
  • Automate Power BI administration
  • Build reports using Power BI within Azure Synapse Analytics

Module 8: Manage the analytics development lifecycle
This module explores considerations for deployment, source control, and application lifecycle management of analytics solutions. Students will understand what to recommend and will be able to deploy and manage automated and reusable Power BI assets.

  • Design a Power BI application lifecycle management strategy
  • Create and manage a Power BI deployment pipeline
  • Create and manage Power BI assets
  • Lab : Create reusable Power BI assets

Exclusives: 
  • One FREE attendance to the Microsoft Certified: Azure AI Fundamentals (AI900) training
  • One year access to the class recording
  • 180 days access to the lab environment after class
  • One voucher to take the exam
  • Up to date courseware with Microsoft Learn
  • One year subscription to the All Access Pass library containing hundreds of complementary practice labs
  • Microsoft course achievement badge
Prerequisites: 
  • Candidates for this certification should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). They should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data.
Certification information: 
  • Exam code: DP-500
  • Cost: 0 (included in your training)
  • Skills measured
    • Implement and manage a data analytics environment
    • Query and transform data
    • Implement and manage data models
    • Explore and visualize data
  • All details

Contact us for more information on pricing::

Eccentrix
Office: 1-888-718-9732
E-mail: info@eccentrix.ca

130, King Street West, Suite 1800
Toronto, Ontario M5X 1E3
www.eccentrix.ca