Business-Intelligence

Übersicht

• Einführung in Business Intelligence-Features

Excel Services

• Excel Services Anleitungen auf Office Online
• MSDN (SDK): Creating Custom Solutions with Excel Services
• Setting up and Publishing to Excel Services Step By Step
• Veröffentlichen in Excel Services auf dem SharePoint-Server
• MOSS 2007 B2TR: Fun! with Excel services, dashboards and traffic lights
• Webcast: SharePoint Server 2007: Building Custom Solutions with Excel Services
• Webcast: Business Intelligence mit Excel 2007 und den Excel Services von Office SharePoint Server 2007
• CommunityCast: Zugriff auf Geschäftsdaten mit Excel Services, BI und Business Data Catalog
• MSDN: Using Excel Web Services in a SharePoint Web Part
• MSDN: Deploying and Optimizing a SharePoint Web Part That Calls Excel Web Services
• MSDN: SharePoint Server 2007 Sample: Web Part That Calls Excel Web Services
• MSDN: Creating Managed-Code UDFs for Excel Services
• MSDN: Retrieving an Entire Workbook or a Snapshot of a Workbook in Excel Services
• Using Analysis Services data in Excel Services Part 1 – Preparing the AD for Kerberos
• Using Analysis Services data in Excel Services Part 2 – Preparing the MOSS server
• Using Analysis Services data in Excel Services Part 3 – Create and test an Excel sheet
• Using Analysis Services data in Excel Services Part 4 – Overview and updates
• Dynamically create static Excel files for Excel Service
• Excel Add-in für Synchronisation mit Sharepoint Listen (MOSS 2007)
• Creating Custom Solutions with Excel Services
• Ten Tips for Using SharePoint Server 2007 with Excel Services
• Creating Business Applications by Using Excel Services and Office Open XML Formats
• Consuming SharePoint Lists in Excel Services
• Excel Services Compatibility Checker Download Page
• Building a Report Based on Cube Functions for Excel Web Access
• Building an OLAP PivotTable Report with Excel Services
• Building a Relational PivotTable Report with Excel Services
• Building a Report with a Chart for Excel Web Access Based on Cube Functions

KPI

• Artikel: (KPI) How an organization defines and measures progress toward its goals
• Erstellen und Veröffentlichen von Key Performance Indicators (KPIs)
• KPI's in Microsoft Office SharePoint Server (MOSS) 2007

BI-Webparts

• Webcast: SharePoint Server 2007: Building Data-Rich BI Site Solutions
• CommunityCast: Zugriff auf Geschäftsdaten mit Excel Services, BI und Business Data Catalog 
• MS IT Showcase: A robust reporting portal built on Microsoft Office SharePoint Server 2007

Reporting Services

• Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
• Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007
• MOSS2007 – Reporting Services Add-in Part 1
• MOSS2007 – Reporting Services Add-in Part 2
• MOSS2007 – Reporting Services Add-in Part 3
• MOSS2007 – Reporting Services Add-in Part 4
• MOSS2007 – Reporting Services Add in and Configuration
• MOSS2007 – Reporting Services General UI Configuration
• SharePoint and Reporting Services - Introduction 
• SharePoint and Reporting Services - Installation and Setup 
• SharePoint and Reporting Services - Setup your database 
• SharePoint and Reporting Services - Authoring a simple report 
• SharePoint and Reporting Services - Enabling end users - the report model

Business Data Catalog

• SharePoint-Team: Business Data Catalog Overview
• MSDN (SDK): Business Data Catalog
• Using The Business Data Catalog Part 1
• Using The Business Data Catalog Part 2 -  Connect to an Oracle Database
• Nick Swan: Business Data Catalog for MOSS 2007 - Introduction
• Nick Swan: Business Data Catalog for MOSS 2007 - How it Works
• Using Single Signon with Database Credentials
• Webservices, Business Data Catalog and InfoPath 2007
• Installation einer Business Data Catalog Beispielanwendung
• Metadata Manager for the Microsoft Office SharePoint Server Business Data Catalog
• CommunityCast: Zugriff auf Geschäftsdaten mit Excel Services, BI und Business Data Catalog
• Video: SharePoint Server 2007 BDC: Integrating Line of Business Data and Applications into Enterprise Portals
• Video: SharePoint Server 2007 BDC: Extending BDC with Custom Components
• Getting Started with the Business Data Catalog in Microsoft Office SharePoint Server 2007 Virtual Lab
• SharePoint 2007: BDC - The Business Data Catalog
  • Simple "Hello World" example
  • Extending the "Hello World" example
  • Extending the "Hello World" example even further - adding specific finders
  • Introducing custom actions on your entities
  • Introducing associations between multiple entities
  • Lists with Business data type columns
  • Search
  • SharePoint 2007: BDC - User Profiles
  • SharePoint 2007: BDC - Writing Custom Code against the runtime object model
• MSDN: Creating Business Data Catalog Entities in SharePoint Server 2007
• MSDN: Filtering One Business Data Catalog List from Another by Using Associations in SharePoint Server 2007
• MSDN: Refining Business Data Catalog Search with Scopes
• BDC-Datei für die Anbindung von CRM 3.0
• Business Data Catalog Definition Editor Tool (Bestandteil MOSS2007 SDK)
• SharePoint Series / Infopath BDC Creator 
• BDC Mapper Web Part  
• MOSS BDC Design Studio 
• SharePoint Business Data Catalog Column (Codeplex-Projekt)
• Few Issues with Microsoft Business Data Catalog Definition Editor
• Using Business Data Catalog Definition Editor 
• Importing BDC Data into SharePoint 
• Working with Business Data Column 
• SharePoint und MySQL

Downloads

• Download BDCMetaManager Developer (free) and Professional (€)
• SQL Server Reporting Services Add-in for SharePoint Technologies CTP

Weblogs

• Weblog: Excel Blog
• Weblog: Excel Development
• Weblog: Sherman On Excel and BI Technology