PowerPivot

The SQL Server 2012 Analysis Services release embraces tabular model development.  The tabular development approach, introduced with SQL Server 2008 R2 PowerPivot, is now available to the IT Professional, and extends beyond the features available in PowerPivot.  PowerPivot has been…

This demonstration uploads an Excel workbook to the SharePoint PowerPivot Gallery library, and then uses it to produce a Power View report. Peter Myers Mentor, SolidQ  

Demo of PowerPivot with PDW.

How to create modern BI solutions using Microsoft SharePoint 2013, PowerPivot and Power View in Excel 2013.

Part 1 of 2: SharePoint 2010 allows developers to work with both internal and external data using Business Connectivity Services (BCS), Excel Services, Access Services and custom WCF services. During the presentation we will discuss and demonstrate several common usage scenarios.

Part 2 of 2: SharePoint 2010 allows developers to work with both internal and external data using Business Connectivity Services (BCS), Excel Services, Access Services and custom WCF services. During the presentation we will discuss and demonstrate several common usage scenarios.

ISV Summer Campaign - Introduction into Unlocking your Data Summer's here and for the most of us this is the time we take that well-deserved rest and stand back a little fromthe daily grind. It's also a time for some reflection, a time to think about the things that we would like to do during the…

This demo shows a complete BI solution end-to-end that delivers information to decision makers using SQL Server 2008 R2 and Office 2010.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This presentation introduces the concept of self-service analysis and the business scenarios it addresses, and discussions how SQL Server 2008 R2 can be used to meet these requirements.  An architectural overview of SQL Server 2008 R2 self-service analysis components is also provided including…

This demo shows how a user can create an in-memory cube with SQL Server 2008 R2 PowerPivot and Excel 2010.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.