skills.rest
JonathanMitchell1234
JonathanMitchell1234COMMUNITY
Explore all skills by this author →
GitHub

powerbi-expert

Create Power BI solutions with DAX, M language, and data modeling.

Updated Feb 27, 2026
Search Tags:#analytics#data modeling#business intelligence#dax#power-query#powerbi
One-click install
npx skills add https://github.com/JonathanMitchell1234/Stock-Swing-Trading-Bot --skill powerbi-expert-jonathanmitchell1234
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: powerbi-expert
Source: https://github.com/JonathanMitchell1234/Stock-Swing-Trading-Bot/tree/main/.agents/skills/powerbi-expert
Command: npx skills add https://github.com/JonathanMitchell1234/Stock-Swing-Trading-Bot --skill powerbi-expert-jonathanmitchell1234

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill empowers users to build sophisticated, high-performance analytical solutions in Power BI, overcoming complex data challenges.

Core Features & Use Cases

  • Data Modeling: Design efficient star schemas and manage relationships.
  • DAX & M Language: Write advanced measures, calculated columns, and Power Query transformations.
  • Report Design & Security: Create insightful reports with RLS and best practices.
  • Use Case: A business analyst needs to create a sales performance dashboard. They can use this Skill to model sales data, write DAX measures for YOY growth, and design interactive visuals with row-level security for regional managers.

Quick Start

Use the powerbi-expert skill to create a DAX measure for Year-over-Year sales growth.

Frequently Asked Questions about powerbi-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write a DAX measure for Year-over-Year sales growth in Power BI?▼

To calculate Year-over-Year sales growth in Power BI, you write a DAX measure comparing current period sales against the previous year using time intelligence functions. This Skill helps create performant measures for accurate analytical results.

What is the best way to design a star schema for Power BI data modeling?▼

Designing a star schema for Power BI data modeling involves separating fact and dimension tables to optimize query performance. This Skill provides expert assistance in managing relationships and building efficient, maintainable data models.

How do I transform data using M language in Power Query?▼

Transforming data using M language in Power Query involves writing custom functions to shape and clean your datasets before loading them into the model. This Skill assists with advanced M language transformations and data preparation steps.

Can I implement row-level security for regional managers in a Power BI report?▼

You can implement row-level security (RLS) in a Power BI report by defining DAX filters on specific tables to restrict data access. This Skill helps configure RLS so regional managers only see their designated data.

Why does my DAX measure perform slowly in a large Power BI data model?▼

DAX measures perform slowly in large Power BI data models due to inefficient data modeling or unoptimized formula logic. This Skill solves complex analytical problems by applying DAX optimization techniques and data warehousing best practices.

Related Skills

Explore More Data & Analytics Skills→
bcastelinobcastelino

data-source-connector

Connect to various data sources and generate a normalized data-model.json.

Community
Advanced
tippyentertainmenttippyentertainment

power-bi-developer

Develop Power BI reports, data models, and deployment pipelines with RLS.

Community
Advanced
AradotsoAradotso
5

power-bi-salespulse-360-dashboard

Transform the Global Superstore dataset into retail analytics dashboards with Power BI Desktop and DAX.

Official
Advanced
dy9759dy9759
1

data-visualization-expert

Design charts, dashboards, and interactive data applications for business analytics.

Community
Intermediate