article Qlik Compose Data Warehouse Modeling Best Practices in Official Support Articles

Qlik Compose Data Warehouse Modeling Best Practices

TimGarrod — Thu, 20 Jan 2022 15:34:24 GMT

This technical whitepaper provides best practices for modeling your data warehouse structures in Qlik Compose data warehouse projects.

Re: Qlik Compose Data Warehouse Modeling Best Practices

vtatarnikov — Thu, 19 Aug 2021 14:34:48 GMT

Greate! Do you have a similar guide for data lakes?

Re: Qlik Compose Data Warehouse Modeling Best Practices

TimGarrod — Thu, 19 Aug 2021 15:10:17 GMT

Compose Data Lake projects are purpose built to manage a pure ODS ("replicated copy of data") and HDS ("historical view of data changes - ie. Type 2") that typically conform to the source system.

Consider a typical data lake architecture with 'RAW / Landed data' --> Bronze --> Silver --> Gold where the further "right" you go in the architecture, the more you implement transformation / curation of data. Compose Data Lake projects are built to automate the "Bronze" layer of your data lake environment.

Therefore there is no "modeling" concepts in Compose Data Lake like there is in Data Warehouse projects. Typical lake implementations in Compose DL projects are handled with Discovery of metadata (which also pre-generates mappings), generation of code and then execution (followed of course by deployment 🙂 ).

Hope that helps

Re: Qlik Compose Data Warehouse Modeling Best Practices

vtatarnikov — Fri, 20 Aug 2021 09:01:46 GMT

Thanks for the detailed answer