what is the difference between pivot and power pivot?
The basic difference between Power Pivot and Excel is that you can create a more sophisticated data model by working on it in the Power Pivot window. ... Import all data from a data source. Filter data and rename columns and tables while importing.