Data Normalization

leimst
Posts: 27
Joined: Wed Feb 25, 2015 4:51 am

Data Normalization

Postby leimst » Thu Jan 11, 2018 9:18 pm

Good Morning All,

Looking for a high level description of how to take a large flat table and divy it up into multiple tables, e.g. one fact table and multiple lookup tables, using Power Query.

Thank you in advance,

leimst

MattAllington
Posts: 993
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Data Normalization

Postby MattAllington » Fri Jan 12, 2018 8:41 am

  • connect to the source data
  • set this query so it doesn't load. In PBI, right click and turn off "enable load". In Excel, "close and load", "Connection only"
  • go back into power query, right click on the above query, select "reference"
  • build table 1
  • repeat the 2 steps above for each additional table

Tap on the following link to learn more about my Power BI Training.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

leimst
Posts: 27
Joined: Wed Feb 25, 2015 4:51 am

Re: Data Normalization

Postby leimst » Thu Feb 01, 2018 5:40 am

Thank you for the high level summary Matt. Exactly what I needed.

leimst

h_gp9
Posts: 26
Joined: Wed Jan 18, 2017 9:50 am

Re: Data Normalization

Postby h_gp9 » Fri Apr 27, 2018 3:52 am

Hi Matt:
After Normalization, how to carry "reference" to another excel workbook in order to combine with more database.
thanks in advanced.


MattAllington wrote:
  • connect to the source data
  • set this query so it doesn't load. In PBI, right click and turn off "enable load". In Excel, "close and load", "Connection only"
  • go back into power query, right click on the above query, select "reference"
  • build table 1
  • repeat the 2 steps above for each additional table


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 2 guests