Powerbi Expert
This is a comprehensive Power BI reference that covers the full stack: DAX measures, M language for Power Query, star schema modeling, and time intelligence patterns. You get concrete examples for everything from basic CALCULATE filters to iterator functions like SUMX and RANKX, plus proper date table setup and relationship management. The DAX section is especially thorough with variables, context switching, and year-over-year calculations you'll actually use. If you're building dashboards or data models in Power BI and need to look up syntax or see how to structure measures correctly, this gives you working patterns instead of documentation links. It assumes you know what you're trying to do and just need the right DAX formula or modeling approach.
- skills.sh installs
- 377
- GitHub stars
- 44
- last updated
- Aug 21, 2026
Install
$ npx -y skills add personamanagmentlayer/pcl --skill powerbi-expert --agent claude-codeInstalls into .claude/skills of the current project.
Files
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.
Best Practices
1. Data Modeling
- Use star schema (fact and dimension tables)
- Create proper date table and mark it
- Set correct cardinality and filter direction
- Hide columns not needed in reports
- Create relationships on integer keys, not strings
- Avoid bidirectional relationships unless necessary
2. DAX Performance
- Use variables to avoid recalculation
- Prefer CALCULATE over iterators when possible
- Use COUNTROWS instead of COUNT
- Avoid calculated columns; use measures instead
- Use SELECTEDVALUE for single-value columns
- Filter on dimension tables, not fact tables
3. Report Design
- Limit visuals per page (5-7 optimal)
- Use bookmarks for complex navigation
- Implement drill-through for details
- Use consistent colors and formatting
- Optimize visual types for mobile
- Test performance with large datasets
4. Power Query
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/personamanagmentlayer/pcl
- Category
- Design & UI/UX
- First seen
- Jun 3, 2026
More from personamanagmentlayer/pcl
All 99- Docker Expert368
- Ml Expert365
- R Expert324
- Java Expert305
- Hospitality Expert296
- Blockchain Expert294
- Tableau Expert294
- Openapi Expert280
- Energy Expert279
- Farming Expert279
- Git Expert276
- Python Expert275
- Redis Expert270
- Php Expert265
- Grafana Expert263
- Sql Expert257
- Research Expert253
- Cpp Expert248
- Helm Expert245
- Ai Engineer Expert239
- Quantum Expert238
- Finops Expert236
- Iot Expert236
- Snowflake Expert236
Recommended
More Design & UI/UX
instagram-marketingterminalskills/skillsCreate, optimize, and automate Instagram content including Reels, Stories, carousels, and feed posts. Use when someone asks to "grow on Instagram", "create Inst375skills.sh installs
react-flow-implementationexistential-birds/beagleImplements React Flow node-based UIs correctly using @xyflow/react. Use when building flow charts, diagrams, visual editors, or node-based applications with Rea374skills.sh installs
agent-workflowsharpdeveye/maestroUse when any Maestro command is invoked — provides foundational workflow design principles across prompt engineering, context management, tool orchestration, ag374skills.sh installs
syncfusion-blazor-mapssyncfusion/blazor-ui-components-skillsImplement interactive spatial data visualization with Syncfusion Maps component for Blazor. Use this skill when user needs to display geographic data, add marke374skills.sh installs
monetizing-innovationpmprompt/claude-plugin-product-managementUse when asked about "pricing strategy", "willingness to pay", "value metric", "packaging tiers", "good better best pricing", "subscription vs usage pricing", o373skills.sh installs
drugbank-databasedavila7/claude-code-templatesAccess and analyze comprehensive drug information from the DrugBank database including drug properties, interactions, targets, pathways, chemical structures, an372skills.sh installs