Create a star schema data model

[Chandra3]

Hi all 

I'm new to qlikview , here i want to create a star schema data model. Help me how to solve this

EX:

here  my scenario is :

Table1: Fact table: [Confirmed Cases], [Active Cases], [Cured/Discharged], Death

Table2: Dimension1: [S. No.], Date, Month, Year

Table3: Dimension2: Querter, Region

Table4: Dimension3: //Month, Year as Year_wise, Querter

Table5: Dimension4:[S. No.]as s_no, Date,Region

After loading data i was fixed synthetic keys, then i want create this a star schema dat model how?

Thanks and regards

chandra3 

[anat]

as per your metadata there is no relation between  Fact and dimension  tables

[Harvey]

---

@MyBalanceNow wrote:

Hi all 

I'm new to qlikview , here i want to create a star schema data model. Help me how to solve this

EX:

here  my scenario is :

Table1: Fact table: [Confirmed Cases], [Active Cases], [Cured/Discharged], Death

Table2: Dimension1: [S. No.], Date, Month, Year

Table3: Dimension2: Querter, Region

Table4: Dimension3: //Month, Year as Year_wise, Querter

Table5: Dimension4:[S. No.]as s_no, Date,Region

After loading data i was fixed synthetic keys, then i want create this a star schema dat model how?

Thanks and regards

chandra3 

---

Identify a business process for analysis(like sales).
Identify measures or facts (sales dollar).
Identify dimensions for facts(product dimension, location dimension, time dimension, organization dimension).
List the columns that describe each dimension.

[sachin961]

Hi,

In Fact table should have some Id field so that you can connect with other Dimension table then you can only make star schema.