Implementing Centralized Reporting using SAP Analytics Philippe - PowerPoint PPT Presentation

Implementing Centralized Reporting using SAP Analytics Philippe Johnston Senior Director, Business Solutions & Application Development Jonathan Andrews Manager, Application Development/Database & Data Administration Information Management and Technology Directorate - Treasury Board of Canada Session ID#A3859

Overview • In 2014, the Treasury Board of Canada (TBS) began a multi-year program to implement a Centralized Reporting Infrastructure using SAP BW & SAP BO-BI tools. • Following the SAP Analytics roadmap for Simplification & Best Practices, TBS have developed a robust solution that provides improved data-access to thousands of Public Sector workers. 1. Departmental drivers for Centralized Reporting 2. Centralized Reporting Infrastructure delivery-model at Treasury Board of Canada 3. Current State, Future-Growth & Lessons Learned

Speaker Bio - Philippe Johnston Philippe Johnston Philippe.Johnston@tbs-sct.gc.ca Senior Director, Business Solutions & Application Development Information Management and Technology Directorate Treasury Board of Canada Secretariat Responsible for Functional Delivery of various SAP BI Solutions to many Government of Canada departments & Agencies via TBS Channels. Previous Departments / Experience – • Navy Officer who served on Her Majesty’s Canadian Ships • Cyber Defence for the Government of Canada

Speaker Bio - Jonathan Andrews Jonathan Andrews Jonathan.Andrews@tbs-sct.gc.ca Manager, Business Intelligence, Reporting and Data Information Management and Technology Directorate Treasury Board of Canada Secretariat Responsible for Functional Delivery of various SAP BI Solutions to many Government of Canada departments & Agencies via TBS Channels. Previous Departments / Experience – • Managed the deployment and maintenance of a SAP ECC 6.0 solution with a complex set of business functionality to support the budgetary process of the Government of Canada • 10+ Years experience working on SAP projects as Functional or Reporting and Business Intelligence team lead

Background - Treasury Board of Canada (TBS)

Background - Treasury Board of Canada (TBS) • Treasury Board is responsible for the Financial, HR, IM/IT, and efficient and effective Performance of the entire Government of Canada (GC) • It manages the $250B budget, the over 250,000 employees and the IM/IT Direction for the entire GC • Treasury Board itself is made up of approximately 2,000 financial, HR, IM/IT analysts that review GC priorities and make recommendations on where funding should be allocated

Roles in Government - Treasury Board of Canada (TBS) … Essentially Corporate in the Private Sector

Background – GoC Departments, Agencies & Crown Corps. Canadian Northern Atlantic Canada Canada Economic Agriculture and Canada Revenue Economic Citizenship and Opportunities Development for Canadian Heritage Agri-Food Canada Agency Development Immigration Canada Agency Quebec Regions Agency Employment and Environment and Fisheries and Global Affairs Elections Canada Social Development Climate Change Finance Canada Health Canada Oceans Canada Canada Canada Canada Innovation, Science Indigenous and and Economic Natural Resources Privy Council Public Safety Northern Affairs Justice Canada National Defence Development Canada Office Canada Canada Canada Public Services and Transportation Western Economic Veterans Affairs Procurement Transport Canada Safety Board of Diversification Canada Canada Canada Canada • 31 Ministerial Portfolios covering 209 Government of Canada Departments, Agencies, Crown Corporations, Special Operating Agencies and other related organizations. • TBS provides advice and guidance to the Treasury Board committee of ministers on how the government spends money on programs and services, how it regulates and how it is managed. • The Secretariat helps ensure tax dollars are spent wisely and effectively for Canadians.

Background – Corporate Services Sector (CSS) • The Corporate Services Sector (CSS) assists the Secretary of the Treasury Board in the internal administration of the Secretariat. • The CSS provides internal corporate services to the Secretariat and certain shared services to internal and Government-Wide clients. • The CSS provides support in the areas of financial management, security, information management, information technology, and facilities and materiel management.

Background – Business Intelligence Challenges (2010) Activities OGDs • Data Collection • Feedback • Collaboration Executive Talent Management System Public Service Performance Management Management Accountability Framework OPMCA / PCRA MAF Hydrae drae Callipe pers rs ETMS PSPM SAP Hydrae STAND- ALONE “SILO” REPORTING Canned Reports, Excel Requests, Unmanaged Requests, DB Exports for each Line-of-Business Application. - Multiple Silos - Multiple Vendors - Little Data-Sharing

