If you're new to the data space and interested in learning how to build a modern data stack, check out our Analytics Setup Guidebook
Building a modern data stack usually require stitching multiple data components together. This page explains where Holistics fits in the overall value chain.
Components of a modern data stack
A modern data stack is built on the foundation of four main components:
- Extraction & Loading (EL): Extracting data from source systems and replicating it to a central repository, usually a data warehouse.
- Data Warehouse (DW): The central analytics database where all the data now gets stored.
- Transformation (T): Where the raw data is turned into clean data and eventually insights.
- Visualization (BI): Where transformed data is turned into charts and dashboards to enable business decision-making.
How Holistics fits in
Being a BI tool, Holistics handles (4) in the above diagram.
Holistics also provides certain capabilities of (3) (Transformation) in case you don't use a dedicated Transformation tool (like dbt or Dataform). Holistics also support strong integration with these tools.
In short, your data stack will contain:
- An ETL/EL tool: Optional, needed when you have data from multiple application sources and need to move into your data warehouse.
- A SQL database: This can be your existing production database (not recommended), or a common data-warehouse (Snowflake, BigQuery, Redshift, etc).
- A Transformation Tool: dbt, dataform etc.
- Holistics: the BI layer.