powerbi-core
Installation
SKILL.md
Power BI Core Concepts and Data Modeling
Overview
Core Power BI knowledge covering data modeling best practices, connectivity modes, source types, relationships, and common pitfalls. This skill provides the foundational architecture guidance every Power BI developer needs.
Data Model Design - Star Schema
Always design data models using star schema topology:
| Component | Purpose | Example |
|---|---|---|
| Fact table | Numeric events/transactions | Sales, Orders, WebVisits |
| Dimension table | Descriptive attributes | Date, Product, Customer, Geography |
| Bridge table | Many-to-many resolution | StudentCourse, OrderProduct |