Glossary
What is a data warehouse?
Last updated
Definition
A data warehouse is a database designed for analysis rather than day-to-day transactions, storing cleaned data from many business systems in one place so people and tools can query it together.
What goes in
Data from the CRM, billing, product, ad platforms and operations lands in the warehouse through pipelines, then is cleaned and modeled into tables and views.
Why it matters for AI analytics
An AI analyst is only as good as the data it reads. A warehouse with well-named views gives it a governed source, while raw copies of source systems invite wrong answers.
How exelens connects
exelens connects to your warehouse with a read-only identity and reads only the views you import. See the guide to connecting or book a demo.
Frequently asked questions
- What are examples of data warehouses?
- Snowflake, Google BigQuery, Databricks SQL, Amazon Redshift, Azure Synapse and Microsoft Fabric. Many smaller teams use PostgreSQL the same way.
- Is a data lake the same thing?
- Not quite. A lake stores raw files in many formats. A warehouse stores structured, modeled tables. Many platforms now blend the two.
See Data warehouse in practice
A short walkthrough with the founder: connect read-only, ask a real question, pin the answer.