Microsoft Fabric Assets

Comprehensive implementation guides, best practices, and reusable templates for Microsoft Fabric platform deployments and legacy migrations.

85+
Total Assets
30
PySpark Guides
11
LLM Guides
8
Migration Phases

Quick Access - Popular Assets

Medallion Architecture Blueprint

Comprehensive medallion architecture design with Bronze, Silver, and Gold layers for Microsoft Fabric.

📥 Download

OneLake Architecture Patterns

Step-by-step guide for implementing OneLake data organization patterns.

📥 Download

PySpark Coding Standards

Enterprise coding standards and best practices for PySpark development.

📥 Download

LLM SAS to PySpark Prompts

AI-assisted code conversion methodology for SAS to PySpark migration.

📥 Download

Foundation & Architecture

Core architectural patterns and foundational guides for Microsoft Fabric implementation

Medallion Architecture Blueprint

Comprehensive medallion architecture design with Bronze, Silver, and Gold layers.

📥 Download

Well-Architected Framework

Best practices across reliability, security, cost optimization, and performance.

📥 Download

OneLake Architecture Patterns

Data lake organization patterns and OneLake implementation strategies.

📥 Download

Governance Framework

Data governance policies, standards, and implementation guidelines.

📥 Download

Warehouse vs Lakehouse Decision

Decision framework for choosing between Warehouse and Lakehouse.

📥 Download

Data Engineering

Data engineering patterns and best practices for Microsoft Fabric

PySpark Best Practices

Production-grade PySpark coding patterns and optimization techniques.

📥 Download

Lakehouse Design Guide

End-to-end lakehouse design patterns and implementation strategies.

📥 Download

Delta Lake Operations

ACID transactions, time travel, and Delta Lake optimization techniques.

📥 Download

Notebook Development Standards

Standards and best practices for Fabric notebook development.

📥 Download

Spark Pool Configuration

Spark pool sizing and configuration guidelines.

📥 Download

Data Factory

Pipeline design patterns and orchestration for Data Factory

Pipeline Design Patterns

Common pipeline patterns for data ingestion and transformation.

📥 Download

Dataflow Gen2 Best Practices

Best practices for building efficient Dataflow Gen2 transformations.

📥 Download

Copy Activity Optimization

Optimizing copy activities for high-performance data movement.

📥 Download

Orchestration Patterns

Pipeline orchestration and scheduling patterns.

📥 Download

Pipeline Monitoring & Alerting

Setting up monitoring and alerts for pipeline operations.

📥 Download

Data Warehouse

SQL analytics and data warehousing on Microsoft Fabric

Warehouse Design Patterns

Data warehouse design patterns for Fabric Warehouse.

📥 Download

T-SQL Performance Optimization

Query optimization techniques for T-SQL in Fabric.

📥 Download

Warehouse Security & RLS

Row-level security implementation for Fabric Warehouse.

📥 Download

Data Lineage & Cataloging

Data lineage tracking and catalog management.

📥 Download

Real-Time Intelligence

Stream processing and real-time analytics

Eventstream Design Patterns

Event-driven architecture patterns with Eventstream.

📥 Download

KQL Query Optimization

Kusto Query Language optimization techniques.

📥 Download

Streaming Data Patterns

Patterns for processing streaming data in real-time.

📥 Download

Real-Time Dashboard Design

Building real-time dashboards with live data.

📥 Download

Streaming vs Batch Architecture

Decision framework for streaming vs batch processing.

📥 Download

Power BI Integration

Business intelligence and reporting solutions

Direct Lake Implementation

Implementing Direct Lake mode for optimal performance.

📥 Download

Semantic Model Design

Best practices for semantic model design.

📥 Download

DAX Best Practices

DAX optimization and best practices guide.

📥 Download

Report Design Standards

Standards for consistent report design.

📥 Download

Direct Lake Configuration

Configuration guide for Direct Lake connections.

📥 Download

Security & Governance

Security best practices and governance controls

Workspace Security Model

Workspace security patterns and access control.

📥 Download

Purview Integration Guide

Integrating Microsoft Purview for governance.

📥 Download

Data Classification Guidelines

Data classification and sensitivity labeling.

📥 Download

Audit & Compliance Framework

Audit logging and compliance controls.

📥 Download

Audit Logging & Monitoring

Setting up audit logs and monitoring.

📥 Download

DevOps & Deployment

CI/CD pipelines and deployment automation

Git Integration Guide

Setting up Git integration for Fabric workspaces.

📥 Download

CI/CD Pipeline Templates

Automated deployment pipeline templates.

