Analysis & Modeling

Power Pivot gives you the ability to easily model data, relationships, measures, hierarchies, KPIs and instant analysis in in- memory technology .

Build your data model and start analyzing it

Do you want to create your own data model, the structure of which will be tailored to your needs? Power Pivot gives you this opportunity. You can download data from various sources, refresh it whenever you need it. You can format and filter information, create calculation fields, specify KPIs, define your own hierarchies and write your own calculations using DAX. Managing the model and creating relationships becomes easy, because everything is done by dragging and dropping on the Diagram View chart.

Power Pivot models are processed in RAM, allowing users to analyze hundreds of millions of rows of data with instant precision and result.