BAS208. MOSS 2007 and Business Intelligence. Jerry Kaczmarowski, Joe Berg, Joe Davey Slalom Consulting. Agenda. Introductions Overview of SharePoint BI Capabilities Case Study 1 Case Study 2 Closing Comments Q&A. About Slalom. THE COMPANY Founded 2001 400+ Consultants, locally based
Program and Project Management
Customer Relationship Management
Business Process Improvement
Architecture and Development
Technology Quality and Performance
Security and Privacy
Web Site Development
Enterprise Resource Planning
Compliance and External Reporting
Financial Processes and SystemsSlalom Overview
* OLAP = OnLine Analytical Processing
Source: The OLAP Report, “Market Share Analysis”, Nigel Pendse, April, 10, 2007.
Solutions Lead, Portals
Total Project Health driven on 3 Core Indicators
Budget – SP List or Excel Spreadsheet
Schedule – SP List
Scope – SP List
Set of indicators designed to monitor in process performance
Setting an Indicator
Budget Variance %
Completion Status and Date
Change Request in Queue
Solutions Director, Business Intelligence
Data Warehouse built using Microsoft SQL Server 2005 and SSIS for Data Acquisition (ETL)
Business Intelligence Layer Incorporates Microsoft Analysis Services, Reporting Services, and Performance Point Server
End-user Experience is SharePoint Portal Server serving Scorecards, Dashboards, and Reports
Comments and Directions Section for high level overview
Links to Area Home Pages
Additional Resources Links for things like the Data Dictionary, etc
Links to Functional Areas
“Other Reports” tab links to additional content supporting the area.
Links to Other Report Content
Links to Supporting Documents
Site-wide Supporting Documents
The filter section drives data on scorecards and reports.
Linked Graphs can be filtered as well
Reports can be enabled to drill to detail as well.
Jerry Kaczmarowski (email@example.com)
Joe Berg (firstname.lastname@example.org)
Joe Davey (email@example.com)
For a chance to win an 8GB ZUNE!
Submit evaluations on MySPC
© 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.