My DataWarehouse Project

DataWarehouse

Many companies are investing huge amounts of money to create an enterprise data warehouse. A data warehouse is a centralized database that stores data from often autonomous information sources distributed in an enterprise. For instance, Toyota's data warehouse may collect information from its regional inventory and sales databases. Once the data warehouse is built, it is used to answer analytical or decision support queries. For instance, the Toyota data warehouse may be used to answer queries such as: "Which country and for what months were Alion and Yaris in high demand but short in supply?"

Business intelligence and data warehousing turn data into information, allowing organizations to deploy resources more effectively, increase operational efficiency, determine a campaign’s effectiveness, and identify new streams of revenue.

Building data warehouse is the best way to consolidate and organize all your data so it can be easily managed, accessed, and analyzed. Business intelligence (BI) is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions using BI applications include the activities of decision support systems, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining.