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: 947
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
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
https://exceleratorbi.com.au/power-bi-online-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 6 guests

cron