Online analytical processing, models built for aggregating data and slicing it in different ways; Azure Analysis Services is one example.
Also called online analytical processing.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains OLAP in context, with comparison tables and the common traps.
Terms in this definition
- Azure Analysis Services
Azure service hosting tabular OLAP models for large numbers of Power BI and Excel users; semantic models in Power BI Premium are its modern counterpart.
Related terms
- Semantic model
Sometimes called an OLAP model, this Power BI and Fabric layer defines the measures, hierarchies, tables and relationships that reports and dashboards query; star schema design is the usual pattern.