Implementing Cognos Report Net at Agriculture AgriFood Canada

  • Slides: 15
Download presentation
Implementing Cognos Report. Net at Agriculture & Agri-Food Canada An Analysis of the Road

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

Objectives l l To provide an overview of Agriculture and Agri-Food Canada’s (AAFC) purchase

Objectives l l 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

Outline l l History Overview of Report. Net Expected Benefits Challenges ahead

Outline l l History Overview of Report. Net Expected Benefits Challenges ahead

History l l AAFC Integrated Business Delivery Strategy (IBDS) AAFC delivers over 50 programs

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

History (cont’d) l IBDS is being implemented to address: – – l front-end processes

History (cont’d) l IBDS is being implemented to address: – – l 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)

Common Producer Database l l l A data warehouse A single, enterprise-wide repository of

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

History (cont’d) l Modern Comptrollership – l Broader Government of Canada initiative “Modern comptrollership

History (cont’d) l Modern Comptrollership – l 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

History (cont’d) How can we easily access financial, HR, and performance data to aid

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

Cognos Report. Net l Highlights – – Web services-based architecture Incorporates dashboards Multilingual 2

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

Expected Benefits l l l Quick access to data User-friendly access to data Access

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

Challenges Ahead l Data Issues – – – Data redundancy Refining data definitions Data

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

Challenges Ahead (cont’d) l Organizational issues – – Getting full support from senior management

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

Challenges Ahead (cont’d)

Challenges Ahead (cont’d)

References From Cognos: l http: //www. cognos. com/products/business_intelligence/reporting/ l http: //www. cognos. com/products/cognos 8

References From Cognos: l http: //www. cognos. com/products/business_intelligence/reporting/ l http: //www. cognos. com/products/cognos 8 businessintelligence/dashbo ards. html From Government of Canada l http: //www. agr. gc. ca/csb/dpr-rsr/2004/index_e. php? page=11 l http: //www. agr. gc. ca/csb/sm-gs/mafc_e. php l http: //www. tbs-sct. gc. ca/cmo_mfc/Intro 2/intro_e. asp Other resources l http: //www. dmreview. com/article_sub. cfm? article. Id=1035317