A Data Warehouse is a repository for historical business data. A data warehouse is used to consolidate large amounts transaction and operational data into a form that can be queried for analysis. Typically the data in a data warehouse has been cleansed and normalized in a process known as ETL (extract, transform, and load). The data is them organized by specific dimensions and stored in a Data Cube. Dimensions include time (day, month, year), geographic locale (country, region, state, city), and product type. [More…]

Data Mining is part of the Business Intelligence process. Data Mining is centered on the extraction and analysis of useful information from large data sets. Data mining uses an extensive collection of techniques and algorithms, including statistics and artificial intelligence approaches, and also pattern recognition and machine learning. [More…]