PM Centrix

1

PM Centrix Microsoft Business Intelligence Event
2
PM Centrix

• We are the IT Services company of Group.
• Right people, right data, right time
• Solutions that increase productivity, drive
  business performance and enable better decision
  making whilst reducing costs.
• Specialist in delivering Microsoft Technology
  (.NET) solutions

3
Solutions

• Leveraging existing technology to deliver
  Collaborative Solutions for
• Business Intelligence (BI)
• Business Process Management (BPM)
• Enterprise Project Management (EPM)
• Enterprise Content Management

4
(No Transcript)
5
PM Centrix approach to BI

• Business Technology
• Visualise, organise and manage data
• Complete and integrated BI solutions
• Deliver via Microsoft Office
• Affordable technology

6
Driving Business PerformanceIntegrated tools are
needed to move beyond traditional business
intelligence
Specialized BI
BI for Everyone
BI integrated into everyday easy-to- use
tools Centrally-managed data Consistent measures
across the enterprise Data for everyone Integrated
solutions align business performance and
decision making
Complexity of BI tools is costly to
maintain Tools require specialized
knowledge Multiple sets of performance
measures Disparate systems Data access requires
IT support
7
Introducing ProclaritySteve Morse Microsoft
8
Microsoft Business Intelligence
Business Scorecarding (Business Scorecard Manager
2005)
Scorecards, Analytics, Planning (PerformancePoint
Server 2007)
AdvancedAnalytics (ProClarity 6.2)
Performance Management Applications
Portal (Office SharePoint Server 2007)
End-user Analysis (Excel 2007)
Integration Integration Services
Analysis Analysis Services
Reporting Reporting Services
BI Platform
SQL Server 2005 RDBMS
8
8
8
9
Cube - an example
For Groceries, show me the Margin in February
Time
Products
January
Clothing
Appliances
February
Groceries
March
April
May
Margin
Units
Sales
Cost
Measures
10
Screen Shot - 1
11
Screen Shot - 2
12
PresentationMark Hayes BI Consultant
13
Agenda

• What is Proclarity?
• Demo
• The role of Proclarity in the MS BI Stack
• Customer Profile

14
An interface to Insight
ProClarity builds the best analytic products at
answering why. ProClarity is your Interface to
Insight.
15
An interface to Insight

• Unique tools for decision makers to explore large
  quantities of data in a way that provides rapid
  insight
• Simple data navigation, powerful calculation and
  advanced visualizations are the three core
  components that make ProClarity Analytics the
  best at answering the question why

Reports tell you what happened
ProClarity Analytics helps you understand why
16
Simple access to Information

• Decision makers require huge amounts of complex
  data to support decision making, and as a
  result, IT is on a continually revolving
  reporting treadmill
• IT can easily and securely provide data to
  decision makers enabling self-service data
  browsing
• People across the organization can easily use
  our clients, with intuitive navigation and tight
  integration with Microsoft Office

17
Simple ways to Analyze Information

• Dashboards, scorecards, portals and reports are
  great for delivering relevant information to a
  broad user base
• With ProClarity, you can easily go beyond
  monitoring the data to conducting ad-hoc analysis

18
Simple ways to Understand
Decision makers can easily follow data paths to
quickly understand the drivers of corporate
performance

• The patented ProClarity Decomposition Tree
  enables decision makers to quickly and easily
  conduct root-cause analysis identifying the
  drivers of a number.

19
Simple ways to Understand
Decision makers have data, but they may not have
tools to easily identify opportunities and threats
Advanced visualizations, such as the Performance
Map, help users rapidly identify trends,
patterns, and opportunities
20
Agenda

• Demo

21
Agenda

• The role of Proclarity in the Microsoft BI Stack

22
Proclarity Analytics
23
Microsoft and Proclarity BI Stack

• Reporting Services is Microsofts entry into the
  enterprise reporting market, where it is already
  consider a serious player
• Proclarity was a key partner of Microsoft until
  its acquisition. Proclarity is a market leading
  provider of analysis solutions

Share Point Server 2007
BSC 2005
Performance Point 2007

• SQL Server Database 2005 is the latest version
  Microsofts enterprise store
• Analysis Services is the number 1 OLAP data store
  in the market place
• Data Mining has significantly moved forward since
  its debut in SQL 2000

• Integration Services is next version of DTS, but
  it is better to consider is a whole new product

24
Agenda

• Customer Profile

25
Customer Solutions
26
Key Retail and CPG Customers

