topic Re: Data Model in QlikView

Data Model

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

While creating data model in qlik view, which would be better star schema or snow flake schema and is it necessary to create fact and dimension table for qlik view data mode..as much i know, qlik doesnt need fact table as its automatically gets related due to its association property..any body suggest me clearly about data model in qlik view....

Re: Data Model

sushil353 — Fri, 02 Dec 2016 05:17:07 GMT

Check this out: Data Warehousing Schemas

Re: Data Model

Anil_Babu_Samineni — Fri, 02 Dec 2016 05:19:05 GMT

Yes,

1) I would read Star Schema is goof performance

2) Fact and Dimension is mandatory, While Fact produce that is good step to create Link / Dimension with that fact

3) As you said, we need to create Fact table for good Data model to show the understanding level.

Hope helps to you

Re: Data Model

Anonymous — Fri, 02 Dec 2016 05:23:47 GMT

Hi praveen,

In Qlikview, when we are extracting multiple tables from data source...qlikview automatically forms a relationship/link between these tables.(if they have any matching fields only ).

and..i think star schema is better than the snowflake schema.

it is necessary to maintain the fact tables and dimension tables in our business data. because dimension tables maintains details about business data and fact tables maintains about business transactions like..orderdates,shipping date..etc.,

Re: Data Model

praveenkumar_s — Fri, 02 Dec 2016 05:28:44 GMT

how to create fact table in qlik view without duplicating data..

Re: Data Model

praveenkumar_s — Fri, 02 Dec 2016 05:30:01 GMT

Hi,

Please explain clearly about fact and dimension table...

Re: Data Model

Vegar — Fri, 02 Dec 2016 05:30:33 GMT

I think this is a good read by richard.pearce60. It will help your understand .

https://qlikcentral.com/2014/08/19/the-optimal-qlikview-data-structure/

Re: Data Model

Fri, 02 Dec 2016 05:41:02 GMT

Hi Praveen,

Please go through this document. It might helpful to you.

Thanks!!

Br,
Habib Shaik.

Re: Data Model

praveenkumar_s — Fri, 02 Dec 2016 05:52:44 GMT

Hi habib,

I didnt get any documents..please resend ...

Re: Data Model

Anonymous — Fri, 02 Dec 2016 06:42:18 GMT

hi praveen,

dimension table:it contains descriptive details about our business object,

like.,employee table and customer table and product table.

employee table only have these related details and customer table&product table is also describes about only these relative details.

dimension table is nothing but a...master table.

Dimension: is nothing but a measure attribute.(dimension is a collection of information about measurable values).

and coming to fact table: it contains maximum number of numeric values nothing but measures.

and fact table also contains multiple foreign keys mostly.

fact table is nothing but a....transaction table.

Measure: is a value that can be added up to provide meaning to your dimension.

Re: Data Model

Fri, 02 Dec 2016 07:47:01 GMT

Are you able to view the PPT presentation? If not let me know. I will upload again.

Re: Data Model

marcus_sommer — Fri, 02 Dec 2016 08:58:15 GMT

Take a look here: A perfect datamodel?

- Marcus

Re: Data Model

cheburashka — Thu, 19 Jan 2017 12:11:06 GMT

Hello Guys,

I've created some QvM - Qlikview Modules that I use in each project to do some validation steps when building a datamodel. Maybe you'll find them useful.

,KR Koen