Business Intelligence and enterprise data mining management
A data warehouse is a kind of database designed to enable business intelligence solutions. Data warehouses are used to understand and enhance a performance. The warehouse is designed to query and analyze instead of merely conducting transaction processing. Historical data may be derived from transaction data but can include data from other locations. Data warehouse separates analysis workload from transaction workload, giving the organization the ability to maintain historical records and analyze the data to gain better understanding of the business and improve its practices. The environment in a data warehouse includes extraction, transportation, transformation and loading – referred as the ETL solution, ...