-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Data Modeling with Microsoft Excel
By :

Power Pivot is the main authoring tool for data models in Microsoft Excel.
Power Pivot allows you to load large volumes of data from various sources, perform more powerful calculations, and create insights easily from your datasets.
Power Pivot works as a downloadable add-in for the Excel 2010 and 2013 versions. Excel 2016 and more recent versions have the add-in already available in-app.
Power Pivot was inspired by Microsoft SQL Server Analysis Services (SSAS) to ultimately make self-service business intelligence possible for regular Excel users. This means a novice Excel user can still crunch key insights from datasets directly in Excel.
The key features of Power Pivot include the following:
Now that we have a good idea about Power Pivot, we will look at where we can find and install this tool in earlier and older versions of Microsoft Excel in the next section.
Change the font size
Change margin width
Change background colour