Getting started with PowerPivot

First of all welcome to my blog. I blog about all Ms Bi products but after the release of PowerPivot, then called project “gemini” my focus has changed to mainly PowerPivot and sometimes

This page will help you to get started quickly with PowerPivot by providing links to my own blog post and other interesting links:

A great document that helps you getting started to PowerPivot is: Microsoft SQL Server PowerPivot Planning and Deployment

Interesting blog posts that can help you answer your questions regarding PowerPivot:

• My thoughts on why PowerPivot and where to place it
• 10 things you should know when you use PowerPivot
• Combine two files (or fact tables) in PowerPivot using relationships, PowerPivot relationships explained
• How to use sparklines and PowerPivot data
• Can i do datamining with PowerPivot data?
• So i requested a PowerPivot workbook from SharePoint, what happens?
• Using a SharePoint published PowerPivot app in a datasource
• MSDN blog post: DAX (Data Analysis Expressions) Measures in PowerPivot
• Use a refreshable access database as source for PowerPivot
• Make your PowerPivot sheet look great in SharePoint 2010
• Add a new Pivottable or Pivotchart and reuse the slicers of an existing PowerPivot workbook
• Configure SharePoint 2010 to work with large PowerPivot files
• Using PowerPivot to combine cube (SSAS) data with manual data, the movie

I did a lot with Time intelligent functions:

• Screencast: Introduction to time intelligent functions in PowerPivot
• Solving a business problem with Powerpivot CTP3 using DAX Timefunctions
• Time intelligent PowerPivot functions and fiscal year
• PowerPivot time intelligent functions revisited: why use ALL() and how to work around it
• How to add a related time table with Excel for time intel. functions
• MSDN blog post: Time Intelligence Functions in DAX

If you might have more questions you can check out the Great PowerPivot FAQ, or you can ask all your question here or send me and email.

Other PowerPivot blogs that are very interesting:

• http://powerpivotpro.com/
• http://powerpivottwins.com/
• http://www.powerpivot-info.com/
  • great post: the single box installation guide at http://powerpivot-info.com/post/66-step-by-step-guide-on-installing-powerpivot-for-sharepoint

Thanks for visiting and i hope you learned something here, please don’t hesitate to contact me for more information.