Qlik Compose is a tool for data warehouse automation that automates and manages the entire data warehouse lifecycle. With Qlik Compose, data engineers can create new data models, add new sources, and provision new data marts. The tool integrates with the Qlik Data Integration to extract and load the data in the data warehouse and with Qlik Catalog to catalog and govern the data models it creates and manages.
With Qlik Compose, there are three places where data is managed within the data warehouse: a landing area, warehouse, and data marts. With Qlik Compose, you perform the following steps to create and model your data warehouse and data marts:
- You use Qlik Replicate to define data pipelines that extract data from sources and load the raw data into a landing area.
- You then model the data using Qlik Compose, creating a data vault style data model for your overall warehouse within the data warehouse.
- Finally, you define and create individual data marts to support different analytics apps for the business. The resulting data marts have star-schema data models.
The user experience for Qlik Compose is very much like a formal data modeling tool that adheres to data vault and star-schema methodologies. Data models for your warehouse must be a data vault, and those for your data marts must be star-schemas (facts and dimensions).
Qlik Compose lets you create all your data models graphically without writing code. If you need to customize fields or enrich the data with additional fields, you do so via a formula builder, which translates into SQL expressions. You can also add data quality rules for cleansing, validation, filters, etc.
Qlik Compose also automates the end-to-end process of data warehouse modeling, creation, and management.