Skip to main content
skill CX Codex

microsoft-fabric-unified-analytics — Claude Code skill for Fabric

microsoft-fabric-unified-analytics walks you through a Fabric analytics stack: OneLake layers, a Dataflow Gen2 cleaning step, PySpark gold tables and Power BI on top.

no license 282 installs ★ 5 updated 2026-10-09

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add reason-machines/data-skills --skill microsoft-fabric-unified-analytics -a claude-code
Open on GitHub

What microsoft-fabric-unified-analytics does

The skill lays out one analytics pipeline on Microsoft Fabric. Raw files land in OneLake as bronze, a Dataflow Gen2 query in Power Query M cleans them into silver, PySpark notebooks in Fabric turn silver into gold KPI tables, and a semantic model feeds Power BI reports above that.

Concrete pieces come with it: the Lakehouse folder layout, an M query that drops duplicate InvoiceNo/StockCode rows, skips records with no CustomerID, adds line_total, splits the date into year and month, and flags returns by the “C” prefix on an invoice number. Another snippet refreshes the dataflow through the Fabric REST API using a bearer token from environment variables.

Capacity is the gate. A workspace sits on Fabric capacity, so a Premium or trial licence comes first, and the skill suggests F64 as a starting size. Publishing reports needs Power BI Pro or Premium. Python 3.8+ only matters when you run notebooks on your own machine.

What it helps with

  • split raw CSVs into bronze, silver and gold layers in OneLake
  • clean the data in Dataflow Gen2 without writing Python
  • compute revenue and average order value in a PySpark notebook
  • attach a semantic model to a Power BI report
  • trigger a dataflow refresh from a script over the REST API

Example prompts for the agent

  • Set up the Fabric Lakehouse with bronze, silver and gold folders and place online_retail.csv in the raw layer
  • Write a PySpark notebook that aggregates monthly revenue into the gold layer
  • Describe a Dataflow Gen2 query that dedupes on InvoiceNo and StockCode and adds line_total

How to install microsoft-fabric-unified-analytics

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill microsoft-fabric-unified-analytics -a claude-code

2Manually: put the files in place

~/.claude/skills/microsoft-fabric-unified-analytics/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/microsoft-fabric-unified-analytics/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about microsoft-fabric-unified-analytics

How do I install microsoft-fabric-unified-analytics in Claude Code?

Run npx skills add reason-machines/data-skills --skill microsoft-fabric-unified-analytics -a claude-code. The skill file ends up at ~/.claude/skills/microsoft-fabric-unified-analytics/SKILL.md.

What does this skill do?

It maps the whole data path in Microsoft Fabric: a Lakehouse on OneLake with bronze, silver and gold layers, cleaning in Dataflow Gen2, KPI work in PySpark notebooks, then a semantic model and Power BI reports.

What do I need before using it?

A Fabric workspace backed by Premium or trial capacity, plus Power BI Pro or Premium to publish reports. Python 3.8+ is needed only for local notebook work, and an Azure Storage Account applies when you ingest from an outside source.

Similar skills

All skills for Data and databases →

From the same set82

The whole set →
commercevault-edd-ecommerce-orchestrator The commercevault-edd-ecommerce-orchestrator skill guides an agent through CommerceVault operations for Easy Digital Downloads, from product and order lookups to customer data and sales reports. CX Codex +1 376installs enterprise-user-management-ai-system enterprise-user-management-ai-system — a skill that scaffolds a user management system with Kanban boards, support tickets and AI analytics for risk, anomalies and burnout. CX Codex +1 372installs enterprise-user-management-system-ai-analytics The enterprise-user-management-system-ai-analytics skill outlines a user management app with task tracking, support tickets, and ML analytics. Use it when planning authentication, admin views, or workload and risk analysis. CX Codex +1 338installs web-analytics-agent-skill web-analytics-agent-skill pulls search and visitor metrics from Google Search Console, GA4, and Bing Webmaster Tools. Use it for SEO checks, comparisons, and reports. CX Codex +1 306installs crypto-etl-analytics-core crypto-etl-analytics-core is a Claude Code skill for building a Python and MySQL cryptocurrency OHLCV pipeline with standard-library analytics. CX Codex +1 273installs enterprise-user-management-system-ai enterprise-user-management-system-ai scaffolds a user management platform pairing React and Node.js with a FastAPI machine learning service. CX Codex +1 249installs ai-data-engineering-rag-pipeline ai-data-engineering-rag-pipeline is a Claude Code skill for building a local RAG workflow with BM25 retrieval, hierarchical document chunks, and retrieval scoring. It tests retrieval against a prepared set of questions. CX Codex +1 165installs zomato-ai-data-engineering-pipeline zomato-ai-data-engineering-pipeline is a Claude Code skill for building a food delivery batch pipeline across S3, Snowflake, dbt, and Airflow, with OpenAI for review enrichment and text-to-SQL. CX Codex +1 128installs

More in the catalog

Project sponsors

Companies that keep this analytics open