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