Cognos Government Performance Management

lavishgradeΛογισμικό & κατασκευή λογ/κού

25 Νοε 2013 (πριν από 3 χρόνια και 8 μήνες)

118 εμφανίσεις

Cognos Government
Performance Management

Yiannis Lekos


SCICOM S.A.

Cognos CPM Senior Consultant

Business Intelligence in the Public Sector


June 2008

Business Intelligence in the Public Sector


June 2008

Cognos:

The World Leader in BI & PM Solutions


Acquired by IBM in Jan 2008


Global coverage


23,000+ customers in 135+ countries


80% of Fortune 1000; target Global 3500


Strong channel network: 3,000+ channel
partners


Cognos employees


a competitive advantage


3,300+ employees


940+ strong R&D team


2,000+ customer
-
facing field force


Direct sales 70%
-

Channel sales 30%

Business Intelligence in the Public Sector


June 2008

SCICOM & COGNOS


25 years of successful presence in the
Greek Information Technology Market as
a Cognos Partner


A Cognos Platinum Reseller Partner for
Greece & Cyprus (‘Top Resellers 2005,
2006
και 2007
’)


Strongly recognized in the CPM market


200+ clients / 4,000+ users


Business Intelligence in the Public Sector


June 2008

BI & Performance Management clients in
Greece & Cyprus
-

Greek Firms

MORGAN YZATIS

Business Intelligence in the Public Sector


June 2008

BI & Performance Management clients in
Greece & Cyprus
-

Multinational Firms

Business Intelligence in the Public Sector


June 2008

MAJOR THEMES IN GLOBAL
GOVERNMENT


Citizen
-
centric


Joined Up


Results
-
based

Business Intelligence in the Public Sector


June 2008

GLOBAL MOMENTUM FOR
RESULTS
-
BASED GOVERNMENT


Canada:
Management Accountability
Framework; Financial Administration
Act (FAA)


United States:
Government
Performance

and Results Act (GPRA)


France:

Loi Organique relative aux
Lois de Finances

(LOLF) =

"Organic
law relating to the Finance Laws"


U.K.
: Resource Accounts

Business Intelligence in the Public Sector


June 2008

ACCOUNTABILITY: SIMILARITIES IN
PRIVATE & PUBLIC SECTORS


Sarbanes
-
Oxley
(SOX)


302: Financial
Certification


404: Internal control
certification


409: Timely
disclosure


. . .: 66 sections of
compliance


Government
Accountability

Enforcing more accountable

government:


More timely information


Effective controls


Rigorous oversight of
performance


Compliance through
training and tools


High

ethical standards

Business Intelligence in the Public Sector


June 2008

CHALLENGES OF GOVERNMENT


Demonstration of

good governance


Intense public scrutiny


Demands for accountability


Continuous budget pressure


Must show continuous
improvement . . . with less
resources


Business Intelligence in the Public Sector


June 2008

LOTS OF DATA, LITTLE DECISION
-
READY INFORMATION


Reporting is cumbersome and static; typically
paper
-
based with many versions of the truth


Manually intensive analysis processes; ad
hoc analysis is rarely supported


Mainly manual processes for information
gathering and collation


Data are hidden away in
departments, databases,
applications, geographies;
impossible to coordinate


Data latency, accuracy,
completeness issues

Business Intelligence in the Public Sector


June 2008

SOLUTION REQUIREMENTS


Improve visibility into business
processes from aggregate to detail


Monitor, measure, and track
performance against strategic
objectives and benchmarks


Make performance information
broadly or narrowly accessible,
and securely via the Web


Simply satisfy mandatory
reporting requirements

Business Intelligence in the Public Sector


June 2008

ORGANIZATIONAL REQUIREMENTS


Provide foundation for data
-
driven
decision making


Provide users with tools and
information access to make better
decisions


Improve collaboration to monitor
and manage readiness


Technology must be easy to use for
multiple stakeholders


Fast time to benefit

Business Intelligence in the Public Sector


June 2008

GOVERNMENT PERFORMANCE
MANAGEMENT

Why?

How are We

Doing?

What Should

We be Doing?

Business Intelligence in the Public Sector


June 2008

THREE QUESTIONS THAT ADVANCE
PERFORMANCE IN GOVERNMENT

Students in
grade 3 in
School Board 2
are trailing
Federal goals

Analysis reveals

