Cognos Government Performance Management Yiannis Lekos SCICOM S

Cognos Government Performance Management Yiannis Lekos – SCICOM S. A. Cognos CPM Senior Consultant 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 DECISIONREADY 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 How are We Doing? Why? Business Intelligence in the Public Sector – June 2008 What Should We be Doing?

Student Performance Students in grade 3 in School Board 2 are trailing Federal goals Program Performance THREE QUESTIONS THAT ADVANCE PERFORMANCE IN GOVERNMENT Percentage of eligible families served is below target Analysis reveals teacher qualifications lag in key areas compared with other similar districts Analysis reveals low application volumes in Region 2 Business Intelligence in the Public Sector – June 2008 Implement program to upgrade skills of teachers; recruit more seasoned teachers into district Re-allocate funds toward targeted outreach program to advise of eligibility

SINGLE DEFINITION OF THE TRUTH Single Platform for Decision Making Business Intelligence in the Public Sector – June 2008

DATA SILOS ARE EVERYWHERE; REPORTING IS TYPICALLY BY SUBJECT AREA OPERATIONAL SYSTEMS SUPPLY CHAIN OPERATIONS FINANCIAL SYSTEMS PERSONNEL SUPPLIERS Business Intelligence in the Public Sector – June 2008

SYNCHRONIZING DATA PROVIDES CONSISTENT ENTERPRISE-WIDE VIEW OPERATIONAL SYSTEMS SUPPLY CHAIN OPERATIONS FINANCIAL SYSTEMS PERSONNEL 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 • Department of Homeland Security (U. S. ) • Social Development Canada • • Centers for Medicare and Medicaid Services (U. S. ) London Fire and Emergency Planning Authority (U. K. ) • • U. S. Army, Navy, Air Force and Marine Corps Department of Finance and Administration (Australia) • • State of Ohio (U. S. ) Massachusetts Department of Education (U. S. ) • New York Police Department • • Australian Tax Office Alberta Children’s Trust (Canada) • Penn State University (U. S. ) • South Tyneside Healthcare Trust (U. K. ) • State Police of Lower Saxony (Germany) • 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: Benefits: • To restructure its IT architecture & simplify control • Architecture that is more easily managed & more flexible • To respond to new requirements • To optimize management of business processes • Optimization of the organization’s services & performance Solutions: Cognos Reporting, Analysis, Scorecarding • Fewer demands in terms of development and maintenance Platforms: IBM AIX, Oracle Users: 2. 000 + 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: • AS 400 • 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: Benefits: • More & more demands for statistical information from various government bodies, all demanding different data at different times • Administration, faculty instructors, and clerical staff have Instant access to information as required – processes that in many cases used to take days to complete • Problems of tracking students throughout their careers: which course were dropped, which where taken up, and whether students missed exams for medical reasons • Solution to Student registration mix-ups Solutions: Cognos Reporting & Analysis • Exact postcode analysis & can target the catchment areas for future students • Estate management Users: 200 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 9 i • 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: Benefits: • Tight controls, optimized use of resources, data to support management decisions • Keeping a tight rein of performance • Transparent & flexible information system, with impressive results • The scorecarding solution combines labor market targets, processing objectives and customer objectives into a high level view Solutions: Cognos Reporting, Analysis, Scorecarding • Control of funding budget Project: 500 data cubes, 4. 000 potential web users • Monitor career paths • Optimization of the use of resources 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 ‘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 $ 2. 1 M-plus project for monitoring performance of all departments • Cognos 8 BI • ~1. 000 users Business Intelligence in the Public Sector – June 2008

References in Finance & Taxation Departments Swedish Tax Office Solutions: Cognos Business Intelligence 16. 000 users, Central Government Dutch Taxation Office Solutions: Cognos Planning, BI, Scorecarding 1. 500 cubes Solutions: Cognos Business Intelligence 3. 000 users 20. 000 users Business Intelligence in the Public Sector – June 2008

Thank You for your attention