<aside> 🔵

Data Warehouse

</aside>

It is a centralized storage system that stores large amounts of structured data from different sources, making it easy to analyze.

Key Points:

• Stores cleaned, organized data.
• Optimized for fast querying and reporting.
• Helps with long-term analysis and decision-making.

Example: A store uses a data warehouse to analyze customer purchases and inventory trends to improve business strategies.

ELT is not suggested, because, in the real world, the data is too messy

Prepare this → How can you do ETL and ELT in an example

<aside> 🔵

Data Mart

</aside>

It is a smaller part of a data warehouse that focuses on data for a specific area, like sales or marketing.

Key Points:

• Focuses on one department or business area.
• Stores only relevant data for that area.