Star schemas are one of the primary types of data warehouse schemas.
A data warehouse schema illustrates the shape of your data; how to structure your tables, and the relationships between the tables.
Using superstore dataset, this blog post will demonstrate the star schema.
In the center is a fact table, containing measures (e.g. profit) and unique identifiers for dimensions (e.g. order ID or ShipMode ID). The rows in the schema should only contain numbers.
Shooting out from the fact table are dimension tables. Dimension tables contain categories that describe your measures/unique identifiers, for example a unique identifier may be customer ID, and the dimensions that describe this would be customer name and segment.
