My Fire Rules Version Available:

My Fire Rules Alert

Zoll Alert

EFR Alert

My ePCR Metrics Alert

COVID-19 Alert

Attention ZOLL ePCR Users

  • Do you need a bridge to your DATA that goes way beyond Crystal Reports & Insight Analytics?
  • Are you dreading moving to NEMSIS-3 and ePCR Version-6 because of the thought of all of those Crystal Reports that you need to Build or Edit to get at all of that NEW Data?
  • There IS an alternative to Crystal Reports that can save you from all that work and cost of writing or editing Crystal Reports.
  • For more information please email us at!

Insight Analytics Crystal Reports My ePCR Metrics

  • The above is a graphical representation of the Data Query tools available for you to explore your ePCR Data:
    • Insight Analytics gives you high level insights (hence the “Express Elevator” image). However you cannot drill in the underlying data.
    • Crystal Reports is a cumbersome tool (hence the “Stairway” image, a never-ending climb) that takes time and effort to create, edit and manage, let alone the time and effort it takes to wade through Paper or PDF copies. Additionally, it too does not allow you to “drill-into” that underlying data, and if you want a different “viewpoint” of that data, it requires yet another Crystal Report be written.
    • My ePCR Metrics allows you to analyze ALL of the underlying data (hence the “Escalator” image). It is based on our “Auto-Updating Data Warehouse” (nothing is written to the ePCR Database) and uses a set of customizable “Preconfigured Excel Pivot Tables”. Don't let the label “Pivot Table” scare you – they are very easy to use, and Free “One-on-One Training” is available.
  • My ePCR Metrics gives you Full, Complete and Easy access to ALL of your ZOLL ePCR Data!

  • The right tool for the right job
    • 7 different “views of the ePCR Data”
      • Trips ONLY
      • Trips & Interventions
      • Trip Interventions (Flattened with Qualifiers)
        • New addition
      • Trips & Vitals
      • Trips & Assessments
      • Trip Overview - includes Vitals, Interventions & Assessment in one view
      • Patients & Trips
        • Separate Workbook – protected by Password
    • Each of these Pivot Tables let you explore the full ePCR Data from a different point of view
  • Quickly Filter your data to what you are looking for.
    • Choose any item and filter to only what you want to interrogate your data concerning
  • Quickly Sort your data

    by simply dragging a field left or right

    • Such as Item per Time Period or Time Period per Item
  • Drill-Into the underlying data for Full Examination Once you have the Summary, you can “double-click” on a number and open a view of ALL of the underlying data There is a limitation to the number of Fields you can drill into (255), however there is a “Data Grouping Tool” which allows an administrator to set the Fields to those fields that are most appropriate and actually contain relevant data
  • When you get a Pivot Table the way you want it, you can “Copy and Save-As” so that the work in Filtering & Sorting need not be lost, allowing you to create your own Workbook or set of Workbooks that you can re-use (because the Link to the Data Warehouse is preserved).

  • A Data Warehouse is basically a Copy of your ePCR data which includes “Metrics” – pre-calculated additional fields that make the data more useful.
    • True Date-Time Fields (ePCR stores dates in one field and times in another field making time calculations difficult)
    • Pre-Calculated “Time Segments” (no need to add formulas to the data)
    • All Codes are translated to their “English counterpart”
    • Updated automatically every night
    • NO CHANGES MADE to the ePCR Database

  • To rearrange the worksheet, simply drag and drop column headings to a new location on the worksheet, and Microsoft Excel crunches the data accordingly. The diagram below depicts the “All Incidents” PivotTable and highlights its moveable elements as well as the “Refresh Data” buttons. (note: Do NOT “Refresh ALL” as this will load data from the SQL Server into ALL Pivot Tables; choose “Refresh” only on individual Pivot Tables.)