📥 Download

Deployment Pipeline Patterns

Patterns for deployment pipelines in Fabric.

📥 Download

Environment Promotion Strategy

Strategy for promoting across environments.

📥 Download

Deployment Best Practices

Best practices for Fabric deployments.

📥 Download

Git Integration Setup

Step-by-step Git integration setup guide.

📥 Download

Migration & Modernization

Legacy system migration guides and conversion patterns

SAS to PySpark Migration

Comprehensive guide for migrating SAS workloads to PySpark.

📥 Download

SSIS to Data Factory Migration

Converting SSIS packages to Data Factory pipelines.

📥 Download

Informatica to Fabric Migration

Migration patterns from Informatica to Fabric.

📥 Download

Informatica Migration Guide

Detailed Informatica migration methodology.

📥 Download

Legacy Database Migration

Migrating legacy databases to Fabric.

📥 Download

Data Quality

Data quality frameworks and validation patterns

Data Quality Framework

Enterprise data quality rules and monitoring.

📥 Download

Data Profiling Guide

Data profiling techniques and tools.

📥 Download

Great Expectations Integration

Integrating Great Expectations for data validation.

📥 Download

Quality Monitoring Dashboards

Building data quality monitoring dashboards.

📥 Download

Performance & Cost

Performance optimization and cost management

Query Performance Tuning

Query optimization techniques for Fabric.

📥 Download

Cost Management Guide

Cost optimization and capacity management.

📥 Download

Capacity Planning Guide

Planning and sizing Fabric capacity.

📥 Download

Monitoring & Alerting Setup

Setting up performance monitoring and alerts.

📥 Download

Operations

Operational runbooks and monitoring guides

Operational Runbook

Day-to-day operations, monitoring, and incident response.

📥 Download

PySpark - Architecture Fundamentals

Core Spark architecture and cluster configuration

PySpark Architecture Deep Dive

Understanding Spark's distributed architecture and execution model.

📥 Download

Cluster Sizing Guide

Right-sizing clusters for different workload types.

📥 Download

Execution Model & DAG Optimization

Understanding DAGs, stages, and optimizing execution plans.

📥 Download

Memory Model & Tuning

Spark memory management and configuration optimization.

📥 Download

PySpark - Development Standards

Coding standards and development best practices

PySpark Coding Standards

Enterprise coding standards, naming conventions, and code organization.

📥 Download

DataFrame API Patterns

Common DataFrame operations and transformation patterns.

📥 Download

Schema Design & Evolution

Schema management and evolution strategies.

📥 Download

Spark SQL Best Practices

Writing efficient Spark SQL queries.

📥 Download

UDF Development Guide

User-defined functions: when to use and how to optimize.

📥 Download

PySpark - Performance Engineering

Performance optimization and tuning techniques

Join Optimization Techniques

Broadcast joins, sort-merge joins, and optimization strategies.

📥 Download

Partitioning Strategy Guide

Data partitioning patterns for optimal parallel processing.

📥 Download

Shuffle Optimization

Minimizing shuffle operations and optimizing data movement.

📥 Download

Data Skew Handling

Identifying and resolving data skew problems.

📥 Download

Caching & Persistence

Strategic caching patterns and persistence level selection.

📥 Download

Query Plan Analysis

Reading and optimizing Spark query execution plans.

📥 Download

PySpark - Data Engineering Patterns

Common data engineering patterns and implementations

SCD Implementation Guide

Slowly Changing Dimensions (Type 1, 2, 3) implementations.

📥 Download

Incremental Load Patterns

CDC, watermarks, and incremental data loading strategies.

📥 Download

Data Validation Framework

Building robust data validation and quality checks.

📥 Download

Error Handling & Recovery

Exception handling patterns and failure recovery strategies.

📥 Download

Idempotent Processing

Building idempotent data pipelines for reliable reprocessing.

📥 Download

PySpark - Testing & Quality

Testing strategies and quality assurance

Unit Testing Guide

Unit testing PySpark transformations with pytest.

📥 Download

Integration Testing Patterns

End-to-end testing patterns for data pipelines.

📥 Download

Test Data Generation

Generating realistic test data for PySpark testing.

📥 Download

PySpark - Operations & Debugging

Operational monitoring and troubleshooting

Troubleshooting Playbook

Common PySpark errors and their solutions.

📥 Download

Spark UI Analysis Guide

Using Spark UI to diagnose performance issues.

📥 Download

Logging & Observability

Implementing logging and observability in PySpark.

📥 Download

PySpark - Advanced Topics

Advanced PySpark capabilities and techniques

