topic Re:data model in QlikView

Re:data model

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

Hi all,

can any one explain what are the measures to be taken for designing a good data model when ever we load data into qlik?

thanks

vijay

kfoudhaily — Sat, 28 Jul 2018 20:17:40 GMT

md_qlikview — Sun, 29 Jul 2018 01:38:11 GMT

Hi Vijay,

you can get n number of help on community from previous post. Also you can use help section from qlik.

Below are few documents from community

BalaBhaskar_Qlik — Sun, 29 Jul 2018 12:56:24 GMT

1. Initial data load with proper connection strings.

2. Load individual tables, then Join/Concatenate/Mapping/Keep based on data, fields.

3. Clear most of the Synthetic keys to make tables are Clear

4. Follow renaming, alias, Qualify, UnQualify to make tables as independent.

5. Create / translate coded values.

6. Follow naming standards, Code updates (Add comments to identify modifications easily)

7. Deriving new fields by Data aggregations.

8. Unit test on data accuracy.

9. Debug script for data load.

10. Create loops to update, instead of more script creation.

11. Sequence generation with different functions to avoid data loss.

12. Follow these steps to n no.of times to avoid other issues.

Then better data model created.