• Retail
• Barnes Noble
• Ahold
• Publix Supermarkets
• Urban Outfitters
• Al Tayer Group
• The Body Shop
• CompUSA
• Harrods
• The Home Depot
• Jiffy Lube
• Scottish Newcastle

• Consumer Packaged Goods
• Chiquita
• Kerry Group
• Kimberly Clark
• LOréal
• Nabisco
• PepsiCo
• Pennzoil-Quaker State
• Procter Gamble
• Reckitt Benckiser
• Reddyice
• WestFarm Foods

27
Key Heathcare and Pharmaceutical Customers

• Pharmaceuticals
• AstraZeneca
• GlaxoSmithKline
• Merck
• Pfizer
• Roche Diagnostics

• Healthcare
• Arkansas Childrens Hospital
• Vanderbilt University Medical Center
• Cardinal Healthcare
• Clalit Health Services
• Department of Veterans Affairs
• Emerald Health
• HealthDirect
• LifeMasters
• Memorial Healthcare System

28
Key Financial Services Insurance Customers

• Insurance
• ACE Insurance
• AIG Insurance
• Allstate Insurance
• Apollo Underwriters
• Cunningham Lindsey TES
• Exchange FS Insurance
• Hiscox Underwriting
• Safeco
• Union Standard Insurance
• United Heritage
• Zurich Insurance

• Financial Services
• ABN AMRO Bank
• GE Capital Finance
• Julius Baer Investment Fund
• Legg Masson Investors
• Morgan Stanley
• Nationwide Building Society
• Prudential Securities
• Raymond James
• Royal SunAlliance
• Swiss Stock Exchange (SWX)

29
Key Public Sector Government Customers

• Public Sector
• Lake Michigan College
• King County EMS
• Napier University
• Purdue University
• University of Arkansas
• University of Texas
• Vanderbilt University
• Air Force Surgeon General
• Department of Energy
• Department of Treasury

• City of Boise
• Department of Veterans Affairs - VHA
• TRICARE
• Department of the Navy
• Dept of Health Human Svcs
• ID Dept of Health Welfare
• International Monetary Fund
• U.S. Department of Agriculture
• Utah Transit Authority
• Arkansas Childrens Hospital

30
QA
31
Customer Success Stories Case Studies
32
We estimate that we recovered our initial
ProClarity investment in the first six months of
its deployment. George Kousis MIS/Data
WarehouseBank of Cyprus
33
ProClarity not only exceeded the performance of
all other products, it was also the least
expensive solution we looked at. David
Radmilovich BI Project SponsorAramark Uniform
Services
34
We expect the ProClarity solution to provide an
ROI in our second year of about 6 million, and
that's a very conservative estimate. Cathy
Witt CIO CompUSA
35
Without ProClarity, we'd still be measuring the
business by hand. What we're doing in an hour
would have taken three weeks. Eric
Lofstrom Business Intelligence ManagerQuicken
Loans
36
Even on the store level, people are looking at
some of the reports and saying, 'Wow, so this is
how our business runs.' We're relearning our
business just based on the implementation. Mich
ael Smith Vice President of IT Rentcash Inc.
37
Anecdotal evidence from the field indicates that
ProClarity userswould now find it impossible to
perform their daily duties without the support of
this analytic tool. Gadi Gilon Chief
Information Officer Clalit Health Services
38
Irish Case Study Consumer Goods Manufacturer

• Proclarity is used as the primary analysis tool
  for Sales and Purchasing function. The technology
  is ever expanding into other functions of the
  enterprise.
• Supports a user base of 1200 user across
  continents
• Support both on-line and off line users via cub
  technology
• Currently in migration from SQL 2000 to SQL 2005.
  
• As part of the migration, new functionality will
  be added via the Reporting Services component of
  SQL 2005.

39
Irish Case Study Consumer Goods Retailer

• Proclarity is used as the primary high end
  analysis tool for Sales function.
• Daily store level data at a barcode level is
  stored within a central data warehouse which is
  build upon SQL 2005 technology.
• From the SQL 2005 DB, and Analysis Services 2005
  cube is built that acts as a data source for
  reporting services, excel and Proclarity.

40
Irish Case Study Government Body

• A system for analysis of track betting
• Proclarity is used for system analysts to compose
  ad-hoc queries of track spend.
• System is supported with Reporting Services
  reports
• System is presented to users via Sharepoint site
  which also incorporates BSM elements.

41

PM Centrix Microsoft Business Intelligence Event