WFC News

Data Analysis & Presentation for Fire and EMS

Event date: 7/24/2018 - 7/26/2018 Export event

Snohomish County Fire District #7

A Class for Fire Service Personnel with Responsibilities in  Deployment Analysis, Data Presentation, and Resource Planning 

Date and Time

 July 24 – 26, 2018   08:30 - 16:30 


Snohomish County Fire District #7

 953 Village Way, Suite 200 Monroe, WA. 98272 


Course Description -- Data Analysis & Presentation Using Microsoft Excel 

This three-day hands-on course is designed to give fire and EMS personnel a comprehensive understanding of the most commonly used analytic and statistical tools available for performance measurement and reporting. The course will prepare the attendee for making better and more defensible policies and presentations on department operations and long-term planning. The class includes instruction in basic and intermediate-level Microsofttm Exceltm and does not require any prior experience with Excel (although some proficiency is strongly recommended.)

Some Things You Will Learn In This Class 

• An introduction to statistics for Fire and EMS (without the difficult math.) 

• Use of Excel for analyzing Fire and EMS operations-related data.

 • Visual representations (tables and graphs,) which to use and when. 

• Understanding the special considerations with small data. 

• Best practices in Fire and EMS data quality 

• Methods for setting realistic performance objectives. 

• Methods for consistently identifying and handling outliers in data 

• Methods for calculating effective response force and unit concentrations. 

• Understanding and calculating percentiles and NFPA compliance rates.

• Methods for evaluating units' order of arrival at scene, unit and system reliability. 

• Understanding the basics of correlation - understanding relationships between variables.  

• Pivot tables, filtering, sorting and summarizing.  

• Methods and best practices for use of statistics in fire service performance measurements. 

Materials Required 

Laptop computer with Microsoft Excel. 

Prior Experience and Knowledge Required 

No statistics, advanced mathematics or Exceltm experience is required. A basic familiarity and comfort with computers is essential, however. 

Materials Provided 

• All class data sets will be provided electronically in advance of the class 

• Anthology of relevant writings on performance measurement in the fire service 

• Access to video recorded evolutions of much of what is covered in the class

Course Format 

Each class has a maximum of 20 students. The course includes lecture, demonstration, and hands-on application. 

Course Instructor 

Paul Rottenberg is the president of FireStats, LLC., a management consulting firm providing analysis and support to fire departments throughout the United States. Paul has an MBA from the University of San Francisco and a Master’s in Public Health from UCLA and has worked for public and private entities in financial and operations analysis for over 25 years. Paul is the sole creator and instructor of all FireStats curriculum and has taught his classes to over 3,000 fire officers throughout the US. FireStats has worked on hundreds of fire department analysis projects including standards of cover, accreditation, strategic plans, EMS QI, and customized statistical and probabilistic analyses in support of engine and ambulance deployment and staffing models. Paul spent ten years as an active paid-call engineer/EMT with a combination fire department in Northern California and is a USFA subject matter expert in deployment analysis.

Contact  Paul Rottenberg 530.478.0657 


Posted: May 16, 2018,
Comments: 0,
Rate this article:
No rating

Documents to download

Please login or register to post comments.

Search News Articles