1 / 15

Implementing Cognos ReportNet at Agriculture & Agri-Food Canada

Implementing Cognos ReportNet at Agriculture & Agri-Food Canada. An Analysis of the Road Ahead. Jon-Michael Falconer 3B Math/Business, Former Co-op Student with Integrated Business Solutions Team, AAFC. Nov. 16, 2005. Objectives.

afram
Download Presentation

Implementing Cognos ReportNet at Agriculture & Agri-Food Canada

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Implementing Cognos ReportNet at Agriculture & Agri-Food Canada An Analysis of the Road Ahead Jon-Michael Falconer 3B Math/Business, Former Co-op Student with Integrated Business Solutions Team, AAFC Nov. 16, 2005

  2. Objectives • To provide an overview of Agriculture and Agri-Food Canada’s (AAFC) purchase of a reporting tool to improve end-user reporting capability • To provide insight into information systems development issues in the public sector

  3. Outline • History • Overview of ReportNet • Expected Benefits • Challenges ahead

  4. History • AAFC Integrated Business Delivery Strategy (IBDS) • AAFC delivers over 50 programs and services to producers • Transaction-based programs • Proposal-based programs • other programs... • Most programs had their own separate information system • Data redundancy issues • Data existed in “silos” • Little to no existing reporting capability

  5. History (cont’d) • IBDS is being implemented to address: • front-end processes • back-end processes • Some IT projects covered by the IBDS include: • Web site renovation • Call centre consolidation • Data management strategy • Decision Support initiatives • Common Producer Database (CPD)

  6. Common Producer Database • A data warehouse • A single, enterprise-wide repository of data on farmers • Keeps track of: • “Tombstone” information • Program application data • Other data

  7. History (cont’d) • Modern Comptrollership • Broader Government of Canada initiative • “Modern comptrollership supports the effective stewardship of resources of all types throughout the federal government…It is about working smarter for better results: better informed decisions, better public policies and better service delivery.” -Treasury Board Secretariat

  8. History (cont’d) How can we easily access financial, HR, and performance data to aid in decision making? Reporting software!

  9. Cognos ReportNet • Highlights • Web services-based architecture • Incorporates dashboards • Multilingual • 2 main modules: • Query Studio • Simple, ad hoc queries • Ideal for business users • Report Studio • More powerful, sophisticated reporting • Ideal for report authors

  10. Expected Benefits • Quick access to data • User-friendly access to data • Access to consistent data All to enhance Decision Support capabilities

  11. Challenges Ahead • Data Issues • Data redundancy • Refining data definitions • Data cleansing • Establishing a Data Management Strategy • Complying with Access to Information and Privacy Act (ATIP)

  12. Challenges Ahead (cont’d) • Organizational issues • Getting full support from senior management • Avoiding excessive consulting costs • Excessive client consultation vs. inadequate consultation • Overcoming bureaucracy

  13. Challenges Ahead (cont’d)

  14. References From Cognos: • http://www.cognos.com/products/business_intelligence/reporting/ • http://www.cognos.com/products/cognos8businessintelligence/dashboards.html From Government of Canada • http://www.agr.gc.ca/csb/dpr-rsr/2004/index_e.php?page=11 • http://www.agr.gc.ca/csb/sm-gs/mafc_e.php • http://www.tbs-sct.gc.ca/cmo_mfc/Intro2/intro_e.asp Other resources • http://www.dmreview.com/article_sub.cfm?articleId=1035317

More Related