Data in OfficeReports

The example dataset

The manual repeatedly refers to an example dataset so we are able to provide examples throughout the manual.

The dataset covers dummy data from an Employee Satisfaction Survey conducted which contains:

  • A number ordinal scale questions containing categories from ‘strongly disagree’ to ‘strongly agree’
  • A number of nominal scale questions as ‘Gender’, ‘Department’, and ‘Team’, each containing a number of categories.
  • A number of numeric questions as ‘Age’, ‘Working hours’ etc. which contains numerical data.
  • Open ended questions containing open ended text
  • Date variable


Throughout the manual, we will strive to relate closely to the example data and the many practical issues which pop up when analyzing and reporting this type of data. In general, we will always try to relate to the researchers situation and keep the manual as non-technical as possible.

The example dataset can be downloaded from our homepage in both SPSS and Excel format: Download example dataset

The OfficeReports Database

OfficeReports Analytics works with raw data, which can be imported from different data sources like SPSS and Excel. On import, OfficeReports stores the data in its own database in a format that is optimized for fast calculation of tables and charts. The database is saved in the same folder with the same name as the workbook (or presentation) you are working on:

If you want to make a backup, you need to backup both files!

If you want to continue working in another folder or on another workstation, you need to move or copy both files!

When you open a workbook with OfficeReports data, OfficeReports will create a copy of the database and add the ‘~’ character in front of the name:

This is the database OfficeReports will be using, and every time you save the workbook, the original database is overwritten. In case the workbook is not closed properly (crash, power failure, network problems etc.), OfficeReports is able to see that and will ask you if you want to use the ‘unsaved’ database.

In case you want to work in a new location, but forget to copy the database as well, OfficeReports might be able to see that as well. OfficeReports checks if there are tables in the workbook, which are not defined in the database, and OfficeReports checks if the timestamps from the workbook and the database are not too much different. In case there might be a problem OfficeReports will give you a warning, and will let you know how you can solve it.