Mastering Microsoft Fabric: SAASification of Analytics

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