Window Functions Mastery

Advanced window functions for analytics and ranking.

📥 Download

Complex Data Types

Working with arrays, maps, structs, and nested data.

📥 Download

Pandas API on Spark

Using pandas API for distributed data processing.

📥 Download

Structured Streaming Guide

Real-time stream processing with PySpark.

📥 Download

LLM Methodology

AI-assisted code conversion methodologies and prompt engineering

SAS to PySpark Prompt Engineering

Prompt engineering guide for SAS to PySpark conversion.

📥 Download

SSIS to Fabric Prompt Engineering

Prompt engineering guide for SSIS to Fabric conversion.

📥 Download

Informatica to Fabric Prompt Engineering

Prompt engineering guide for Informatica to Fabric conversion.

📥 Download

Code Conversion Architecture

Architecture for LLM-based code conversion systems.

📥 Download

Confidence Scoring Framework

Scoring and validating LLM conversion outputs.

📥 Download

Human-in-the-Loop Review Process

Review process for LLM-generated code.

📥 Download

Output Validation Patterns

Patterns for validating LLM outputs.

📥 Download

Edge Case Handling Playbook

Handling edge cases in code conversion.

📥 Download

Fine-Tuning Strategy for Domain Terms

Fine-tuning LLMs for domain-specific terminology.

📥 Download

Conversion Metrics Dashboard

Metrics and KPIs for conversion tracking.

📥 Download

Methodology Asset Roadmap

Roadmap for LLM methodology development.

📥 Download

Migration Governance

Governance frameworks and program management for migration initiatives

Migration Governance Framework

Overall governance structure for migration programs.

📥 Download

Quality Gates & Checkpoints

Phase gates and quality checkpoints for milestones.

📥 Download

Risk Management Playbook

Risk identification, assessment, and mitigation.

📥 Download

Stakeholder Communication Plan

Communication strategies for stakeholder groups.

📥 Download

Program Metrics & KPIs

Key performance indicators and success metrics.

📥 Download

Status Reporting Templates

Weekly, monthly, and executive status templates.

📥 Download

Issue Escalation Procedures

Escalation paths and issue resolution processes.

📥 Download

Milestone Signoff Procedures

Formal signoff processes for milestones.

📥 Download

Scope Change Control Process

Change request management and approval workflows.

📥 Download

Dependency Management Guide

Managing dependencies across workstreams.

📥 Download

Governance Roadmap

Roadmap for governance development.

📥 Download

Phase 0: Discovery & Planning

Initial discovery and assessment templates for migration planning

Current State Assessment

Template for documenting current state systems and processes.

📥 Download

Stakeholder Mapping Matrix

Identifying and mapping key stakeholders.

📥 Download

Legacy Asset Inventory

Cataloging existing legacy assets.

📥 Download

Data Domain Prioritization Matrix

Prioritizing data domains for migration.

📥 Download

System Dependency Map

Mapping system dependencies and integrations.

📥 Download

Discovery Risk Assessment

Initial risk assessment during discovery.

📥 Download

Phase 1: Foundation & Governance

Establishing governance foundation for migration

Governance Operating Model

Defining governance structure and responsibilities.

📥 Download

Stewardship Assignment Matrix

Assigning data stewardship responsibilities.

📥 Download

Business Glossary

Standardized business terminology and definitions.

📥 Download

Data Product Contract

Defining data product specifications and SLAs.

📥 Download

Phase 2: Migration Execution

Templates for migration execution and conversion

Source to Target Mapping

Mapping source to target data structures.

📥 Download

SAS Conversion Specification

Specifications for SAS code conversion.

📥 Download

Informatica Conversion Specification

Specifications for Informatica conversion.

📥 Download

SSIS Conversion Specification

Specifications for SSIS package conversion.

📥 Download

Transformation Logic Documentation

Documenting transformation logic and rules.

📥 Download

SCD Type 2 Implementation Guide

Guide for implementing SCD Type 2.

📥 Download

Reconciliation Test Cases

Test cases for data reconciliation.

📥 Download

Parallel Run Plan

Planning parallel run validation.

📥 Download

Cutover Checklist

Checklist for migration cutover.

📥 Download

Rollback Plan

Rollback procedures and contingency planning.

📥 Download

Phase 3: Data Quality & Testing

Data quality and testing templates

Data Quality Framework

Enterprise data quality framework.

📥 Download

DQ Rule Catalog

Catalog of data quality rules.

📥 Download

DQ Scorecard Template

Data quality scorecard template.

📥 Download

Test Strategy Document

Overall testing strategy document.

