SQL SERVER – Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples

Learning any technology is easy when we have good documentation and sample database to play along with. When I have to learn any new technology, my first action is to install the trial software and look for sample database next. Once I get sample database, I try to find a video tutorial about the technology and continue to learn onwards.

Recently Microsoft has released the samples for PowerPivot in Excel. This is excellent as this gives opportunity to developer to play with the sample and learn all the features without worrying about building a sample which can work with all the features. PowerPivot empowers users of all levels to access and mashup data from virtually any source. Users can create their own compelling reports and analytical applications, easily share insights, and collaborate with colleagues through Microsoft Excel and SharePoint.

If you open a sample for PowerPivot for Excel 2010 in PowerPivot in Excel 2013, you will get a notification stating you must upgrade the data model in the workbook. You cannot open a sample for PowerPivot in Excel 2013 data model in PowerPivot for Excel 2010. In sample database there are two different files 1) PowerPivotExamplesExcel2010.zip and 2) PowerPivotExamplesExcel2013.zip

Each sample file contains three Business Intelligence samples:

  • PowerPivot Healthcare Audit.xlsx
  • PowerPivot Tutorial Sample.xlsx
  • LCA BI – Financial Report Usage.xlsx

Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples

Reference: Pinal Dave (http://blog.sqlauthority.com)

One thought on “SQL SERVER – Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples

  1. Hi sir,

    plz help me and urgent

    Attach database failed for Server ‘NAVEEN-VAIO’. (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476


    The database ‘foconet5’ cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
    Could not open new database ‘foconet5’. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476


    Plz help me how to rectify this error, is it possible to convert version 661(sql server 2008 R2) to Version 655(Sql server 2008) OR i need to install sql server 2008 R2 SP1…..
    is there any script for conversion?

    And Tell me the diference b/w sql server 2008 sp1 and sp2

    plz send me u r reply to this mail : pravnkumar.net@gmail.com


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s