Power BI Dashboard Architect

Design and build production-grade Power BI dashboards with optimized data models, advanced DAX measures, and professional visualization layouts. Get expert guidance on star schema modeling, performance tuning, Row-Level Security, and deployment pipelines.

Gold

v1.0.00 activationsData & AnalyticsTechnologyexpert

SupaScore

83.6

Research Quality (15%)

8.4

Prompt Engineering (25%)

8.5

Practical Utility (15%)

8.4

Completeness (10%)

8.3

User Satisfaction (20%)

8.2

Decision Usefulness (15%)

8.3

Best for

▸Building executive KPI dashboards with star schema data models and DAX time intelligence measures
▸Optimizing Power BI performance through VertiPaq compression and DirectQuery query reduction
▸Implementing row-level security for multi-tenant SaaS reporting with dynamic filtering
▸Designing incremental refresh strategies for large fact tables with partition management
▸Creating IBCS-compliant financial reporting dashboards with variance analysis and waterfall charts

What you'll get

●Detailed star schema ERD with fact/dimension relationships, DAX code for 15+ business measures with proper formatting, and performance optimization checklist
●Complete dashboard wireframe with page navigation flow, filter hierarchy design, and mobile responsiveness specifications
●Row-level security implementation guide with DAX security filters, user role definitions, and testing procedures

Not designed for ↓

×Basic Excel pivot table creation or simple chart formatting
×Power Platform automation workflows or Power Apps development
×SQL database administration or ETL pipeline development
×Tableau or Qlik Sense dashboard migration without Power BI context

Expects

Business requirements including KPIs, data sources, user roles, refresh frequency, and performance constraints with sample data structure.

Returns

Complete Power BI solution architecture with star schema design, DAX measure library, dashboard wireframes, and deployment strategy.

Evidence Policy

Enabled: this skill cites sources and distinguishes evidence from opinion.

power-bidaxdata-modelingstar-schemadashboard-designrow-level-securitydataflowsperformance-optimizationbusiness-intelligenceibcsvertipaq

Research Foundation: 7 sources (2 official docs, 2 books, 2 industry frameworks, 1 expert knowledge)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.

Version History

v1.0.02/16/2026

Initial release

Prerequisites

Use these skills first for best results.

SQL Query OptimizerPlatinum

Works well with

Dashboard Design StrategistGold Data Warehouse ArchitectGold dbt Analytics EngineerGold Financial KPI Dashboard DesignerGold Snowflake Data Modeling ExpertGold

Need more depth?

Specialist skills that go deeper in areas this skill touches.

Data Pipeline ArchitectGold Azure Cloud ArchitectGold Real-Time Analytics ArchitectGold

Common Workflows

Enterprise BI Implementation

Full enterprise business intelligence implementation from data warehouse design through Power BI modeling to professional dashboard presentation

Data Warehouse Architect→power-bi-dashboard-architect→Dashboard Design Strategist

Activate this skill in Claude Code

Start Free to Activate This Skill