1 / 26

Ad Hoc Query & Reporting

This project aims to provide a robust ad-hoc query and reporting tool for the user community, enhancing data analysis capabilities. The implementation involves leaders in BI technology such as Hummingbird, COGNOS, Business Objects, and Oracle. Users will have the ability to run queries against OLTP and IRDB, analyze trends, and perform Congressional reporting, with tech support and recommendations from the Q&R team. The project schedule includes requirements analysis, evaluation, and implementation phases, with the current status showing progress towards the fall 2001 deployment. Manipulating pre-programmed reports in the NIH Data Warehouse using Hummingbird offers extensive customization options, from changing report format to exporting data to Excel. Regular project meetings and testing are in place to ensure successful tool implementation.

krieger
Download Presentation

Ad Hoc Query & Reporting

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