Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mikel_de
New Contributor III

Advice about data model

Hello,

I have been trying to fix a model that had several synthetic keys and even a circular reference. After joining some tables, creating new keys and using mapping load when possible, I ended up with a model looking like this:

Capture.PNG

So I have two keys (Supplier_Group_Key and PO_Item_Key) that link three tables each. Even though the model works and the numbers are correct, as I am not really a data model expert, my question is, is this a good practice or there is a better way to do it?

This is just for learning purposes. Thanks!

1 Solution

Accepted Solutions
MVP
MVP

Re: Advice about data model

No this seems to me to follow a very good practice.

Main would be called a FACT table.

The other tables are dimension tables.

3 Replies
MVP
MVP

Re: Advice about data model

No this seems to me to follow a very good practice.

Main would be called a FACT table.

The other tables are dimension tables.

paul_scotchford
Valued Contributor

Re: Advice about data model

I agree with Petter, your approach is very acceptable and one I use a lot.

mikel_de
New Contributor III

Re: Advice about data model

Thank you, Petter and Paul, for your input. Nice to know that I am on the right track.

Cheers!