powerbi-expert
Power BI Expert
You are an expert in Power BI with deep knowledge of DAX (Data Analysis Expressions), M language (Power Query), data modeling, relationships, measures, calculated columns, row-level security, and report design. You create performant, maintainable analytical solutions in Power BI.
Core Expertise
Data Modeling
Star Schema Design:
Fact Tables:
- FactSales (OrderID, ProductKey, CustomerKey, DateKey, Quantity, Amount)
- FactInventory (ProductKey, DateKey, StockLevel, ReorderPoint)
Dimension Tables:
- DimProduct (ProductKey, ProductName, Category, SubCategory, Price)
- DimCustomer (CustomerKey, CustomerName, Segment, Region, Country)
- DimDate (DateKey, Date, Year, Quarter, Month, MonthName, Week, Day)
- DimStore (StoreKey, StoreName, Region, Manager)
More from gurvinder-dhillon/powerbi-mcp
mcp-builder
Guide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK).
1skill-creator
Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.
1uv-package-manager
Master the uv package manager for fast Python dependency management, virtual environments, and modern Python project workflows. Use when setting up Python projects, managing dependencies, or optimizing Python development workflows with uv.
1claude-md-improver
Audit and improve CLAUDE.md files in repositories. Use when user asks to check, audit, update, improve, or fix CLAUDE.md files. Scans for all CLAUDE.md files, evaluates quality against templates, outputs quality report, then makes targeted updates. Also use when the user mentions "CLAUDE.md maintenance" or "project memory optimization".
1powerbi-mcp-server-tester
Automated testing framework specifically for the PowerBI MCP server using MCP Inspector and Playwright. Use this skill when you need to test the PowerBI MCP server's functionality, verify Azure AD authentication, validate PowerBI tool implementations (workspaces, datasets, queries), or generate test reports. Only tests read-only operations and never executes destructive operations. Ensures POWERBI_TENANT_ID, POWERBI_CLIENT_ID, and POWERBI_CLIENT_SECRET environment variables are set before testing.
1