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.
Step 1
Go to Excel 2013.
Step 2
Now select the blank workbook.
Step 3
Now click on the Data menu and under it just select the From Other Sources option.
Step 4
Now select from SQL Server Option from it.
Step 5
Now a data Connection wizard will appear like this:
Step 6
In it just select the database from the dropdown list as shown below:
Step 7
Now select the Enable selection of multiple tables check box and select the tables you want to include in the power pivot.
Step 8
Now click on the Finish button in the next dialog box appearing like this:
Step 9
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.
Step 10
A pivot table will appear like this:
Step 11
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.
Step 12
Now select the Add-Ins option and under it select the Microsoft Office Power Pivot for Excel 2013 option.
Step 13
Now select the COM Add-ins under manage DropDown List and click on the go button like this:
Step 14
A COM Add-Ins Dialog box will appear like:
Step 15
In this just select the Microsoft Office PowerPivot for Excel 2013 checkbox and click on the ok button like this:
Step 16
Now we will see that the PowerPivot menu option appears like this:
Step 17
In it just click the to manage option to manage the data model.
Step 18
A PowerPivot window appears like this and in this two tables appear like this:
Step 19
Under it we can change the column name like this:
Step 20
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.