Best practices (data warehouse+Qlik)

[navzintel]

Hi, I’m a BA for the Data Warehouse and the Qlik Apps for our company. I just recently switched companies and at my new company, they try to solve almost everything with Qlik Apps, but in all my classes and/or certificate programs I was taught that the front end tool should be ‘dumb’. The data logic should be in the data warehouse. The consultants for Qlik think otherwise and try to transform in qvd. What is the best practice in your company?

[eronevil]

Hello,

I faced same thing earlier company where i worked. We stored data from dbs and excels to folder on prem server hard disk after that we made ETL-prosess to data and saved it to other folder.

folder system was something like this

Raw data folder

and 

Production data folder.

In Raw and Production folder data was more folder by system

Raw data folder:

1.System

2.System

3.System

Production data folder:

1.System

2.System

3.System

Qvd-files were named as table in db. So if it was just loaded form db it path was C:/Qlik/Raw Data/1.System/table.qvd

And if it was very big and monthly data we named tables by month C:/Qlik/Raw Data/1.System/table-2022-06.qvd

-V

[marcus_sommer]

It's not really a new question: Best practices (data warehouse+Qlik) - Qlik Community - 1802395

- Marcus