Book a call

Daniel & Friends / Glossary / Data warehouse and data lake

Research and data

Data warehouse and data lake

A data warehouse stores cleaned, structured data for reporting and analysis. A data lake holds raw data in its original form, including text, logs or images, and applies structure only when processed. Today the two roles are often combined on one platform.

Daniel Votruba ·


In practice

For marketing and sales the point is to bring CRM, ad and web data together in one place. Start with a small warehouse of three to five sources and expand as needed.

Related terms

  • Big data: Big data refers to datasets so large, fast-growing or varied that ordinary tools, such as a spreadsheet or a single relational database, cannot process them.
  • BI and dashboard: BI (business intelligence) is a set of tools and practices that turn company data into reports and decision support.
  • CDP (customer data platform): A CDP is software that collects customer data from the website, app, CRM, e-shop and other sources, merges it into a single profile per person and makes it available to other tools for segmentation and personalization.
  • Data governance: Data governance is a set of rules, roles and processes that define who may handle data, how it is defined, where it is stored and how its quality and security are controlled.

More terms in the group Research and data

Desk research · DPA (data processing agreement) · Data clean room · ePrivacy (Directive on privacy and electronic communications) · Correlation and causation · Ethnographic research · Consent to data processing · Eye tracking · Conjoint analysis · First-party data · Confidence interval · Focus group · GDPR (General Data Protection Regulation) · CAWI, CATI and CAPI · In-depth interview (IDI) · KPI (key performance indicator) · Legal basis for processing · Anonymization and pseudonymization · Marketing research · Zero-party data · MaxDiff · Statistical significance · Multivariate test (MVT) · Sample and representativeness

Full glossary (590 terms)

Terms in practice

Need help putting them to work?

Terms are one thing, putting them to work is another. We go through which of them pay off for you and say so plainly. You get a first opinion for free and we reply within 24 hours.

Book a call

Enjoyed the article? Share it with friends.