Transcript Delivering Business Insight with SQL Server 2005 - PM

Delivering Business Insight
with SQL Server 2005
Tim Cahill
Business Development Director
PM Centrix
Why Business Intelligence?
Poor Visibility and
Reaction to
Market Events
Inefficient Supply Chains
and Demand Chains
High Business and IT
Operation Costs
80% of IS Budget to
‘business as usual’
Poor Understanding of
Customer Needs
Today’s information
TECHNOLOGY
Poor Business Performance
Management by Spreadsheets
Data Privacy Concerns and
Information Overload
Compliance (BASEL,
Sarbanes Oxley)
Why Is It So Difficult To Achieve A
Higher Return Of Information Today…
Most companies today have a tangled web of IT and human systems.
This tangled web has a high degree of inefficiency, complexity, and risks.
High degree of
data cleansing and
re-entry labour-intensive
Source
Systems
Many points of data integration…
poor data integrity and reliability
Data Marts
Data
Warehouses
High IT
involvement…
longer time-tovalue
Text
Mining
ERP
CRM
Hand
coding
Multiple
solutions…
more costly,
and frustrates
users
LOB
ETL
Data Analysis
(OLAP, Data Mining)
Human input…
prone to error
Many disconnected systems…
incomplete data…
multiple versions of truth
Decision Ready
Business Intelligence
Integrate
Data acquisition
from source
systems and
integration
Data transformation
and synthesis
SQL Server Reporting
Services
Available in All Editions
Analyze
Report
Data enrichment,
with business
logic, hierarchical
views
Data discovery via
data mining
Data
presentation and
distribution
Data access for
everyone
Delivering the Complete
Business Intelligence Toolset
Key Performance Indicators
 Getting to What Matters
 Visual Indicators
Business Intelligence
Getting to What Matters
 Calculations that drive visual
indicators
Quickly “manage by exception”
Set and Monitor Goals
Monitor the trend, up or down
Business Intelligence and
Key Performance Indicators
Liam McCambridge
Senior Technical Architect
PM Centrix
Reporting Services
 Why Reporting Matters
 Enhanced Reporting Capabilities
 SQL Server 2005 BI Development Studio
Microsoft
Business Intelligence
Vision & Strategy
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
Reporting Services
Why Reporting Matters
 Real-time insight into business






trends
Better decision making across
entire organization
Build a report with multiple
data sources
Enable interactive access to
information
Enable an end user to build (or
modify) their own report
Provide reports in a format that
end users want
Integrate reporting into
applications easily
Reporting Services
SQL Server 2005 BI Development Studio
Integrated design time environment exposes:
 Report Designer
 Multiple data sources
 Objects (tables, matrix, charts)
 SQL Generator
 MDX Query Generator
 New Reporting Controls:




Interactive Sort
Floating Headers
Date Picker
Multi-value Select
Architecture
Browser
Builder
Office
Custom App
Web UI
Data Sources
(SQL, OLE DB, XML/A,
ODBC, Oracle, Custom)
Programmatic Interfaces
Report Server
Report Model
Output Formats
(HTML, Excel,
TIFF, Custom)
Security Services
(NT, Passport,
Custom)
Report Processing
Data Processing
Security
Rendering
Delivery
SQL Server Catalog
Delivery Channels
(E-mail, SharePoint,
Custom)
Report Builder
 Extending the Reach
of Reporting Services
 Ad Hoc Reporting for
the End-User
 1-Click Install
 With Report Builder:
 Report off a
Business Model
 Modify a Report
 Build a New Report
 Report on Relational
or OLAP data
Using Report Builder
Liam McCambridge
Senior Technical Architect
PM Centrix
PM Group






16
Project and construction management,
design and technical and consulting
services
Established 1973, 1,200 Employees
€1.8 b portfolio
€95 m turnover in 2004
ISO 9000 2000 Certified
Offices:
 Ireland (Dublin & Cork)
 UK
 USA
 Poland
 Russia
PM for Lansdowne rebuild
17
“MIS SYSTEM” Monthly Volumes
1,200 staff profiles
 9,000 Timesheet entries
 48,000 Staff Trackings
 800 Purchase Invoices
Objective : Calculate Group
Profitability Monthly

18
Purchasing
PM Group
Profitability
MIS
Costing
Attractions of SQL Server 2005

Features




Security & Redundancy






Password / Policies / Expiration
Certificates (Offices / Sites / Remote users)
Zero Data Loss
Automatic Re-Sync
Continued Data Availablity
BI Features

19
Increase in Server Speed
TSQL / Managed Language Support / .Net / Developer Toolset
Ability to use XML for briefcase data
KPIs & Reporting Services
Interview
Anne Sloane,
Stryker International
20
© 2005 Microsoft Corporation. All rights reserved.
This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.