Learn Microsoft Fabric

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)