reserve a seat

Description
Content
Intendent To
Certificates

This course covers methods and practices for performing advanced data analytics at scale.

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.

LEARNING PATH 1
Introduction to data analytics on Azure

Module 1: Explore Azure data services for modern analytics
Module 2: Understand concepts of data analytics
Module 3: Explore data analytics at scale

LEARNING PATH 2
Govern data across an enterprise

Module 1: Introduction to Microsoft Purview
Module 2: Discover trusted data using Microsoft Purview
Module 3: Catalog data artifacts by using Microsoft Purview
Module 4: Manage Power BI assets by using Microsoft Purview
Module 5: Integrate Microsoft Purview and Azure Synapse Analytics

LEARNING PATH 3
Model, query, and explore data in Azure Synapse

Module 1: Introduction to Azure Synapse Analytics
Module 2: Use Azure Synapse serverless SQL pool to query files in a data lake
Module 3: Analyze data with Apache Spark in Azure Synapse Analytics
Module 4: Analyze data in a relational data warehouse

LEARNING PATH 4
Prepare data for tabular models in Power BI

Module 1: Choose a Power BI model framework
Module 2: Understand scalability in Power BI
Module 3: Create and manage scalable Power BI dataflows

LEARNING PATH 5
Design and build tabular models

Module 1: Create Power BI model relationships
Module 2: Use DAX time intelligence functions in Power BI Desktop models
Module 3: Create calculation groups
Module 4: Enforce Power BI model security
Module 5: Use tools to optimize Power BI performance

LEARNING PATH 6
Implement advanced data visualization techniques by using Power BI

Module 1: Understand advanced data visualization concepts
Module 2: Monitor data in real-time with Power BI
Module 3: Create paginated reports

LEARNING PATH 7
Implement and manage an analytics environment

Module 1: Provide governance in a Power BI environment
Module 2: Monitor and audit usage
Module 3: Broaden the reach of Power BI
Module 4: Build reports using Power BI within Azure Synapse Analytics

LEARNING PATH 8
Manage the analytics development lifecycle

Module 1: Design a Power BI application lifecycle management strategy
Module 2: Create and manage a Power BI deployment pipeline
Module 3: Create and manage Power BI assets

Candidates for this course should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.

Specifically, candidates 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.

Microsoft Certified: Azure Enterprise Data Analyst Associate after successful completion of the Exam DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

Description

This course covers methods and practices for performing advanced data analytics at scale.

In this course, students will use Microsoft Purview, Azure Synapse Analytics, and Power BI to build analytics solutions.

Content

LEARNING PATH 1
Introduction to data analytics on Azure

Module 1: Explore Azure data services for modern analytics
Module 2: Understand concepts of data analytics
Module 3: Explore data analytics at scale

LEARNING PATH 2
Govern data across an enterprise

Module 1: Introduction to Microsoft Purview
Module 2: Discover trusted data using Microsoft Purview
Module 3: Catalog data artifacts by using Microsoft Purview
Module 4: Manage Power BI assets by using Microsoft Purview
Module 5: Integrate Microsoft Purview and Azure Synapse Analytics

LEARNING PATH 3
Model, query, and explore data in Azure Synapse

Module 1: Introduction to Azure Synapse Analytics
Module 2: Use Azure Synapse serverless SQL pool to query files in a data lake
Module 3: Analyze data with Apache Spark in Azure Synapse Analytics
Module 4: Analyze data in a relational data warehouse

LEARNING PATH 4
Prepare data for tabular models in Power BI

Module 1: Choose a Power BI model framework
Module 2: Understand scalability in Power BI
Module 3: Create and manage scalable Power BI dataflows

LEARNING PATH 5
Design and build tabular models

Module 1: Create Power BI model relationships
Module 2: Use DAX time intelligence functions in Power BI Desktop models
Module 3: Create calculation groups
Module 4: Enforce Power BI model security
Module 5: Use tools to optimize Power BI performance

LEARNING PATH 6
Implement advanced data visualization techniques by using Power BI

Module 1: Understand advanced data visualization concepts
Module 2: Monitor data in real-time with Power BI
Module 3: Create paginated reports

LEARNING PATH 7
Implement and manage an analytics environment

Module 1: Provide governance in a Power BI environment
Module 2: Monitor and audit usage
Module 3: Broaden the reach of Power BI
Module 4: Build reports using Power BI within Azure Synapse Analytics

LEARNING PATH 8
Manage the analytics development lifecycle

Module 1: Design a Power BI application lifecycle management strategy
Module 2: Create and manage a Power BI deployment pipeline
Module 3: Create and manage Power BI assets

Intendent To

Candidates for this course should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions.

Certificates

Past experiences

What people say about us

- Marko Krstevski Microsoft .NET Academy

Seeking to expand my knowledge, I decided to enroll in Semos Education, where I am gaining the necessary knowledge and experience.
- Teodor Markovski Student

The desire to become a Cloud architect led me to Semos Education. I am thrilled by the positive experiences of former students and the way in which the instructors and Career Center take care of the students.
- Viktorija Georgieva Summer Mentorship Program for Python Develope

The reputation of Semos Education for quality training and the opportunity to learn from experienced instructors played an additional significant role in my decision.
- Borche Peltekovski Accredited Academy for Graphic Design

After completing my studies at Semos Education, I envision myself working in a technology company, such as Samsung, Apple, or a company of similar caliber.