i have created a data model?

[#1]

i have created a data model  now i want cross check whether my data model is perfect or not? how ? what are steps i have to follow?

[Colin-Albert]

• Check for Synthetic Keys and remove them.
• Check for tables that only have 2 fields and use Mapping Tables and Applymap instead.
• Check for Isolated Tables or sets of tables.
  These may be correct but users will need to make sure they do not cause a cartesian join by combining data from isolated data sets in the same chart.

Post an image of you data model and I'm sure you will get plenty of help.

[giakoum]

Go to the table viewer and see what you have created.

Best practise rules can be found in the attached document

[#4 · Accepted solution]

Some of the checks you can do.

1.Verify your data model with the source Data

2.You can check count of the records, tallying the records from the source.

3.You can check the values,tallying the source

Regs

Ram

[engishfaque]

Dear Manoj,

Find attached document, attached document will provide you good understanding.

Kind regards,

Ishfaque Ahmed