Tutorials¶
Hands-on, step-by-step guides covering every aspect of the Microsoft Fabric POC — from environment setup through advanced analytics and federal agency integrations.
Third-party references — publicly sourced, good-faith comparison
This page references non-Microsoft products and services. That information is drawn from each vendor's publicly available documentation and is offered for honest, good-faith comparison only. This is a personal project written from a Microsoft Fabric and Azure perspective; it does not claim expertise in, or authority over, any third-party product, and nothing here is an official statement by, or endorsed by, those vendors. Capabilities, pricing, and features change often — always verify against the vendor's current official documentation. Where a third-party offering is the stronger choice, we say so plainly.
Getting Started¶
-
00 — Environment Setup
Provision your Fabric workspace, configure capacity, and prepare the development environment.
Medallion Architecture¶
-
01 — Bronze Layer
Raw data ingestion with schema-on-read, append-only patterns, and source fidelity.
-
02 — Silver Layer
Data cleansing, validation, deduplication, and schema enforcement.
-
03 — Gold Layer
Business aggregations, KPIs, star schema, and consumption-ready datasets.
Analytics & BI¶
-
04 — Real-Time Analytics
Eventstreams, Eventhouse, KQL queries, and real-time dashboards.
-
05 — Direct Lake & Power BI
Direct Lake connectivity, semantic models, and Power BI report design.
-
06 — Data Pipelines
Orchestration with pipelines, scheduling, and data movement patterns.
-
07 — Governance & Purview
Microsoft Purview integration, lineage tracking, and data classification.
-
08 — Database Mirroring
Mirror external databases into Fabric OneLake for unified analytics.
-
09 — Advanced AI/ML
Machine learning workflows, model training, and MLOps in Fabric.
Migration & Connectivity¶
-
10 — Teradata Migration
Migrate from Teradata to Fabric with data validation and cutover planning.
-
11 — SAS Connectivity
Connect SAS datasets and integrate SAS workflows with Fabric.
-
24 — Snowflake to Fabric
Migrate workloads from Snowflake to Microsoft Fabric.
-
25 — IBM DB2 Source
Ingest data from IBM DB2 into Fabric Lakehouse.
DevOps & Operations¶
-
12 — CI/CD & DevOps
Git integration, deployment pipelines, and CI/CD automation.
-
13 — Migration Planning
Assessment, planning, and execution frameworks for platform migration.
-
14 — Security & Networking
Network isolation, private endpoints, and security configuration.
-
15 — Cost Optimization
Capacity management, auto-scale, and cost reduction strategies.
-
16 — Performance Tuning
Query optimization, caching, and compute tuning for Fabric workloads.
-
17 — Monitoring & Alerting
Workspace monitoring, alerting rules, and operational dashboards.
-
18 — Data Sharing
Cross-workspace sharing, external sharing, and data federation.
-
19 — Copilot & AI Features
AI Copilot configuration and AI-powered features in Fabric.
-
20 — Workspace Best Practices
Workspace organization, lifecycle management, and governance.
Networking & Gateways¶
-
21 — GeoAnalytics & ArcGIS
Geospatial analytics with ArcGIS integration and map visualizations.
-
22 — Networking & Connectivity
VNet gateways, private links, and hybrid connectivity patterns.
-
23 — SHIR & Data Gateways
Self-hosted integration runtime and on-premises data gateway setup.
Streaming & Analytics¶
-
26 — Multi-Source Streaming
Ingest and process streams from multiple sources with Eventstreams.
-
27 — Video Security Analytics
Video feed analytics for security monitoring and incident detection.
-
28 — People Movement Analytics
Foot traffic, occupancy tracking, and crowd flow analysis.
-
29 — Geolocation Analytics
Location-based analytics, heat maps, and spatial patterns.
-
37 — Graph Analytics
Network analysis, relationship mapping, and graph-based insights.
Federal Agency Deep Dives¶
-
30 — Tribal Healthcare
HIPAA-compliant healthcare analytics with tribal sovereignty considerations.
-
31 — Federal DOT/FAA
Transportation safety data, FAA analytics, and federal compliance.
-
32 — USDA Agriculture
Full medallion pipeline for USDA crop, livestock, and food safety data.
-
33 — SBA Small Business
SBA loan programs, disaster lending, and small business analytics.
-
34 — NOAA Weather & Climate
Weather observation, forecast analytics, and climate trend analysis.
-
35 — EPA Environment
Environmental monitoring, emissions data, and compliance reporting.
-
36 — DOI Interior
Natural resource management, land use, and conservation analytics.
-
38 — DOJ Justice
Justice system analytics, case management, and enforcement data.
Advanced AI/ML¶
-
39 — End-to-End MLOps
Train, register, deploy, monitor, and retrain ML models on Fabric — full MLOps lifecycle with MLflow tracking and AutoML endpoints.
-
40 — Production RAG
Retrieval-augmented generation in production with Eventhouse Vector, Data Agents, and an evaluation harness.
Cloud Migration¶
Step-by-step paths to migrate off another data platform onto Microsoft Fabric. Each tutorial covers assessment, schema/code translation, network egress costs, and validation.
-
41 — Azure Synapse → Fabric
Lift Dedicated SQL Pools, Spark notebooks, and pipelines from Synapse Analytics into Fabric without rewriting business logic.
-
42 — Databricks → Fabric
Migrate Databricks workspaces, Unity Catalog, Delta tables, and Jobs/Workflows to Fabric Data Engineering.
-
43 — Amazon Redshift → Fabric
Move Redshift schemas, queries, and data into Fabric Warehouse and OneLake. Includes AWS network egress mitigation.
-
44 — Google BigQuery → Fabric
Translate BigQuery Standard SQL → T-SQL, manage slot consumption, and handle GCP egress costs during migration.
-
45 — On-Prem SSAS / SSIS / SSRS → Fabric
Modernize on-prem Microsoft BI stack — SSAS cubes to Direct Lake, SSIS to Data Factory, SSRS to Paginated Reports.
-
55 — Palantir Foundry → Fabric
Rebuild Foundry ontology in Fabric IQ, port transforms to PySpark, replace Workshop/Forge apps with Power Apps + Translytical.
-
56 — Informatica → Fabric
Translate PowerCenter mappings + IDMC to Fabric Data Factory + Dataflows + notebooks; PowerExchange CDC → Mirroring.
-
10 — Teradata → Fabric
Replace Teradata enterprise data warehouse with Fabric Warehouse — schema translation, BTEQ to T-SQL, capacity planning.
-
24 — Snowflake → Fabric
Move Snowflake virtual warehouses, schemas, and Snowpipe ingestion to Fabric SQL Warehouse and OneLake.
-
25 — IBM DB2 → Fabric
Connect or migrate IBM DB2 (LUW / z/OS) sources into Fabric via Self-Hosted IR, Mirroring, or full bulk migration.
-
11 — SAS → Fabric
Connect SAS workloads to Fabric — ODBC/JDBC connectivity, dataset extraction patterns, and SAS procedure replacement.
-
13 — Migration Planning
Assessment-first methodology for any migration to Fabric. Inventory, sizing, dependency mapping, sequencing, and risk.
Industry Deep Dives¶
End-to-end industry implementations on Fabric — from sources to gold-layer dashboards.
-
46 — Commercial Healthcare
EHR (Epic FHIR), claims, lab results, and pharmacy data — clinical operations and population health on Fabric.
-
47 — Financial Services
Real-time fraud detection, AML, regulatory reporting, and customer 360 on Fabric Real-Time Intelligence + Direct Lake.
-
48 — Insurance Claims
Claims processing, fraud scoring, and actuarial analytics — insurance pipelines on Fabric.
-
49 — Retail & CPG
Demand forecasting, customer segmentation, store-ops dashboards, and real-time clickstream on Fabric.
-
50 — Manufacturing IoT
Factory IoT telemetry, predictive maintenance, OEE, and digital twin integration on Fabric.
-
51 — Energy & Utilities
Smart-grid analytics, load forecasting, outage prediction, and renewable generation on Fabric.
-
52 — Telecom
Churn prediction, network-quality analytics, and customer-experience dashboards on Fabric.
-
53 — Pharma Clinical Trials
Clinical-trial data ingestion, regulatory submission pipelines, and patient-cohort analytics on Fabric.
-
54 — Media & Entertainment
Audience analytics, content performance, and ad-revenue dashboards on Fabric.
Quick Reference¶
-
Cheat Sheet
Quick-reference commands, patterns, and tips for all tutorials.