Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Start Data modeling in Qlikview

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...

3 Replies
senpradip007
Specialist III
Specialist III

Please go through this thread Creating a Data Model   

anandathome
Creator
Creator

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...

thisisnita
Creator
Creator


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.