260 likes | 266 Views
Ad Hoc Query & Reporting. Project Overview. Project Goals. Provides user community with robust “Ad-Hoc” Query & Reporting tool Complements and enhances IMPACII DB Pilot Implementation in Fall 2001. Two Threads. Query and reporting for “Power-users”
E N D
Ad Hoc Query & Reporting Project Overview
Project Goals • Provides user community with robust “Ad-Hoc” Query & Reporting tool • Complements and enhances IMPACII DB • Pilot Implementation in Fall 2001
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.
Technology • Business Intelligence • Transforming data into knowledge • Four leaders in the BI field • Hummingbird, COGNOS • Business Objects & ORACLE • Analytic Reporting • Decision Support Solution
Decision Support • Drill down through increasing levels of detail • Analyze Data for trends • Congressional Reporting • Ability to extract and report quickly
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
Team Carol Martin (GA) Krishna Collie (A) Sherry Zucker James Tucker Andrew Greenleaf Mark Parker Natasha Globus Vish Kalippian Richard Somwaru
Requirements Analysis Evaluation Period Implementation Jan Feb Mar Apr May Jun July Sep Oct Nov Dec Project Schedule • Requirements, Evaluation & Implementation
Current Status • On-Schedule to recommend and implement tool Fall 2001 • Monthly Project meetings (July) • Setting up testing Areas • Final Review of Evaluation Criteria
Manipulating Pre-Programmed Reports in the NIH Data Warehouse Hummingbird
Report format can be manipulated by user - Left click in report area to change
To export data to Excel, select ‘Show Results’ from Report Menu