technically logo

Learn

Company Breakdowns
What technical products actually do and why the companies that make them are valuable
Knowledge Bases
In-depth, networked guides to learning specific concepts
Posts Archive
All Technically posts on software concepts since the dawn of time
Terms Universe
The dictionary of software terms you've always wanted

Explore knowledge bases

AI, it's not that ComplicatedAnalyzing Software CompaniesBuilding Software ProductsWorking with Data Teams
Loading...

Meet Technically

Technically exists to help you get better at your job by becoming more technically literate.

Learn more →

Solutions for Teams

For GTM Teams
Sell more software to developers by becoming technically fluent.
For Finance Professionals
Helping both buy-side and sell-side firms ask better technical questions.
General Team Inquiries
Volume discounts on Technically knowledge bases.
Loading...
Pricing
Sign In
← Back to Universe

Data warehouse

analyticsadvanced

A data warehouse is a special type of database designed for analytics instead of transactions. 

There are two main types of databases: transactional and analytical. Transactional databases like PostgreSQL are built for adding, updating, and removing data, but analytical DBs are for complex queries and joins. When you're analyzing big swaths of data to understand patterns in product usage or look at revenue over time, you want to use a data warehouse.

Read the full post ↗

The Details: Data Warehouses

A deep dive into data warehouses, what they do, and how different ones stack up.

Read in the Knowledge Base →

Mentioned in

Databricks is apparently worth $100B. What do they even do?

What we should really be asking is “What does Databricks not do?”

Company Breakdownanalytics
Breakdown: the cloud infrastructure market

How developers decide which *type* of infrastructure to use, and which (usually giant) cloud provider to buy it from.

Category Breakdowndevops
Why do developers choose different types of databases?

An intro to how companies like Elastic, MongoDB, Snowflake, Confluent and AWS compete.

Category Breakdowndatabases
What does Alteryx do?

Alteryx is a group of tools that helps business teams get insights out of their data, without needing to write any code.

Company Breakdownanalytics

Related terms

A/B Testing and Experimentation

Analytics

Benchmark

Data lake

ETL

Kafka

Support
Sponsorships
Twitter
Linkedin
Privacy + ToS