Florian @

Part 2 – Live Blogging von der SharePoint Connections 2010 zum Thema Business Intelligence.

Apropo am 27.5 gibt es ja genau zu diesem Thema bei Microsoft Wien ein Technet-Briefing – schon jetzt vormerken!

Legen wir los anders ausgedrückt let's get Insight ;-)

What's new:

• PerformancePoint Services
• Chart Web Parts
• Visio Services

Improved:

• Excel Services
• Status Indicators
• Business Connectivity Services

Performance Point Services:

• Teil der SharePoint Service Applicatoin
  
• Content Storage in SharePoint Listen
   
  
• Backup & Restore via SharePoint
• Versioning, Rating, Workflow, Tagging
• Scorecards – multiple actual values and variance
• KPI on Columns
• Dynamic hierarchies and navigation

Eigener Dashboard Designer:

• Aggregeate Data Sources and Content to create rich, dynamic and context-dive dashboards
• create content once and reuse across dashboard
• one-click deploy and publish
• common infrastructure with sharepoint

Filters:

• Reusable between dashboards
• compatible with sharepoint filters
• time intelligence filters for multiple data sources

Server Extensions:

• SDK users can author custom reports, filters and data sources using the SDK
• Users can create custom scorecard PreQuery, PostQuery and  PreRender

Was ganz wichtiges noch zum Abschluss:

Excel Services:

• Publishen von ganzen oder teilen von Excel Workbooks
• verbesserte Performance und durchgängige Administration
• First Class Browser Support
• verbesserte Programmierbarkeit
• Interaktive PivotTabellen, PowerPivot –> http://www.powerpivot.com/ 
• Visual Slicers

New API – REST

• einfacher URL Zugriff auf Excel Workbooks
• Einfügen von Excel Daten per Link in Blogs, Wikis or Client Tools
• Daten kommen dynamisch Excel Workbook
  • ../Ranges
  • ../Charts
  • ../Tables
  • ../PivotTables