1 / 13

Use of a Web-Based Report Generator for Internal Dissemination of RRFSS Results

Use of a Web-Based Report Generator for Internal Dissemination of RRFSS Results. Outline. Background Process Demonstration Advantages/Limitation Questions. Background. Internal dissemination of RRFSS Use of Health Unit Intranet Supplement indicator pages

damon-watson
Download Presentation

Use of a Web-Based Report Generator for Internal Dissemination of RRFSS Results

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. Use of a Web-Based Report Generatorfor Internal Dissemination of RRFSS Results

  2. Outline • Background • Process • Demonstration • Advantages/Limitation • Questions

  3. Background • Internal dissemination of RRFSS • Use of Health Unit Intranet • Supplement indicator pages • Raise the profile of RRFSS internally

  4. SPSS data Data analysis (SPSS) Analysis result (SPSS data format) Append to table in database (Access) Export to Excel Web-based query interface Upload database to Intranet server RRFSS report (tables / charts) Process 1. Analysis 2. Database 3. Interface

  5. Analysis • Macros • Used by all syntax files • For calculating: seasonal weights, weighted and unweighted estimates with 95% CI for total population and select subgroups, checking release criteria • Syntax • Separate file for each module • Retrieves data set & derives variables • Calculates % and 95% CI for overall & subgroups • Defines all titles & labels needed for queries, tables & charts • Aggregates data into one file • Exports to an Excel file linked to database

  6. Database • MS Access database • Set table structure • Add data from the Excel via an Append Query • Upload to Intranet server • Through a secure page on Intranet • Synchronize DB from internal network to applications data folder

  7. Web Interface • Dynamic SQL statement – user defined • Create HTML tables & graphical charts • Output final page structure browser

  8. QueryParameters Query Page Passes parameters into the SQL statement to build the report

  9. Table – Totals StartWave Indicator EndWave Area LabelHeading Labels Releasent

  10. Table - Subgroup GroupHeading Group

  11. Chart Indicator Area EndWave StartWave

  12. Efficient Centralized Dynamic Customizable Cost  # data requests Garbage In / Garbage Out Not a “magic bullet” – (analysis still required) Technical expertise Software / hardware requirements Interpretation Advantages & Limitations

  13. Questions John Barbaro, Research AnalystSimcoe Muskoka District Health Unit John.Barbaro@smdhu.org1-705-721-7520 ext. 7310 Kevin Pipher, Webmaster Simcoe Muskoka District Health Unit Kevin.Pipher@smdhu.org1-705-721-7520 ext. 7211

More Related