Import

Import
  • Import Excel data

  • Import SPSS data

  • Import TripleS data

  • Import multiple datasets

  • Merge datasets

  • Connect to SurveyMonkey Survey

  • Connect to SurveyGizmo Survey

Variables

Variables
    • Category variables
    • Numeric variables
    • Date variables
    • Text variables
    • Derived Variables: Create intervals, combine categories using and/or/not etc.
    • Advanced Formula Editor

Data View

Data View
  • View data in a grid (like Excel)

  • Edit data

  • Filter data for better overview

  • Sort data for better overview

  • Export raw data to Excel

  • Export raw data to SPSS

Tables

Tables
    • Observations, Percent or both
    • Grid tables with observations, percent or mean
    • Base, Total, Mean and Std. deviation
    • Multiple banner variables & Grand Total
    • Benchmarking
    • Filtering
    • Significance tests
    • Ignore report filter
    • Weighting
    • Top/Bottom Box (NET)
    • Top/Bottom N reporting
    • Customized table layout (see Layout)
    • Edit defined table

Charts

Charts
    • Observations, Percent
    • Base, Total, Mean and Std. deviation
    • Gridcharts with observations, percent or mean
    • Benchmarking
    • Filtering
    • Significance tests
    • Ignore report filter
    • Weighting
    • Top/Bottom N reporting
    • Customized chart layout (see Layout)
    • Edit defined chart

Advanced Statistics

Advanced Statistics
  • Define benchmark variables

  • Calculate respondent weights. OfficeReports uses RIM weighting, and can weight over many dimensions

  • Weight tables/charts using weights calculated by OfficeReports or by imported weights

  • Create frequency tables with confidence interval

  • Chi Square

  • Z-Test (Column Proportions)

  • T-Test (Column Means)

  • Choose which columns to compare (T-Test;Z-test)

  • Custom Significance characters/colors (T-test;Z-test)

  • Set minimum base for testing

  • Correlation

Layout

Layout
  • Define your own table and chart types

  • For tables: define lines, colors and fonts

  • For charts: use Excel chart templates

  • Use Macros (can also change content of table/chart!)

Collaborate

Collaborate
  • Just email the files to colleagues. It will work.

  • Use a SharePoint or a shared network drive

Reuse the report definition

Reuse the report definition
    • Define a report filter
    • Generate many reports using different filters
    • Save report as a template

Productivity

Productivity
    • Insert many tables and charts in one step
    • Create a complete 'Analytics Report' in seconds
    • Create new table/chart using settings from the last defined one
    • Just Copy and Paste a table/chart and edit it.
    • Reuse the report (See above)