You're reading from Learn Microsoft Fabric A practical guide to performing data analytics in the era of artificial intelligence

Product type Paperback

Published in Feb 2024

Publisher Packt

ISBN-13 9781835082287

Length 338 pages

Edition 1st Edition

Tools

Azure Data Factory

Concepts

Artificial Intelligence

Authors (2):

Bradley Schacht

Arshad Ali

View More author details

Table of Contents (19) Chapters

Preface

1. Part 1: An Introduction to Microsoft Fabric FREE CHAPTER

2. Chapter 1: Overview of Microsoft Fabric and Understanding Its Different Concepts

3. Chapter 2: Understanding Different Workloads and Getting Started with Microsoft Fabric

4. Part 2: Building End-to-End Analytics Systems

5. Chapter 3: Building an End-to-End Analytics System – Lakehouse

6. Chapter 4: Building an End-to-End Analytics System – Data Warehouse

7. Chapter 5: Building an End-to-End Analytics System – Real-Time Analytics

8. Chapter 6: Building an End-to-End Analytics System – Data Science

9. Part 3: Administration and Monitoring

10. Chapter 7: Monitoring Overview and Monitoring Different Workloads

11. Chapter 8: Administering Fabric

12. Part 4: Security and Developer Experience

13. Chapter 9: Security and Governance Overview

14. Chapter 10: Continuous Integration and Continuous Deployment (CI/CD)

15. Part 5: AI Assistance with Copilot Integration

16. Chapter 11: Overview of AI Assistance and Copilot Integration

17. Index

Why subscribe?

18. Other Books You May Enjoy

Analyze

Now that we have data integrated into the lakehouse and have prepared them for reporting, we’ll analyze these data to get insights. We will look at two methods: first, we will use Power BI to create visualizations (reports and dashboards), and then we will use SQL endpoint to connect the lakehouse for running analytical queries.

Power BI

Power BI is natively integrated within the whole Fabric experience; this native integration brings a unique mode of accessing the data (called Direct Lake, which we discussed in earlier chapters) from the lakehouse to provide the most performant query and reporting experience. Let’s create a report based on the data from the Gold zone:

Open the wwi_gold lakehouse and click on SQL endpoint under mode selection on the top right of the screen to switch to SQL endpoint mode for the selected lakehouse.