|
A data warehouse is a repository where data is electronically stored for archival, analysis and security purposes.
The data can be on various types of topics including organization's sales, salaries, operational data, summaries of data
including reports, copies of data, human resource data, inventory data, external data to provide simulations and analysis, etc.
The ETL Process
Databases get merged into data warehouses when companies consolidate large amounts of data. Large corporations build data warehouses
to view critical internal data and also when companies acquire other firms.
This merging into a data warehouse is performed by a process called ETL (extract, transform, load).
ETL is a process that involves the following tasks:
• Extracting data from source systems
• Transforming the data, which may involve cleaning, filtering, validating, and applying business rules
• Loading the data into a data warehouse or any other database or application that houses data
Business Intelligence
Besides being a store house for large amount of data, data warehouses must possess systems in place that make it easy to access the data and use it in day to day operations.
Business Intelligence (BI) software provides historical, current, and predictive views of business operations. Common functions of business intelligence technologies are reporting,
online analytical processing, analytics, data mining, business performance management, benchmarking, text mining, and predictive analytics.
RTTS Strategy
|
