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!
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.)