1 / 26

Ad-Hoc Query & Reporting Tool Project Overview

This project aims to provide a robust ad-hoc query and reporting tool to enhance the IMPACII DB. It involves implementing a pilot program, offering pre-programmed reports, and empowering users to manipulate data. Leading BI technologies such as Hummingbird, COGNOS, Business Objects, and Oracle will be used for analytic reporting and decision support. The project timeline includes requirements analysis, evaluation period, and implementation. The team is on schedule, with monthly meetings and testing areas set up. Manipulating pre-programmed reports in the NIH Data Warehouse using Hummingbird involves selecting, responding to prompts, manipulating report formats, and exporting data to Excel.

griffen
Download Presentation

Ad-Hoc Query & Reporting Tool Project Overview

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. Ad Hoc Query & Reporting Project Overview

  2. Project Goals • Provides user community with robust “Ad-Hoc” Query & Reporting tool • Complements and enhances IMPACII DB • Pilot Implementation in Fall 2001

  3. Two Threads • Query and reporting for “Power-users” • Provide users ability to run queries and reports against OLTP & IRDB • Pre-Programmed Reports. • Provide OLTP users with the ability to manipulate data on existing reports.

  4. Technology • Business Intelligence • Transforming data into knowledge • Four leaders in the BI field • Hummingbird, COGNOS • Business Objects & ORACLE • Analytic Reporting • Decision Support Solution

  5. Decision Support • Drill down through increasing levels of detail • Analyze Data for trends • Congressional Reporting • Ability to extract and report quickly

  6. Procedures • Finished with Proof-of-Concept • Will begin 90 day Evaluation period • Tech Support from companies • Q & R Team will make recommendation to Era Project on what tool to implement

  7. Team Carol Martin (GA) Krishna Collie (A) Sherry Zucker James Tucker Andrew Greenleaf Mark Parker Natasha Globus Vish Kalippian Richard Somwaru

  8. Requirements Analysis Evaluation Period Implementation Jan Feb Mar Apr May Jun July Sep Oct Nov Dec Project Schedule • Requirements, Evaluation & Implementation

  9. Current Status • On-Schedule to recommend and implement tool Fall 2001 • Monthly Project meetings (July) • Setting up testing Areas • Final Review of Evaluation Criteria

  10. Manipulating Pre-Programmed Reports in the NIH Data Warehouse Hummingbird

  11. From report menu, select report

  12. Respond to prompts

  13. From List of Values, select IC

  14. Wait while query runs

  15. Results displayed in pre-programmed report

  16. Report format can be manipulated by user - Left click in report area to change

  17. User can reorder columns

  18. User can change column header labels and font

  19. User can change borders appearance of data display

  20. Report specs can be saved

  21. To export data to Excel, select ‘Show Results’ from Report Menu

  22. Click in upper left cell to ‘Select All’

  23. From Edit menu, select ‘Copy’ (or use Ctrl ‘c’)

  24. Invoke Excel, then paste

More Related