So, what is Data Warehousing?
- Data warehouse (DW) is like a relational database that is designed for analytical needs rather than for transactional needs. It usually contains historical data that is derived from transactional processing systems.
- A DW environment includes single or multiple data sources, ETL solutions, Reporting and Analytical solutions, data mining capabilities and a many other applications that are used to manage and streamline the data flow processes for business users
- DW is a sequence of processes and tools that help organizations better understand their business and help them make informed decisions about their products and services.
Why do we need a Data Warehousing?
With markets becoming move competitive, business have to answer questions like..
- How will my new product impact revenues?
- What are the results of the latest promotional campaign?
- Who are the potential new customers?
- What is the spend pattern for customers below the age of 25?
- What is the projected sales for this quarter?
- Which discount sale was more popular?
No comments:
Post a Comment