Loading subject…
Business intelligence
The tools and practices an organisation uses to query its stored data and turn the results into decisions, covering decision support, trend analysis, forecasting and performance monitoring.
Data warehouse
A central store that collects historical data from an organisation's operational systems and holds it in a form designed for analysis rather than for running the business.
ETL (extract, transform, load)
The scheduled three-stage process that fills a data warehouse: data is extracted from each source system, transformed into the warehouse's agreed formats, and loaded in as new rows.