Data Modelling and Relationships

[colinodone]

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,

[Praful_Potphode]

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

[colinodone]

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.

[colinodone]

Thank you. Will have a look at these two options

[MattiaFratello · Accepted solution]

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/