Forum Discussion
Data Modelling and Relationships
Hello there,
Are there any pre-built apps that help summarise the data in a table and examination the strength of the relationship between the key fields
e.g.
Table Summary with things like number of columns, stats per column like number of records, duplicates, type, nulls
Key field summary with things like subset ratio, nulls, missing records,
the data being loaded into the data model can be pretty random and i need to ensure that the data is modeled correctly, is clean and well understood before using it for analysis.
Thank you,
Try https://learn.microsoft.com/en-us/power-query/data-profiling-tools or for more advanced use you can have a look at https://daxstudio.org/
4 Replies
Hi colinodone
Appart from options suggested by MattiaFratello ,you can also try Vertipaq Analyzer ,Measure Killer and Bravo
Please give it kudos or mark it as resolved once confirmed.
Thanks and Regards,
Praful
Thanks Praful.
Looks like some great options there. the requirement to download applications won't work in my situation due to corporate restrictions, but it is good to know what is available and potential limitations resolved by these apps.
Try https://learn.microsoft.com/en-us/power-query/data-profiling-tools or for more advanced use you can have a look at https://daxstudio.org/
Thank you. Will have a look at these two options
