OLAP

What is OLAP?

OLAP (Online Analytical Processing) is the technological foundation of many business intelligence (BI) tools. It can rapidly answer multi-dimensional analytical (MDA) database queries and offers limitless report views, predictive analytics (such as “what-if” scenarios), and other complex analytical calculations.

What is the Difference Between Transactional and Analytical Processing?

An OLTP (Online Transactional Processing) database contains detailed and current data with a high volume of usually small data transactions. OLAP in turn usually involves complex and aggregated queries with a relatively low number of transactions. The Snowflake Data Warehouse uses online analytical processing as a foundational part of its snowflake database schema.

Sign up for the Weekly Demo to See Snowflake in Action