Hi All

Wed, 25 Nov 2020 16:16:04 GMT

What are the common steps in every Data Modeling process?

Re: Hi All

HirisH_V7 — Mon, 27 Feb 2017 05:55:09 GMT

Hello,

Check out

Data Modeling Tutorial

-Hirish

Re: Hi All

rahulpawarb — Mon, 27 Feb 2017 06:52:21 GMT

Hello Sivababu,

Please go through below given link:

Advanced topics for creating a qlik datamodel

Regards!

Rahul

Re: Hi All

ramasaisaksoft — Mon, 27 Feb 2017 07:01:07 GMT

Hi,

While creating Data Model we will do the below things

-->I hope Extract qvd's creation is completed

-->Now take the extracted qvd's into new qvw's do the calculations as per data Mapping document

-->gave Alias names which are understandable in Application.

-->Create variables for the convenience of calculation.

-->Create star schema or Snow flake schema in Data Model so that associating between the tables created and it will reduce Application refreshment time .

-->after created Data model use this as a source file for Application (which is visible to Business user).

and some more points are

Less Joins more comfort
Avoid Synthetic Keys
Circular Loops... No worries, Link Tables are our friends
Star or Snowflake.... Both are good but conditions apply*
Build multi tier architecture
Cleanse the data before Loading! Handle NULLs in data
Delete Unused Columns and Tables
Use Data Islands where necessary
Join, Concatenate or Keep?... Go with ApplyMap() over Join
Check Subset Ratio and Information Density at (Ctrl+T) table viewer

if you got the solution for your query,Please close this issue by clicking "Correct Answer"

topic Re: Hi All in QlikView

Hi All

Re: Hi All

Re: Hi All

Re: Hi All