teacher
qualifications lag in
key areas compared
with other similar
districts

Implement
program to
upgrade skills of
teachers; recruit
more seasoned
teachers into
district

Percentage of
eligible families
served is below
target

Analysis reveals
low application
volumes in
Region 2

Re
-
allocate funds
toward targeted
outreach program
to advise of
eligibility

Student
Performance

Program
Performance

Business Intelligence in the Public Sector


June 2008

Single Platform for Decision Making

SINGLE DEFINITION OF THE TRUTH

Business Intelligence in the Public Sector


June 2008

DATA SILOS ARE EVERYWHERE; REPORTING IS
TYPICALLY BY SUBJECT AREA

OPERATIONAL

SYSTEMS

PERSONNEL

FINANCIAL

SYSTEMS

OPERATIONS

SUPPLY CHAIN

SUPPLIERS

Business Intelligence in the Public Sector


June 2008

SYNCHRONIZING DATA PROVIDES
CONSISTENT ENTERPRISE
-
WIDE VIEW

OPERATIONAL

SYSTEMS

PERSONNEL

FINANCIAL

SYSTEMS

OPERATIONS

SUPPLY CHAIN

SUPPLIERS

Business Intelligence in the Public Sector


June 2008

BUSINESS BENEFITS OF COGNOS
PERFORMANCE MANAGEMENT SYSTEM


Speak with one consistent
voice across the
organization


Greatly reduce time and
effort to produce critical
information


Make better and faster
decisions that improve
performance and outcomes

Business Intelligence in the Public Sector


June 2008

COGNOS GPM IN ACTION


Social Services


fraud detection, case
management


Tax / Revenue


risk
management


Education


student
performance


Healthcare


patient
wait times

Business Intelligence in the Public Sector


June 2008

COGNOS GPM IN ACTION


Public Safety


crime
analysis, responsiveness


Procurement


supplier
management


Human Capital
Management


workforce
analytics, aging
workforce


E
-
Government


Business Intelligence in the Public Sector


June 2008

SAMPLE COGNOS GOVERNMENT
CUSTOMERS AROUND THE WORLD


Human Resources Skills and
Development Canada


Social Development Canada


Centers for Medicare and
Medicaid Services (U.S.)


U.S. Army, Navy, Air Force and
Marine Corps


State of Ohio (U.S.)


New York Police Department


Australian Tax Office


Penn State University (U.S.)


State Police of Lower Saxony
(Germany)


Department of Homeland
Security (U.S.)


London Fire and Emergency
Planning Authority (U.K.)


Department of Finance and
Administration (Australia)


Massachusetts Department of
Education (U.S.)


Alberta Children’s Trust
(Canada)


South Tyneside Healthcare
Trust (U.K.)


Region Västra Götaland
(Sweden)


Direction Generale des Impots
(France)

Business Intelligence in the Public Sector


June 2008

Indicative Customer Case Studies

Business Intelligence in the Public Sector


June 2008

Central Umbrella Body for Social Security Organizations
-

FRANCE

Information Needs:



To restructure its IT architecture & simplify control



To respond to new requirements



To optimize management of business processes

Solutions:

Cognos Reporting, Analysis,
Scorecarding

Platforms:

IBM AIX, Oracle

Users:

2.000 +


Benefits:



Architecture that is more easily
managed & more flexible



Optimization of the organization’s
services & performance



Fewer demands in terms of
development and maintenance

Business Intelligence in the Public Sector


June 2008

Central Umbrella Body for Social Security Organizations
-

FRANCE

‘Cognos Applications
are characterized

by ease of
implementation
and

quick user acceptance.

These are two essential criteria for the success of our
decision
-
support project and, therefore,

for our goal

of
extending analysis to new areas, including Performance
Management and the Optimization of the service we
provide to our clients. ’


Pierre Bisson, IT Director, within the ACOSS/URSSAF Organization

Business Intelligence in the Public Sector


June 2008

Information Needs:



Real
-
time & trending information on key
expense drivers
-
labor & supply



More timely & flexible budgeting



Elimination of spreadsheets


Decreased manual intervention for data
analysis

Solutions:

Cognos Reporting & Analysis


Platforms:




AS400



SQL Server



Windows 2000



Financial data repository



GL, supply chain, billing patient
information system


Users:

150


Business Intelligence in the Public Sector


June 2008

Benefits:



