Tag - Business Intelligence

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 !!!