EventStats Quick Start

A quick introduction to importing and analysing a CSV file in EventStats.

Importing a CSV Data File

Click the Import CSV... button which opens the Import CSV File wizard

Click the Open CSV File button and select your data file. EventStats will analyse the first 200 rows and present you with the column structure and the sample data it used.

You must now modify the Column Definitions to tell EventStats where the data is:

• Record Key: this is the field that uniquely defines every record in the data file.
  • Enter a Y is the Is Key column on the appropriate row.
• Group Name: enter a name that will identify that this column is to be used for your analysis groups or for data filtering.
  • Enter the name directly in the Group column
  • You can specify as many groups as you want
  • The name can be the same as the column name.
  • You must use a different name for each Group column
• Date index: enter a numerical value to identify this field as a date field in the Date index column.
  • Odd numbers are start dates, even numbers are end dates.
  • Pair dates together by using consecutive numbers: 1&2,3&4,5&6 and so on. e.g. If Admission Date is date index: 1, Discharge Date is then naturally date index 2.
  • Multiple pairs of dates can be specified - you can choose which to analyse in the next step.
  • To specify a single date field, just give it the next available odd number & do not allocate the even number to any field.

Example configuration:

Note: Click on the Field Name or Data Type cells to open a window where you can change the field name, data type and all the other properties listed above.

Finally click, OK to actually import the CSV file.

Running Analysis

With the data file loaded, you can now specify your analysis parameters.