What is a schema?
In data modeling, a schema is the structure or blueprint of how data is organized in a database or data model.
It defines:
- How tables are arranged
- How tables are related to each other
- What type of data each column stores
In simple terms:
Schema = Design or layout of your data
Why Schema is Important
A well-defined schema helps to
- Organize data efficiently
- Improve query performance
- Ensure accurate relationships between tables
- Make reports easy to understand
Schema in Power BI
In Power BI, a schema represents how your fact table and dimension tables are connected.
Common types of schemas used in Power BI:
- Star Schema
- Snowflake Schema
- Galaxy Schema
