You're reading from Cloud Scale Analytics with Azure Data Services Build modern data warehouses on Microsoft Azure

Product type Paperback

Published in Jul 2021

Publisher Packt

ISBN-13 9781800562936

Length 520 pages

Edition 1st Edition

Tools

Azure

Concepts

Data Streaming

Author (1):

Patrik Borosch

View More author details

Table of Contents (20) Chapters

Preface

1. Section 1: Data Warehousing and Considerations Regarding Cloud Computing

2. Chapter 1: Balancing the Benefits of Data Lakes Over Data Warehouses FREE CHAPTER

3. Chapter 2: Connecting Requirements and Technology

4. Section 2: The Storage Layer

5. Chapter 3: Understanding the Data Lake Storage Layer

6. Chapter 4: Understanding Synapse SQL Pools and SQL Options

7. Section 3: Cloud-Scale Data Integration and Data Transformation

8. Chapter 5: Integrating Data into Your Modern Data Warehouse

9. Chapter 6: Using Synapse Spark Pools

10. Chapter 7: Using Databricks Spark Clusters

11. Chapter 8: Streaming Data into Your MDWH

12. Chapter 9: Integrating Azure Cognitive Services and Machine Learning

13. Chapter 10: Loading the Presentation Layer

14. Section 4: Data Presentation, Dashboarding, and Distribution

15. Chapter 11: Developing and Maintaining the Presentation Layer

16. Chapter 12: Distributing Data

17. Chapter 13: Introducing Industry Data Models

18. Chapter 14: Establishing Data Governance

19. Other Books You May Enjoy

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...