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

Creating data models with Azure Analysis Services

AAS is a sibling of Power BI that can be provisioned from your Azure portal. Compared to Power BI, AAS doesn't offer the same visualization functionality, however. You would use Power BI or Excel or another tool that can talk DAX or Multidimensional Expressions (MDX) to consume the data model that you can build with AAS.

That is exactly the purpose of AAS: to act as a columnstore database and host a DAX data model just like you would create it with Power BI. AAS will give you a similar set of features and DAX functions when creating a data model that you have seen in this chapter already.

Up to now, the advantage of AAS over Power BI has been the higher amount of data that you could host with AAS. But with the current and further releases of Power BI and the Premium offering, these limits will vanish.

Microsoft has announced that Power BI Premium will be the superset of all the functions of both Power BI and AAS in the...

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