Data warehousing

system used for reporting and data analysis, as a core component of business intelligence

SPSS Statistics is a statistical software suite developed by IBM for data management, advanced analytics, multivariate analysis, business intelligence, and criminal investigation. Long produced by SPSS Inc., it was acquired by IBM in 2009. Versions of the software released since 2015 have the brand name IBM SPSS Statistics.

statistical software

procedure for copying data from one or more sources, then transforming the data at the source system, and lastly copying into a destination system which represents the data differently from the source(s)

access pattern in data warehouse environments, used to retrieve client-facing data pertaining to a single department, so that each department isolates the use of its own data

Stata (, , alternatively , occasionally stylized as STATA) is a general-purpose statistical software package developed by StataCorp for data manipulation, visualization, statistics, and automated reporting. It is used by researchers in many fields, including biomedicine, economics, epidemiology, and sociology.

extension to a spreadsheet's two-dimensional array optimized for multidimensional analysis

data warehousing schema

process of identifying, collecting, and integrating critical data of an organization in a single place

type of software or components thereof

logical arrangement of computing tables in a multidimensional database

database used for operational reporting and incoming data source for the Enterprise Data Warehouse

developing new insights and understanding of business performance based on data and statistical methods

American computer scientist and co-founder of the data warehouse

data dimension which contains relatively static data which can change slowly, but unpredictably, rather than according to a regular schedule

database modelling method with long-term historical storage that enables tracking of values and load dates back to their sources for auditing

data warehousing principle, a table consisting of the measurements, metrics or facts of a business process

intermediate storage area used in data processing during the ETL process

American computer scientist and co-founder of the data warehouse

structure that categorizes facts and measures in a data warehouse

act or process of retrieving data out of (usually unstructured or poorly structured) data sources for further data processing or data storage (data migration)

set of techniques and concepts used in data warehouse design