Data Warehousing (DW) is a process of collecting and managing data from varied sources to provide meaningful business insights. A Data warehouse is typically used to connect and analyze business data from heterogeneous sources. For data analysis and reporting, the data warehouse is the core of the BI system.
It is a blend of technologies and components which aids the strategic use of data. Furthermore, it is a process of transforming data into information and making it available to users in a timely manner to make a difference.