topic Re: Data model in QlikView

Data model

deepakqlikview_123 — Wed, 27 Apr 2016 10:24:09 GMT

Can u please suggest on attached data model

Thanks

Re: Data model

sunny_talwar — Wed, 27 Apr 2016 10:24:59 GMT

What exactly do you need suggestion with Deepak?

Re: Data model

awhitfield — Wed, 27 Apr 2016 10:27:06 GMT

Hi Deepak,

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

Andy

Re: Data model

MK_QSL — Wed, 27 Apr 2016 10:28:04 GMT

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

Edited : Star Schema..!!

Thanks

awhitfield

Re: Data model

awhitfield — Wed, 27 Apr 2016 10:33:04 GMT

Or even a STAR SCHEMA -

Andy

Re: Data model

deepakqlikview_123 — Wed, 27 Apr 2016 10:35:50 GMT

Hi All,

I just wanted some suggestion from you all.

need to chk if anything else i can do.

Thanks

Re: Data model

MK_QSL — Wed, 27 Apr 2016 10:36:19 GMT

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

Re: Data model

MK_QSL — Wed, 27 Apr 2016 10:39:03 GMT

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$]);

Re: Data model

Anonymous — Wed, 27 Apr 2016 10:59:30 GMT

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

Re: Data model

salto — Wed, 27 Apr 2016 12:15:06 GMT

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