Public Health Measures Pandemic Planning - Health Sector ...

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 Raise the profile of RRFSS internally

1. Analysis Process SPSS data Data analysis (SPSS) Analysis result (SPSS data format) Export to Excel 2. Database Append to table in database (Access)

Upload database to Intranet server 3. Interface Web-based query interface RRFSS report (tables / charts) 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 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

Web Interface Dynamic SQL statement user defined Create HTML tables & graphical charts Output final page structure browser Query Page

Query Parameters Passes parameters into the SQL statement to build the report Table Totals Area Indicator LabelHeading Labels

Releasent StartWave EndWave Table - Subgroup GroupHeading Group Chart

Indicator StartWave EndWave Area Advantages & Limitations

Efficient Centralized Dynamic Customizable Cost # data requests

Garbage In / Garbage Out Not a magic bullet (analysis still required) Technical expertise Software / hardware requirements Interpretation Questions John Barbaro, Research Analyst Simcoe Muskoka District Health Unit [email protected] 1-705-721-7520 ext. 7310 Kevin Pipher, Webmaster Simcoe Muskoka District Health Unit

[email protected] 1-705-721-7520 ext. 7211