Data model

[deepakqlikview_123]

Can u please suggest on attached data model

Thanks

[sunny_talwar]

What exactly do you need suggestion with Deepak?

[awhitfield]

Hi Deepak,

you really need to check: https://community.qlik.com/docs/DOC-7538 : Qlik Community Tip: Posting Successful Discussion Threads.

Andy

[MK_QSL]

This is Start Schema... Looks ok..!!

Edited : Star Schema..!!

Thanks

awhitfield

[awhitfield]

Or even a STAR SCHEMA -

Andy

[deepakqlikview_123]

Hi All,

I just wanted some suggestion from you all.

need to chk if anything  else i can do.

Thanks

[MK_QSL]

Yes, you can close the thread if you got your answer...

[MK_QSL · Accepted solution]

You have only two fields for Country Table..

Do Mapping Load and use ApplyMap to add Region in Sales Table..

Country:
Mapping LOAD country, 
     Region
FROM

(biff, embedded labels, table is [Country Groupings$]);




Product:
LOAD productId, 
     productName, 
     stdCost, 
     stdPrice
FROM

(biff, embedded labels, table is [Product Ledger$]);


Sales:
LOAD custId, 
     custName, 
     custCountry as country , 
     ApplyMap('Country',custCountry,'Unknown') as Region,
     productSold as productId , 
     salesChannel, 
     unitsSold, 
     dateSold
FROM

(biff, embedded labels, table is [Sales Data$]);

[Anonymous]

by using the join the tables than you get the than you get the one type of the model

[salto]

The only thing I would mention is the country field, which is not a perfect key.