topic Re: Data Modeling in Qlikview in QlikView

Data Modeling in Qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Define Data Modeling in Qlikview ?

Re: Data Modeling in Qlikview

sumitjadhav — Thu, 23 Feb 2017 11:15:16 GMT

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.

Re: Data Modeling in Qlikview

Anonymous — Thu, 23 Feb 2017 11:18:28 GMT

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

Re: Data Modeling in Qlikview

sumitjadhav — Thu, 23 Feb 2017 11:28:30 GMT

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.

Re: Data Modeling in Qlikview

Anonymous — Thu, 23 Feb 2017 11:31:28 GMT

Thank You Sumit.

Re: Data Modeling in Qlikview

sasiparupudi1 — Thu, 23 Feb 2017 11:40:37 GMT

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?

Re: Data Modeling in Qlikview

Anonymous — Thu, 23 Feb 2017 11:55:32 GMT

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

Re: Data Modeling in Qlikview

sasiparupudi1 — Thu, 23 Feb 2017 12:08:34 GMT

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.

Re: Data Modeling in Qlikview

Anonymous — Thu, 23 Feb 2017 12:27:00 GMT

very helpful to me thank you so much.

Re: Data Modeling in Qlikview

cheburashka — Sat, 27 May 2017 20:42:59 GMT

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

Re: Data Modeling in Qlikview

deepakahirwar — Tue, 07 May 2019 06:27:47 GMT

#Great Answer!