Share via


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

  • Anonymous
    December 03, 2015
    The comment has been removed