Creating Dimension tables
We should already be connected to the Chapter 6, Sales Data.xlsx file from Power Query Editor. In this section, we look at the necessity of creating the potential dimensions identified in the previous section. We first evaluate each dimension from a business requirement perspective. If we are convinced that the dimension is required, we create it.
Geography
The identified business requirements show that we must have a dimension keeping geographical data. When we look at the data, we can see geography-related columns in the Sales table. We can create a separate Geography dimension derived from the Sales table. However, this might not cover all business requirements.
As the following image shows, there are some geography-related columns in the Customer table. We must find commonalities in the data and think about the possibility of combining the data from both tables into a single Geography dimension. Using Column Distribution shows that the CustomerKey...
