SharePoint and Office 2010-Part II-An Inside Look At PivotTables and SharePoint BI Integration

In this ALL DEMO three (3) part series we will take a look at Office 2010 and SharePoint 2010.  Specifically, we will look at integration and how these great new products are made to work together.  You will see many of the newest features in action.

Silverlight Video (9:20) Source…

You can find the downloadable files at the following URLs on Edge:

Right-Click, Save As below links…

Right-Click links; “Save Target As”

Click Video to Play!

Double-Click Video to view Full Screen

To Download Right-Click above links and select “Save Target As”

In part II we look at SharePoint Business Intelligence (BI) Integration and Excel PivotTables

  • Business Intelligence
    • Real-time Charting
    • Graphical Drill Down into data
    • Decomposition Tree
    • Data Connections – predefined
  • PivotTables – Look at real BI data in Excel PivotTable
    • Creating PivotTable
    • Insert Slicers  – real-time filtering (slicing and dicing) of data
    • Saving locally or to SharePoint
    • PivotTable Row Labels
    • PivotTable Report filters
    • PivotTable YQMD field (Year Quarter Month Day)
    • PivotTable Insert SparkLines – Inline graphical depiction of data great for looking at inline trend analysis
  • PowerPivot – Connect to external datasource and merge with Excel … work pivots with millions of rows of data

Links to the Entire SharePoint and Office 2010 Series:

If you like this post, please visit my blog to see other articles that may be of interest.  Many posts on Windows 7, Windows Server 2008 R2, Virtualization, SharePoint and Security. Many more post on these great topics as well as System Center Operations Manager, System Center Configuration Manager and many other technology topics.  You will often find non-technical posts such as Microsoft Changes Our World Through Innovation there as well. If you subscribe while you are there, I will keep you up to date Microsoft technology and on local Microsoft technology events.

Another Post with video that may be of interest… Planning for Office 2010 and SharePoint 2010

Also probably of interest Business Intelligence (BI) in SharePoint 2010

Comments (1)

  1. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    Latest version of Showbox App download for all android smart phones and tablets. – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    Showbox for PC articles:
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings. Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    Sign Up & Do registration for latest movies on Showbox application