18
PowerPivot for Excel 2010
Tonight I played with PowerPivot for Excel 2010. It took me about 1 hour to complete the install of the 64 bit installation. In the same hour I was able to import 1 million+ records into my workbook with two supporting tables, create relationships between the tables, and produce a useable and useful report which allows dynamic filtering and drag and drop field placement. I was very surprised how easy it was to pull this information into PowerPivot and create something that would be extremely useful for business analysts at work. The only downside is the requirement that the analyst has Excel 2010. PowerPivot can be downloaded for free from http://www.powerpivot.com/. There are also many useful videos to help you get going on that site. PowerPivot does not require any specific version of MS SQL Server. This software can pull data in from many datasources and they do not need to be any particular version. I’ll have to see if I can post a screencast or two on this.
1 Comment to “PowerPivot for Excel 2010”
Leave a comment
Blogroll
@benmarch
- "I like to picture Jesus in a tuxedo T-Shirt because it says I want to be formal, but I'm here to party." http://t.co/nzs9MCqc
- @glazeddoughnut very cool! Congrats!
- @glazeddoughnut whoa! Where to?
- @amandaesque @ignitempls yeah, like in 20 seconds!
- I don't really like e-readers but i also hate 10 lb technology books. I'm tempted to just cut these books in half and read 1/2 at a time.
Tag Cloud!
Knowledge Bomb
- April 2012 (1)
- January 2012 (2)
- December 2011 (1)
- May 2011 (1)
- February 2011 (2)
- September 2010 (1)
- August 2010 (2)
- June 2010 (1)
- May 2010 (1)
- April 2010 (10)
- March 2010 (1)








Holy geekness! It’s like you blog in a special language. Of Nerd.