Agent skill · data analytics · aradotso
microsoft-fabric-unified-analytics
End-to-end analytics platform using Microsoft Fabric with Lakehouse, Dataflow Gen2, PySpark notebooks, and Power BI following Medallion Architecture
Why this skill is useful
Provides specific commands and workflows for implementing the Medallion Architecture in Microsoft Fabric, which the AI wouldn't reliably generate on its own.
What it needs
Requires python installed locally. Requires microsoft-fabric, power-bi account access. About 8k tokens when loaded. Last updated 2026-08-05. 5 stars on the source repository.
What this skill does
Microsoft Fabric Unified Analytics Platform Skill by ara.so — Data Skills collection. This project demonstrates how to build a production-grade unified analytics platform using Microsoft Fabric, implementing the Medallion Architecture (Bronze → Silver → Gold) with OneLake, Dataflow Gen2, Fabric Notebooks (PySpark), Semantic Models, and Power BI. What This Project Does Microsoft Fabric Unified Analytics Platform showcases: Lakehouse Architecture: Organize data in Bronze (raw), Silver (cleansed), and Gold (business-ready) layers Unified SaaS Platform: Single environment for ingestion, processing, modeling, and visualization OneLake Storage: Centralized data lake foundation for all workloads Low-Code + Code: Combine Dataflow Gen2 (visual) with PySpark notebooks (code) Semantic Modeling: Create reusable business metrics and KPIs Native BI Integration: Power BI directly connected to the platform Architecture Overview Prerequisites Microsoft Fabric Workspace: With appropriate capacity (F64 or higher recommended) Microsoft Fabric License: Premium or trial capacity Power BI Pro/Premium: For report publishing Python 3.8+: For local notebook development (optional) Azure Storage Account: If ingesting from external sources Setting Up Microsoft Fabric Environment 1. Create Fabric Workspace 2. Create Lakehouse In your Fabric workspace: 1. Click New → Lakehouse 2. Name: retailanalyticslakehouse 3. This creates OneLake storage with Delta tables support 3. Organize Medallion Layers Create folder structure in your lakehouse: Data Ingestion to Bronze Layer Upload Raw Data via Lakehouse UI Using Fabric Notebook for Ingestion Dataflow Gen2: Bronze to Silver Transformation Creating a Dataflow Gen2 1. In Fabric workspace: New → Dataflow Gen2 2. Get data → Lakehouse → Select Bronze layer table 3. Apply transformations using Power Query M language Key Transformations (Power Query M) 4. Data destination: Lakehouse → silver/onlineretailcleaned 5. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aradotso/microsoft-fabric-unified-analytics