4 ms·
It depends what you are trying to do exactly, but the excel add-in called powerpivot could be useful if you are trying to aggregate data and do adhoc analysis.
by rjempson 14y ago
It depends what you are trying to do exactly, but the excel add-in called powerpivot could be useful if you are trying to aggregate data and do adhoc analysis.
It is free :
http://www.microsoft.com/en-us/bi/powerpivot.aspx http://www.microsoft.com/en-us/bi/powerpivot.aspx
I have analysed lots of BI tools, which could be useful in your scenario, but most require a bit of technical / database knowledge to iron out wrinkles.
- ScottWhigham 14y ago+1 for PowerPivot. It kicks butt with large data sets, leverages your existing Excel skills, and extends those skills with DAX.