PowerPivot in Microsoft Excel 2010

Download this episode

Download Video


PowerPivot for Excel is an Excel 2010 add-in that allows users to pull data from multiple sources, mash them up, and then build reports using regular pivot tables. You can even share these reports with others in Microsoft SharePoint (via PowerPivot for SharePoint). In this demo, Julie Strauss, Program Manager for Microsoft SQL Server Analysis Services, shows just how easy it is to get a better view into your data.



Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image

      very neat indeed.

    • User profile image

      Julie is a pleasure to listen to, very good presentation. Wink

    • User profile image

      Nice spam.

    • User profile image

      Thanks for answering my questions. I hadn't even thought of the multiple ways data can be produced and consumed from SQL Server, other than the obvious way.


      When I asked about multiple PowerPivots, I was thinking about multiple cubes. Where a cube would have a fact table and zero or more dimensional tables associated with it. I've never enjoyed working with linked workbooks and now doesn't seem like a good time to give it another spin.


      I strongly feel that this product is going to develop it's own cult following. I'm impressed with it and all the excitement present in sites dedicated the product.


      This post should also have a PowerPivot tag.



    • User profile image
      David DeMar

      I am so glad I found this incredible resource! It really seems that PowerPivot is a huge untapped resource for doing high volume data mining. This is so important to me and the work I do.


      I will have to spend some more time going over your site and looking for more related articles. You can never have too much

      Microsoft Training, and this new release is really exciting. Thank you so much!

    • User profile image

      Thanks for that great Video which gives a brief overview of the ideas and concepts behind PowerPivot. We already work productive with the tools but got a better insight for way to go for through that video. Great stuff, retweeted!

    • User profile image

      Is the movie data in this video available for download? I'd like to use it in a customer demo.

    • User profile image

      on my machine the powerpivot failed on the rows beyond 10million rows, what machine config was used here? 32bit or 64 bit ? and how much RAM did this machine have ? really want this to work...

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.