Access to a comprehensive view of process & system information



Flexible & real
-
time budgeting, spending projection, and trending



Real
-
time labor expense reconciliation



Elimination of duplicate payments and missed charges



Daily cash balancing



Streamlined reporting

Business Intelligence in the Public Sector


June 2008

‘With the financial data repository and Cognos, staff can
use real
-
time wage information based on actual clocked
hours against actual month and actual volume. Accrual is
no longer necessary for analysis ’


Kevin Murphy, Chief Financial Officer, Middletown Regional Hospital

Business Intelligence in the Public Sector


June 2008

Information Needs:



More & more demands for statistical
information from various government bodies,
all demanding different data at different times




Problems of tracking students throughout
their careers: which course were dropped,
which where taken up, and whether students
missed exams for medical reasons

Solutions:

Cognos Reporting & Analysis

Users:

200


Benefits:



Administration, faculty instructors, and
clerical staff have

Instant access to
information as required


processes that
in many cases used to take days to
complete



Solution to Student registration mix
-
ups



Exact postcode analysis & can target the
catchment areas for future students



Estate management

Business Intelligence in the Public Sector


June 2008

‘We’ve definitely received return on our investment in
Cognos Technology. The administration is run much more
efficiently now that staff can concentrate on their actual
jobs’


Robert Roulston, Head of Administrative Support, Queens University Belfast

Business Intelligence in the Public Sector


June 2008

Information Needs:



A common enterprise IT environment with a
Web
-
based portal and an enterprise shared
data environment



Fast financial information for management,
outside agencies, and troops



Flexible reporting & analysis that can adapt
quickly to changing requirements

Solutions:

Cognos Reporting &
Analysis

Platforms:




Homegrown mainframe accounting
system



Oracle 9i


Other proprietary & transactional
systems

Users:

3.600 +


Business Intelligence in the Public Sector


June 2008

Benefits:



A BI platform that touches all disparate data sources to provide a
single version of the truth



Information in minutes rather than days



Reports and insight on areas never before possible



Cost savings in processing power, lower resource requirements, and
less reliance on paper



Web
-
based system that delivers information across the globe

Business Intelligence in the Public Sector


June 2008

‘The Marine Corps will always do what’s best for our
people on the front lines.

Today, tomorrow, and into the future, we are taking
Cognos with us into battle. ’


Jarret S. Kuhfahl, Financial Systems Developer, The US Marine Corps

Business Intelligence in the Public Sector


June 2008

AMS Needs:



Tight controls, optimized use of resources,
data to support management decisions



Transparent & flexible information system,
with impressive results

Solutions:

Cognos Reporting, Analysis,
Scorecarding

Project:

500 data cubes, 4.000 potential
web users


Benefits:



Keeping a tight rein of performance



The scorecarding solution combines
labor market targets, processing
objectives and customer objectives into a
high level view



Control of funding budget



Optimization of the use of resources



Monitor career paths

Business Intelligence in the Public Sector


June 2008

‘Now that we have our data together in one place, we’re
able to better serve our customers by helping them find
gainful employment ’


Herbet Bohm, Member of AMS Board

Business Intelligence in the Public Sector


June 2008

‘The fact that we could deploy this solution across the
Web from one central location sold it to us. The change
has been dramatic. Now we can analyze 3 years worth of
data and start to identify trends. ’


Phil Freestone, Business Systems Analyst, London Fire & Emergency Planning Authority

Business Intelligence in the Public Sector


June 2008

Atlanta Rolled Out Cognos Analysis S/W

$ 2.1 M
-
plus project for
monitoring performance
of all departments


Cognos 8 BI


~1.000 users


‘With Cognos we are able to look at
things like the cost per acre to
maintain a park, the cost per work
order for field
-
level operations and
the average manpower & materials
costs to repair a traffic light or
surface a mile of a city street. ’


Chuck Meadows, Chief of Budget & Fiscal
Policy, City of Atlanta

Business Intelligence in the Public Sector


June 2008

References in Finance & Taxation Departments

Solutions
: Cognos Business Intelligence


Solutions
: Cognos Planning, BI,
Scorecarding

1.500 cubes

20.000 users

Dutch Taxation Office

Solutions
: Cognos Business Intelligence

3.000 users

Swedish Tax Office

Solutions
: Cognos Business Intelligence

16.000 users, Central Government

Thank You

for

your
attention