---
stable_id: skills/skills-sh-github-awesome-copilot-powerbi-modeling
type: skills
title: skills-sh-github-awesome-copilot-powerbi-modeling
summary: >-
  # Star Schema Design for Power BI

  ## Overview

  Star schema is the optimal design pattern for Power BI semantic models. It
  organizes data into:

  - **Dimension tables**: Enable filtering and grouping (the "one" side)

  - **Fact tables**: Enable summarization (the "many" side)

  ## Table Classification

  ### Dimension Tables

  - Contain descriptive attributes for filtering/slicing

  - Have unique key columns (one row per entity)

  - Examples: Customer, Product, Date, Geography, Employee
tags:
  - skills-sh
  - skills-sh-all-time
source_url: https://raw.githubusercontent.com/github/awesome-copilot/HEAD/skills/powerbi-modeling/references/STAR-SCHEMA.md
license: ""
upstream_ref: https://skills.sh/github/awesome-copilot/powerbi-modeling
github_stars: 26261
github_forks: 3023
github_is_organization: true
retrieved_at: 2026-06-11T08:33:23.747Z
content_sha256: af288e11a243a090f9a2d540103d49d3b6d0d20e39a85e9b45c51175eb0028b2
---
