Monthly Archives - October 2013

Learn Power of PowerPivot with SharePoint

Introduction to PowerPivot:

PowerPivot is a Self-Service BI Tool from Microsoft. It is basically a data mashup and data exploration tool allowing us to analyze millions of records from variety of different sources in a matter of few minutes or even seconds. It is based on a in-memory technology known as “xVelocity”, which operates in memory and does all the necessary calculations within memory thereby offering a very high-speed data analysis/exploration.

It comes in two flavors:

  • PowerPivot Add-In for Excel (Excel 2010 and above)
  • PowerPivot for SharePoint

Here are some  features of PowerPivot:

  • Similar to Excel, making it easier for business users, data analysts, and excel users etc.
  • Is available freely as an add-in for Excel.
  • Can be installed in just few minutes and you can get started with analysis.
  • Supports a wide variety of data sources.
  • PowerPivot formulas/expressions (DAX) are very similar to Excel formulas/expressions.
  • Due to it’s similarity to Excel, it’s very easy to adopt, and can be quickly adopted.

I am sharing very useful links, how you can create and use PowerPivot with SharePoint.

PowerPivot Part 1 – Loading Data
http://edge.technet.com/Media/PowerPivot-part-1-Loading-Data/

PowerPivot Part 2 – Preparing data
http://edge.technet.com/Media/PowerPivot-part-2-Preparing-data/

PowerPivot Part 3 – Analysis
http://edge.technet.com/Media/PowerPivot-part-3-Analysis/

PowerPivot Part 4 – Sharing in SharePoint 2010
http://edge.technet.com/Media/PowerPivot-part-4-Sharing-in-SharePoint-2010/

PowerPivot Part 5 – Management
http://edge.technet.com/Media/PowerPivot-part-5-Management/

Introduction to Excel PowerPivot:

http://www.youtube.com/watch?v=URy_uQYS49s

Business Intelligence:

http://www.microsoft.com/en-us/bi/powerpivot.aspx

Important:  If you are using the 32-bit version of Excel 2010, you must use the 32-bit version of PowerPivot. If you are using the 64-bit version of Excel 2010, you must use the 64-bit version of PowerPivot. The versions are not interchangeable.

PowerPivot: Install the PowerPivot Add-In for Excel

http://social.technet.microsoft.com/wiki/contents/articles/714.powerpivot-install-the-powerpivot-add-in-for-excel.aspx

In my coming article i will give you a demo, how to create PowerPivot in Excel 2013 and how to upload it to SharePoint 2013.

If you like this post please click LIKE and visit my sponsors thanks !!!

Read more...