199 ) Why do we need Data warehouse, when OLTP application data already there ?
-----------------------------------------------
What is Datawarehouse
A data warehouse is a centralized system
that stores structured data from various sources
for reporting and analysis
Data warehouses can:
Consolidate data: Store data from multiple sources into a single source of truth
Store historical data: Store and analyze long-term historical data
Analyze data about a particular subject or functional area:
----------------------------------
Data warehouses are important for a number of reasons, including:
- Data warehouses consolidate large amounts of data from multiple sources into a single, central database. This makes it easier to analyze the data and gain valuable insights.
- Data warehouses help organizations make faster, more informed decisions by providing easy access to high-quality data.
- Data warehouses can store months or years of information, which can be useful for trend analysis and forecasting.
- Data warehouses store data in a single location, which makes it easier to control access and keep data secure.
- Data warehouses can help solve big data challenges by making large amounts of information more usable.
- Data warehouses are usually optimized for read access, which can result in faster report generation.
Data warehouses are a critical component of business intelligence systems and data pipelines
No comments:
Post a Comment