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.