Analyze

Model and analyze with Power Pivot for Excel

The bigger the data, the more powerful we are

Continue to create sophisticated data models with that data in Excel by creating relationships, custom measures, hierarchies, and KPI's. All with the increased performance of in-memory technology.

  • Build your model and start your analysis

    With Power Pivot, you create your own data model from various data sources, modeled and structured precisely to fit your needs. You can refresh from its original sources as often as you want. You can format and filter your data, create calculated fields, define key performance indicators (KPIs) to use in PivotTables and create user-defined hierarchies to use throughout a workbook. You can even author your own calculations by writing advanced formulas that use the Data Analysis Expressions (DAX) expression language. No need to be a SQL expert: manage the model and create relationships using drag and drop in the Diagram View.

  • Fast and big with data

    Power Pivot models run in-memory so that users can analyze 100’s of millions of rows of data with lightning fast performance.