Microsoft Business Intelligence Solution Overview Nick Ward Solution

Microsoft Business Intelligence Solution Overview Nick Ward Solution Specialist Microsoft Australia Pty. Ltd. [email protected]

Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions Complete and integrated BI offering Widespread delivery of intelligence through Microsoft Office Enterprise grade and affordable

Microsoft Business Intelligence Capabilities Corporate Performance Management Reports and Analysis Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions Business Intelligence Platform

Microsoft Business Intelligence Corporate Performance Management Analytics:and Planning: Planning: Scorecarding: Scorecarding, Analytics ProClarity 2007 (Biz#) BSM 2005 PerformancePoint Portal and Collaboration: SharePoint 2007 Reports And Analytics Business Intelligence Platform End-user analysis: Excel 2007 Integration: SQL 2005 IS Analysis: SQL 2005 AS Reporting: SQL 2005 RS Data Warehouse: SQL 2005 RDBMS Familiar, integrated, complete platform

Our Integrated BI Offering DELIVERY SharePoint Server Excel Analytic Scorecards Reports DashboardsWorkbooks Views Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS PerformancePoint Server Excel BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS SQL Server Integration Services

Why Microsoft? A people-ready software platform:

BI Development Studio Leverage skills across entire BI application Team development, source control, versioning Development cycle lifetime support Develop, Test, Deploy, Modify, Test

Project REAL Best practices case study Instances of store out of stock Inappropriate stock levels Difficult to perform analysis of large data volumes Overburdened operational systems End to end business intelligence with: SQL Server, Reporting Services, Analysis Services, Integration Services and Data Mining 1.6 TB Raw Data, 64-bit, 20-way server 50% reduction in development time over Oracle SQL Server Integration Services shows up to 400% performance improvement Deliver more meaningful, up-to-date info

BI Optimization Model Data silos, custom and IT dependent reporting, Limited automation of data management Disconnected scorecards and IT dependant reporting and analysis on subjectoriented data Automation of data loading IT is a cost center IT is a more efficient cost center Infrastructure for enterprise-wide centralized scorecards and self-service reporting Centralized data management IT is a business enabler Real-time, closed loop analytics. BI embedded in standard business processes with predictive analytics IT is a strategic asset

2003-2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.