Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

Harness the power of Microsoft Fabric to develop data analytics solutions for various use cases guided by step-by-step instructions

Key Features

• Explore Microsoft Fabric and its features through real-world examples
• Build data analytics solutions for lakehouses, data warehouses, real-time analytics, and data science
• Monitor, manage, and administer your Fabric platform and analytics system to ensure flexibility, performance, security, and control
• Purchase of the print or Kindle book includes a free PDF eBook

Book Description

Discover the capabilities of Microsoft Fabric, the premier unified solution designed for the AI era, seamlessly combining data integration, OneLake, transformation, visualization, universal security, and a unified business model. This book provides an overview of Microsoft Fabric, its components, and the wider analytics landscape.

In this book, you'll explore workloads such as Data Factory, Synapse Data Engineering, data science, data warehouse, real-time analytics, and Power BI. You’ll learn how to build end-to-end lakehouse and data warehouse solutions using the medallion architecture, unlock the real-time analytics, and implement machine learning and AI models. As you progress, you’ll build expertise in monitoring workloads and administering Fabric across tenants, capacities, and workspaces. The book also guides you step by step through enhancing security and governance practices in Microsoft Fabric and implementing CI/CD workflows with Azure DevOps or GitHub. Finally, you’ll discover the power of Copilot, an AI-driven assistant that accelerates your analytics journey.

By the end of this book, you’ll have unlocked the full potential of AI-driven data analytics, gaining a comprehensive understanding of the analytics landscape and mastery over the essential concepts and principles of Microsoft Fabric.

What you will learn

• Get acquainted with the different services available in Microsoft Fabric
• Build end-to-end data analytics solution to scale and manage high performance
• Integrate data from different types of data sources
• Apply transformation with Spark, Notebook, and T-SQL
• Understand and implement real-time stream processing and data science capabilities
• Perform end-to-end processes for building data analytics solutions in the AI era
• Drive insights by leveraging Power BI for reporting and visualization
• Improve productivity with AI assistance and Copilot integration

Who this book is for

This book is for data professionals, including data analysts, data engineers, data scientists, data warehouse developers, ETL developers, business analysts, AI/ML professionals, software developers, and Chief Data Officers who want to build a future-ready data analytics solution for long-term success in the AI era.

For PySpark and SQL students entering the data analytics field, this book offers a broad foundation for developing the skills to build end-to-end analytics systems for various use cases. Basic knowledge of SQL and Spark is assumed.

Table of Contents

1. Overview of Microsoft Fabric and Understanding Its Different Concepts
2. Understanding Different Workloads and Getting Started with Microsoft Fabric
3. Building an End-to-End Analytics System – Lakehouse
4. Building an End-to-End Analytics System – Data Warehouse
5. Building an End-to-End Analytics System – Real-Time Analytics
6. Building an End-to-End Analytics System – Data Science
7. Monitoring Overview and Monitoring Different Workloads
8. Administering Fabric
9. Security and Governance Overview

(N.B. Please use the Look Inside option to see further chapters)

Arshad Ali is a principal product manager at Microsoft, working on the Microsoft Fabric product team in Redmond, WA. He focuses on Spark Runtime, which empowers both data engineering and data science experiences. In his previous role, he helped strategic customers and partners adopt Azure Synapse and Microsoft Fabric. Arshad has more than 20 years of industry experience and has been with Microsoft for over 16 years. He is the co-author of the book Big Data Analytics with Azure HDInsight and the author of over 200 technical articles and blogs on data and analytics. Arshad holds an MBA from the Foster School of Business at the University of Washington and an MCA from India.

Bradley Schacht is a principal program manager on the Microsoft Fabric product team based in Saint Augustine, Florida. Bradley is a former consultant and trainer and has co-authored five books on SQL Server and Power BI. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. Bradley gives back to the community by speaking at events, such as the PASS Summit, SQL Saturday, Code Camp, and user groups across the country, including locally at the Jacksonville SQL Server User Group (JSSUG). He is a contributor on SQLServerCentral and blogs on his personal site, BradleySchacht.