Reader small image

You're reading from  Cloud Scale Analytics with Azure Data Services

Product typeBook
Published inJul 2021
PublisherPackt
ISBN-139781800562936
Edition1st Edition
Right arrow
Author (1)
Patrik Borosch
Patrik Borosch
author image
Patrik Borosch

Patrik Borosch is a cloud solution architect for data and AI at Microsoft Switzerland GmbH. He has more than 25 years of BI and analytics development, engineering, and architecture experience and is a Microsoft Certified Data Engineer and a Microsoft Certified AI Engineer. Patrik has worked on numerous significant international data warehouse, data integration, and big data projects. Through this, he has built and extended his experience in all facets, from requirements engineering to data modeling and ETL, all the way to reporting and dashboarding. At Microsoft Switzerland, he supports customers in their journey into the analytical world of the Azure Cloud.
Read more about Patrik Borosch

Right arrow

Understanding Industry Data Models

Industry data models have been developed by different companies for a long time. Microsoft started to offer this approach with the Common Data Model (CDM), which spans all three cloud pillars of Microsoft (Azure, Office 365, and Dynamics 365). The goal is to easily interconnect data services with each other and follow a predefined structure that is known by all the components involved. If, for example, sales data is read from Dynamics 365, its structure is defined and already available for Data Factory. It can be written to Azure Data Lake Storage or Synapse SQL pools, and from there Power BI already knows the structure and can offer reports and dashboards.

The CDM can be adjusted to your needs. This means you, as the developer, can add attributes to existing entities, create additional entities, or skip the ones you don't need.

To learn more about industry data models, check out Chapter 13, Introducing Industry Data Models.

Note

...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Cloud Scale Analytics with Azure Data Services
Published in: Jul 2021Publisher: PacktISBN-13: 9781800562936

Author (1)

author image
Patrik Borosch

Patrik Borosch is a cloud solution architect for data and AI at Microsoft Switzerland GmbH. He has more than 25 years of BI and analytics development, engineering, and architecture experience and is a Microsoft Certified Data Engineer and a Microsoft Certified AI Engineer. Patrik has worked on numerous significant international data warehouse, data integration, and big data projects. Through this, he has built and extended his experience in all facets, from requirements engineering to data modeling and ETL, all the way to reporting and dashboarding. At Microsoft Switzerland, he supports customers in their journey into the analytical world of the Azure Cloud.
Read more about Patrik Borosch