Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
good morning experts
very recently I have been facing a professional challenge with production data. I am nervous because things are not going as I would like, so all the help you can give me, I will be grateful.
I have the following table (sample) onedrive table and I need to start normalizing it to make it work fine in the data model
How should it look?
Solved! Go to Solution.
Hi @jcamilo1985 ,
It is hard to say specifically as I don't know what your end goal is, but as a general rule values should be unpivoted and leave text fields alone. That is not a hard and fast rule, just a general rule. What I did:
See the file attached here which should get you started. See the "normalized" tab for the work I did. You can see the transformations in Power Query itself. There is an article below on normalizing, as well as the importance of a Star Schema in Power BI, of which getting your table normalized is key, so you are definitely on the right track.
What is normalizing data?
See the Normalizing an example table section of this paper
Microsoft Guidance on Importance of Star Schema
If you have more specific needs in visuals or calculations, please post back with some expected results and we can assist in tweaking how the data is normalized for your specific model.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @jcamilo1985 ,
It is hard to say specifically as I don't know what your end goal is, but as a general rule values should be unpivoted and leave text fields alone. That is not a hard and fast rule, just a general rule. What I did:
See the file attached here which should get you started. See the "normalized" tab for the work I did. You can see the transformations in Power Query itself. There is an article below on normalizing, as well as the importance of a Star Schema in Power BI, of which getting your table normalized is key, so you are definitely on the right track.
What is normalizing data?
See the Normalizing an example table section of this paper
Microsoft Guidance on Importance of Star Schema
If you have more specific needs in visuals or calculations, please post back with some expected results and we can assist in tweaking how the data is normalized for your specific model.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@edhans Thank you very much for the quick response, really thank you very much, that is why I love this community.
Annex link full archive where you currently find the outline of the report as well as the necessary files.
I know that the data model is horrible and it can be improved, but I do not find it easy to do it, for example you will find that the book "executive sales" has both quantities and sales amounts and I was wondering if in the normalization it is correct to leave it in a single attribute , I appreciate you can guide me.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
20 | |
11 | |
10 | |
8 | |
7 |