Splitting data into facts and dimensions
Datasets will frequently come in a "wide" format, containing both fact and dimensional data. Breaking these files out into facts and dimensions will improve queries and can improve performance on larger datasets.
In the next few exercises, we'll be creating the following star schema:

Let's start by creating the Establishment Survey fact and Industry dimension tables.
This exercise is part of the course
Data Modeling in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
