Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Azure Data and AI Architect Handbook

You're reading from   Azure Data and AI Architect Handbook Adopt a structured approach to designing data and AI solutions at scale on Microsoft Azure

Arrow left icon
Product type Paperback
Published in Jul 2023
Publisher Packt
ISBN-13 9781803234861
Length 284 pages
Edition 1st Edition
Tools
Arrow right icon
Authors (2):
Arrow left icon
Olivier Mertens Olivier Mertens
Author Profile Icon Olivier Mertens
Olivier Mertens
Breght Van Baelen Breght Van Baelen
Author Profile Icon Breght Van Baelen
Breght Van Baelen
Arrow right icon
View More author details
Toc

Table of Contents (18) Chapters Close

Preface 1. Part 1: Introduction to Azure Data Architect
2. Chapter 1: Introduction to Data Architectures FREE CHAPTER 3. Chapter 2: Preparing for Cloud Adoption 4. Part 2: Data Engineering on Azure
5. Chapter 3: Ingesting Data into the Cloud 6. Chapter 4: Transforming Data on Azure 7. Chapter 5: Storing Data for Consumption 8. Part 3: Data Warehousing and Analytics
9. Chapter 6: Data Warehousing 10. Chapter 7: The Semantic Layer 11. Chapter 8: Visualizing Data Using Power BI 12. Chapter 9: Advanced Analytics Using AI 13. Part 4: Data Security, Governance, and Compliance
14. Chapter 10: Enterprise-Level Data Governance and Compliance 15. Chapter 11: Introduction to Data Security 16. Index 17. Other Books You May Enjoy

The Semantic Layer

Positioned after the data has been modeled in a data warehouse or lakehouse, the semantic layer acts as a performance-enhancing data querying layer for reporting, offering a more efficient and business-friendly view of the data. By employing aggregations, calculations, and business-oriented terms and concepts, the semantic layer simplifies the complexity of technical data structures and caters to the needs of business users. The end result is a well-defined data model that effectively translates the underlying data structures of the warehouse or lakehouse into business-oriented terms. The value of this is to allow reports to more quickly query and visualize data, as well as allow business people to understand the data structures and extract insights from them.

In this chapter, we’re going to cover the following main topics:

  • Multidimensional versus tabular models
  • The VertiPaq engine for tabular models
  • Modes in tabular models
  • Tools for...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime