Implementing Cognos Report Net at Agriculture AgriFood Canada
- Slides: 15
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 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
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 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 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 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 in decision making? Reporting software!
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 to consistent data All to enhance Decision Support capabilities
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 Avoiding excessive consulting costs Excessive client consultation vs. inadequate consultation Overcoming bureaucracy
Challenges Ahead (cont’d)
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
- Cognos training nj
- Mainframe mips optimization
- Ibm cognos mobile
- Ibm swg
- Koreabi
- Ibm cognos 8 business intelligence
- Ibm cognos express
- Cognos best practices
- Cognos analytics trial
- Cognos javascript samples
- Cognos cpm
- Ibm plm
- Ibm cloud architecture center
- School plus app
- Cognos business viewpoint
- Slicing and dicing in cognos