Large Data 2 – Power Pivot

Spread the love

Large Data 2 | Power Pivot

Microsoft has introduced the Power Pivot add-ins for large data solutions (inbuilt in office 365 , 2013 and later version). MS Excel has the power to analyze the large data set.  Rows across the 10.4 lacs.

  • Set large data set as range in Pivot table.
  • Use multiple dimension pivot table functionality to use multiple sources in Excel and analyze it frequently