Background – Business Intelligence Challenges (2010) • Information Hoarders • Little Common Data • Many versions of the “Truth” • Not getting High- Value results from our Data 11

Business Intelligence Strategic Gaps (2011-2013) • Support of the Treasury Board Secretariat operations by establishing: – a single location for accessing data for reporting and analysis – Elimination of duplicate and disparate reporting – a centralized reporting and business intelligence service • Business Intelligence, reporting and access to data for TBS, other government departments and eventually, the general public. • Provide secure access to the entire GC to BI Reports (*Approved|Released by TBS) through the TAP portal.

Treasury Board of Canada (TBS) – Analytics Vision

TBS Multi-Year SAP Analytics Deployment Measure Influence 2012 2014 Performance/ 2015 2016 2017 Decision Compliance Making • SAP BW & BO – 4.1 platforms (DEV / UAT / PROD) • Branded as Central Online Reporting System (CORS) • Secure access to the Government of Canada clients • “Land and Expand” method of SAP BO -BI 4.1 Tool deployment

SAP BW / BO-BI Landscape (Data Layers) Measure Influence 2012 2014 2015 2016 2017 Performance/ Decision Compliance Making • Data provisioned from multiple sources/formats. • Consolidation and Aggregation in the SAP Business Warehouse (BW) for Large data-sets. • Direct-Connection to Source Data for Operational/Transactional reports. • Solutions based on Scope, Size and SAP Best Practices.

SAP BW / BO-BI Landscape (Data Layers) Measure Influence 2014 Performance/ 2015 2016 2017 Decision Compliance Making • Integrated Enterprise Data Warehouse • Single Source of Truth • SAP Best Practices for Extraction & Aggregation • Online Analytical Processing (OLAP) • End-to-End Integration with SAP ECC and SAP BO • Data sourced from SAP and Non-SAP systems

SAP BW / BO-BI Landscape (Data Layers) Measure Influence 2012 2014 2015 2016 2017 Performance/ Decision Compliance Making • Data is an Enterprise Asset. • SAP-BW deployment aims to reduces internal Data “Silos”. • IMTD has organizational responsibility for managing the SAP-BW technology infrastructure and support. • Common framework of CORS tools and methods for all Business- Units • Each TBS Business-Unit is the Guardian for their data within SAP- BW. • Data assets owners in the TBS Business-Unit act as Data Guardians and Data Stewards. • Data duplication on Common TBS objects will be reduced between Business-Units within SAP-BW. • IT Security and Data Security models will move towards a Common framework within SAP-BW.

SAP BW/BO-BI (CORS) Architecture : High-Level View Measure Influence 2012 2014 2015 2016 2017 Performance/ Decision Compliance Making

SAP BW / BO-BI (CORS) Landscape Measure Influence 2012 2014 Performance/ 2015 2016 2017 Decision Compliance Making

CORS Secure External Access via TAP Measure Influence 2012 2014 2015 2016 2017 Performance/ Decision Compliance Making GC WinAD *Converted to* SAP User, Company & Language (EN / FR) Credentials

CORS Early-Adopters Measure Influence 2014 Performance/ 2015 2016 2017 Decision Compliance Making • Service to other GoC Departments. 250,000 users • Secure Access Via TBS Application Portal (TAP). • Public Service Performance Management (PSPM) • Management Accountability Framework (MAF)

Deployed CORS platform at TBS Measure Influence 2014 2015 2016 2017 Performance/ Decision Compliance Making • SAP BO – 4.1 Launchpad Interface (English & French) • Crystal Reports 2013 (*Non-SAP Data) • Crystal Reports for Enterprise 4.1 (*SAP BW Data) • WebIntelligence

CORS Following SAP Analytics “Simplification” of Tools Measure Influence 2014 Performance/ 2015 2016 2017 Decision Compliance Making • Crystal Reports 2013 • Crystal Reports for Enterprise 4.1 • WebIntelligence

TBS Multi-Year SAP Analytics Deployment via CORS Measure Influence 2014 Performance/ 2015 2016 2017 Decision Compliance Making • Crystal Reports 2013 • Large pixel- perfect documents, often rendered as PDF • Management Accountability Framework (MAF) Comparative Benchmark Reports