DotScan Data Warehouse (DW)

DW are central repositories of integrated data from one or more disparate data sources.

Extract, transform, load (ETL) and extract, load, transform (ELT) are the two main approaches used to build a data warehouse system.

What are the benefits of using DW?

• Informed decision making

• Consolidated data from many sources

• Historical data analysis

• Data quality, consistency, and accuracy

Separation of analytics processing from transactional databases, which improves performance of both systems

Data mining is the process of finding anomalies, patterns and correlations within large data sets to predict outcomes involving methods at intersection of machine learning, statistics and database system. Data mining has improved business decision marking through insightful data analyses.