Mastering Microsoft Fabric: SAASification of Analytics

Learn and explore the capabilities of Microsoft Fabric, the latest evolution in cloud analytics suites. This book will help you understand how users can leverage Microsoft Office equivalent experience for performing data management and advanced analytics activity. The book starts with an overview of the analytics evolution from on premises to cloud infrastructure as a service (IaaS), platform as a service (PaaS), and now software as a service (SaaS version) and provides an introduction to Microsoft Fabric. You will learn how to provision Microsoft Fabric in your tenant along with the key capabilities of SaaS analytics products and the advantage of using Fabric in the enterprise analytics platform. OneLake and Lakehouse for data engineering is discussed as well as OneLake for data science. Author Ghosh teaches you about data warehouse offerings inside Microsoft Fabric and the new data integration experience which brings Azure Data Factory and Power Query Editor of Power BI together in a single platform. Also demonstrated is Real-Time Analytics in Fabric, including capabilities such as Kusto query and database. You will understand how the new event stream feature integrates with OneLake and other computations. You also will know how to configure the real-time alert capability in a zero code manner and go through the Power BI experience in the Fabric workspace. Fabric pricing and its licensing is also covered. After reading this book, you will understand the capabilities of Microsoft Fabric and its Integration with current and upcoming Azure OpenAI capabilities. What You Will Learn Build OneLake for all data like OneDrive for Microsoft Office Leverage shortcuts for cross-cloud data virtualization in Azure and AWS Understand upcoming OpenAI integration Discover new event streaming and Kusto query inside Fabric real-time analytics Utilize seamless tooling for machine learning and data science Who This Book Is For Citizen users and experts in the data engineering and data science fields, along with chief AI officers Table of Contents About the Author About the Technical Reviewers Chapter 1: The Evolution of Analytics Cloud Analytics Evolution Introduction to Microsoft Fabric Analytics SaaSification Anatomy of Microsoft Fabric Synapse Data Engineering Synapse Data Science Synapse Data Warehouse Data Factory Synapse Real-Time Analytics Data Activator Power BI Summary Further Reading Chapter 2: Microsoft Fabric: The SaaSification of Analytics Microsoft Fabric Tenants, Capacities, and Workspace Microsoft Fabric Trial Power BI Premium per Capacity License (P SKU) Microsoft Fabric Capacity: Azure Portal (F SKU) How to Provision Microsoft Fabric Provision Fabric Using Power BI Premium per Capacity Enabling Power BI Premium Capacity via the Admin Portal Enabling Power BI Premium Capacity via the Workspace Provisioning Fabric Using the Azure Platform Differentiators of SaaS Analytics OneLake: OneDrive for the Organization Multicloud Virtualization (AWS S3 Support) Built-in Data Mesh Summary Further Reading Chapter 3: OneLake and Lakehouses for Data Engineers The Lakehouse Concept Fabric Lakehouse: An Optimized Delta Lake Creating a Fabric Lakehouse Lakehouse Data Engineering Data Ingestion and Pipeline Lakehouse Explorer Data Preparation and Transformation Using a Notebook Defining a Spark Job Monitoring a Spark Job SQL Endpoint of a Lakehouse Data Visualization Summary Further Reading Chapter 4: Microsoft Fabric for Data Scientists Fabric Data Science Overview Exploring, Ingesting, and Preparing Data Ingesting Data Exploring the Data Preparing the Data Using a Data Wrangling Tool Exploratory Data Analysis (EDA) and Data Visualization Preparing the Data with Notebook Code Data Science with VS Code Developing the Model Setting Up Experiment Tracking and Registering the Model Large Language Modeling and Azure OpenAI Integration Summary Further Reading Chapter 5: Data Warehousing in Microsoft Fabric Fabric Data Warehouse Introduction Provisioning a Data Warehouse Ingesting Data into a Data Warehouse Data Warehouse Development Visual Interface Transformation Cross-Database and Virtual Datawarehouse Queries SQL Query SQL Server Management Studio Connectivity Advanced DW Capabilities Workload Management Automated Multitiered Coaching and Query Optimization Fabric DW Transaction Support Data Models with Fabric DWs Integration with Power BI and Microsoft Office Tools Monitoring a Fabric DW Pipeline Summary Further Reading Chapter 6: Data Integration for Office Users Data Flow Gen2 Fabric Copilot Experience Data Pipeline Data Factory Mount Summary Further Reading Chapter 7: Real-Time Analytics with Microsoft Fabric Fabric Real-Time Analytics Create a Kusto Database Ingesting Data into the Kusto Database KQL Database Query Kusto Query Development Python Plugin Kusto API and SDK Data Retention, Caching, and OneLake Integration Using an Event Stream Summary Further Reading Chapter 8: Microsoft Fabric Activator Real-Time Monitoring and Alerts Data Activator Anatomy Connect with Data Sources Power BI as the Data Source Event Stream as a Source Define and Detect Actionable Patterns Trigger an Automated Workflow: Custom Action Summary Further Reading Chapter 9: Power BI in the Microsoft Fabric Workspace Power BI Fundamentals Power BI Desktop and Power BI Report Builder Power BI Service Power BI Mobile Apps Power BI Key New Features (Fabric) Report Auto-Create Quick Insights Lineage Paginated Report Getting Insights Power BI Direct Lake Mode Report Sharing Datamarts Fabric Power BI Copilot Summary Further Reading Chapter 10: Microsoft Fabric: Inside and Out Fabric Security and Governance Fabric Tenant Security Fabric Workspace Security Fabric Item Security Fabric Computation Security Storage Encryption Fabric Conditional Access Fabric and Purview: Data Governance Fabric Pricing and Licensing Summary Further Reading Index