Features of Data Warehouse

• They are used for storing historical data.

• Low Latency / Response time is fast.

• Data consistency and quality of data.

• Used with Business Intelligence, Data Analysis & Data Science.

By doing all the above, it answers some of the questions the business/needs.

• Sales of particular items this month compared to last month?

• Top 3 best-selling products of the quarter?

• How is the internet traffic before the pandemic / during the pandemic?

It's read-only for end-users and upper management.

Who are the end users?

• Data Analysts

• Data Scientists.

Data Size

A query can range from a few thousand rows to billion rows.