Online analytical processing - Simple English Wikipedia, the free encyclopedia

This article has many issues. Please help fix them or discuss these issues on the article's talk page.

The introduction to this article does not have enough information for people who do not know much about the subject. Please help improve the article with a good introductory style. (February 2023)

An expert on the subject should have a look at this article or section.
Please help recruit one or improve this article yourself. See the talk page for details. (February 2023)

Online analytical processing (OLAP) is a way of doing data analysis. It is similar to data mining. Both are business tools that can help management take decisions. Unlike data mining though, OLAP is about verifying a hypothesis.

Data warehouses

Creating a data warehouse

Concepts	Database Dimension Dimensional modeling Fact OLAP Star schema Snowflake schema Reverse star schema Aggregate Single version of the truth
Variants	Column-oriented DBMS Data hub Data mesh Ensemble modeling patterns Anchor modeling Data vault modeling Focal point modeling HOLAP MOLAP ROLAP Operational data store
Elements	Data dictionary/Metadata Data mart Sixth normal form Surrogate key
Fact	Fact table Early-arriving fact Measure
Dimension	Dimension table Degenerate Slowly changing
Filling	Extract, transform, load (ETL) Extract, load, transform (ELT) Extract Transform Load

Using a data warehouse

Concepts	Business intelligence Dashboard Data mining Decision support system (DSS) OLAP cube Data warehouse automation
Languages	Data Mining Extensions (DMX) MultiDimensional eXpressions (MDX) XML for Analysis (XMLA)
Tools	Business intelligence software Reporting software Spreadsheet

People	Bill Inmon Information factory Ralph Kimball Enterprise bus Dan Linstedt
Products	Comparison of OLAP servers !--<*Data warehousing products and their producers-->

This short article about technology can be made longer. You can help Wikipedia by adding to it.