Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
prachi91
Creator III
Creator III

Data Modeling in Qlikview

Define Data Modeling in Qlikview ?

1 Solution

Accepted Solutions
sumitjadhav
Creator II
Creator II

A Data Modelling in Qlikview Can be Defined as a Pictorial Representation of Tables Present in the data with their Associated Relationships to show the Data Flow Process of the whole System or model,it also helps in representing the Key fields and Data Dependency Factors that Helps in Normalization and simplification of data Structure.

View solution in original post

10 Replies
sumitjadhav
Creator II
Creator II

A Data Modelling in Qlikview Can be Defined as a Pictorial Representation of Tables Present in the data with their Associated Relationships to show the Data Flow Process of the whole System or model,it also helps in representing the Key fields and Data Dependency Factors that Helps in Normalization and simplification of data Structure.

View solution in original post

prachi91
Creator III
Creator III

Data Modeling is a combination of fact and dimension? and it is part of schema?..

sumitjadhav
Creator II
Creator II

yes ,we either use star schema or else we use snow flake schema,but we normally end's up with the snow flake schema.the reason for that is to avoid data redundancy and to make data more normalised.

prachi91
Creator III
Creator III

Thank You Sumit.

sasiparupudi1
Master III
Master III

Yes it is combination of dimension tables linked to a fact table . It is recommended to end up with a star schema which has got the ideal trade off on the resources..

look at the following post  may be it can help you further

Re: Re: Star schema or snowflake schema or flat file?

prachi91
Creator III
Creator III

it is end up with star schema or snow flake schema? bcause sumit said it is end up with snowflake.

sasiparupudi1
Master III
Master III

Hi

It is your choice really.  You as a developer construct the data model as per the application requirement.

Snowflake is generally used to limit duplicate data which is irrelevant in Qlikview's case as it automatically eliminates duplicates by design. if a value is repeated, it only stores once.

In Qlikview, Star schema is an ideal choice.

prachi91
Creator III
Creator III

very helpful to me thank you so much.

cheburashka
Creator III
Creator III

Hello Prachi,

For me data modeling is creating links between tables based on business reasoning. If you can't explain the business logic for a link between two tables you likely have a problem with your technical data model setup. I've created a Key Check module (script subroutine + set of frontend objects) to easily check some basic business questions.

Hope you find it usefull.


Have fun Qlik'n, Koen

QlikViewModules.com