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