How to Start Data modeling in Qlikview - Qlik Community

Report Inappropriate Content · ‎2014-07-18

Hi,

Can anyone please suggest me how to start data modeling in qlikview from scratch, please suggest me the steps to start with like how to start analysis etc...

senpradip007 · ‎2014-07-18

Please go through this thread Creating a Data Model

anandathome · ‎2014-07-18

Below will be the steps:

1. Study your source data.

2. Identify Dimensions and facts.

3. Decide the grain of data to be loaded. (detailed or aggregated).

4. If you have more than one fact table, then have a look at below references.

5. Create design of your data model outside qlikview (on paper or any other design tool if available).

6. Write load scripts accordingly to create the designed data model in qlikview.

References:

Best Practices for Data Modelling

http://community.qlik.com/servlet/JiveServlet/previewBody/4744-102-1-5707/Best%20Uses%20for%20%20Dat...

Anonymous · ‎2014-07-18

Hello Savitha,

This is a more conceptual question. Understanding of data model is gained through creating small hands on by yourself, going through reference materials in data modelling.