📥 Download

Unit Test Specification

Unit test specifications and templates.

📥 Download

Integration Test Cases

Integration test case templates.

📥 Download

UAT Test Plan

User acceptance testing plan.

📥 Download

UAT Signoff Form

UAT signoff documentation.

📥 Download

Performance Test Plan

Performance testing plan.

📥 Download

Defect Tracking Log

Defect tracking and management log.

📥 Download

Test Summary Report

Test execution summary report.

📥 Download

Regression Test Suite

Regression testing suite template.

📥 Download

Phase 4: Program Management

Program and project management templates

Project Charter

Project charter template.

📥 Download

RAID Log

Risks, Assumptions, Issues, Dependencies log.

📥 Download

Status Report

Weekly/monthly status report template.

📥 Download

Steering Committee Deck

Executive steering committee presentation.

📥 Download

Change Request Form

Change request submission form.

📥 Download

Resource Plan

Resource planning and allocation.

📥 Download

Communication Plan

Project communication plan.

📥 Download

Meeting Minutes Template

Meeting minutes documentation.

📥 Download

Sprint Planning Template

Agile sprint planning template.

📥 Download

Lessons Learned

Lessons learned documentation.

📥 Download

Decision Log

Project decision tracking log.

📥 Download

Project Closure Report

Project closure documentation.

📥 Download

Phase 5: Operations & Support

Operations and support documentation

Operations Runbook

Day-to-day operations runbook.

📥 Download

SLA Definition Document

Service level agreement definitions.

📥 Download

Incident Report Template

Incident reporting template.

📥 Download

Support Handover Document

Support transition documentation.

📥 Download

Monitoring & Alerting Config

Monitoring and alerting configuration.

📥 Download

Capacity Planning Guide

Capacity planning documentation.

📥 Download

Data Retention Policy

Data retention and archival policy.

📥 Download

Disaster Recovery Plan

DR planning and procedures.

📥 Download

Security Access Control Matrix

Access control documentation.

📥 Download

Release Management Checklist

Release management procedures.

📥 Download

Environment Configuration

Environment configuration documentation.

📥 Download

Operational Metrics Dashboard

Operational metrics and KPIs.

📥 Download

Phase 6: Change Management & Training

Change management and training materials

Change Management Plan

Organizational change management plan.

📥 Download

Training Needs Assessment

Assessing training requirements.

📥 Download

Training Curriculum

Training curriculum and materials.

📥 Download

Training Feedback Survey

Training feedback collection.

📥 Download

User Adoption Tracker

Tracking user adoption metrics.

📥 Download

Job Aids & Quick Reference

Quick reference guides for users.

📥 Download

Readiness Assessment Checklist

Go-live readiness assessment.

📥 Download

Hypercare Plan

Post go-live hypercare planning.

📥 Download

Phase 7: Post Go-Live Optimization

Post-implementation optimization templates

Benefits Realization Report

Tracking realized benefits.

📥 Download

Optimization Opportunities Log

Identifying optimization opportunities.

📥 Download

Technical Debt Register

Tracking technical debt.

📥 Download

Continuous Improvement Plan

Ongoing improvement planning.

📥 Download

Phase 8: Canonical Model Workshop

Canonical data model design materials

Canonical Data Model Methodology

Workshop materials for canonical data model design.

📥 Download

Testing & Validation

Testing strategies and validation frameworks

Migration Testing Strategy

Comprehensive migration testing strategy.

📥 Download

Data Reconciliation Framework

Framework for data reconciliation testing.

📥 Download

Performance Benchmarking Guide

Performance benchmarking methodology.

📥 Download

Regression Test Suite Design

Designing regression test suites.

📥 Download

Unit Test Templates

Templates for unit testing.

📥 Download

UAT Playbook

User acceptance testing playbook.

📥 Download

Test Data Management Strategy

Managing test data across environments.

📥 Download

Defect Triage Procedures

Defect triage and prioritization.

📥 Download

Validation Asset Roadmap

Roadmap for validation assets.

📥 Download

Organizational Readiness

Organizational change and readiness materials

Center of Excellence Blueprint

Building a data CoE.

📥 Download

Change Management Playbook

Organizational change playbook.

📥 Download

Training Curriculum Framework

Framework for training curriculum.

📥 Download

Skills Transition Roadmap

Skills development roadmap.

📥 Download

RACI Matrix Templates

RACI responsibility matrices.

📥 Download

Hypercare & Stabilization Plan

Post go-live hypercare planning.

📥 Download

Readiness Asset Roadmap

Roadmap for readiness assets.

📥 Download