This is a new feature introduced in Excel 2013. It is the advanced data modeling feature in Excel 2013. In it we can rename the tables as well as the columns. We can make the relationships in the Diagram View by just dragging and dropping the fields of another table to it. We can filter the unnecessary data just to import only the necessary data.
Let's have a look at the following steps.
Go to Excel 2013.
Now select the blank workbook.
Now click on the Data menu and under it just select the From Other Sources option.
Now select from SQL Server Option from it.
Now a data Connection wizard will appear like this:
In it just select the database from the dropdown list as shown below:
Now select the Enable selection of multiple tables check box and select the tables you want to include in the power pivot.
Now click on the Finish button in the next dialog box appearing like this:
Now an import data dialog box will appear; in it just select the PivotTable Report option and click on the Existing worksheet option and click on the ok button.
A pivot table will appear like this:
Now to add the Power Pivot Add-Ins in Excel 2013 first click on the File menu option and under it click on the Options menu option.
Now select the Add-Ins option and under it select the Microsoft Office Power Pivot for Excel 2013 option.
Now select the COM Add-ins under manage DropDown List and click on the go button like this:
A COM Add-Ins Dialog box will appear like:
In this just select the Microsoft Office PowerPivot for Excel 2013 checkbox and click on the ok button like this:
Now we will see that the PowerPivot menu option appears like this:
In it just click the to manage option to manage the data model.
A PowerPivot window appears like this and in this two tables appear like this:
Under it we can change the column name like this:
In it we can view the diagram view by clicking on the Diagram View option like this:
We can do such tasks and just try to do other things on your own.