Power Pivots

AndyDevine1

Board Regular
Joined
Jun 1, 2006
Messages
172
Hi guys

Hopefully I'm not breaking the rules by posting this question here...

Are Excel PowerPivots any good? worth me getting to grips with? (I'm now starting to use alot of data and pivots)

And completely free?

Be good to get your views if you know about these...

Thanks

Andy
 

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390

Tianbas

Board Regular
Joined
Apr 29, 2014
Messages
101
Dont think about PowerPivot as an improved Pivot table in Excel. Its a complete different tool that uses Excel as Interface. With PowerPivot you can build a kind of cube with data from different sources, add calculations and create reports out of this. You can do this without much IT support within the business departments.

you should also have a look on this page to decide if its worth your time to test PowerPivot
What is PowerPivot? « PowerPivotPro

PowerPivot itself is free as long as you refresh the data yourself and use Excel as Report tool. If you want more automation, schedule the refresh of your PowerPivot files and show the results as Web reports you need a Sharepoint Enterprise Server that costs some money and a license for every user of the report. There are some other options beside Sahrepoint but all of them are not for free as well.
 

Forum statistics

Threads
1,077,649
Messages
5,335,473
Members
399,017
Latest member
npatel917

Some videos you may like

This Week's Hot Topics

Top