Intelligo Feature Overview

Workbook

Data

Import raw data from SPSS, Excel, CSV etc.

Connect directly to SurveyMonkey and Alchemer

Import/Merge multiple Datasets

Explore & Discover: Quick data overview incl. significance

Data Editor

Variable View & Data View

Recode Variables

Search & Replace Text

(Un)hide Variables

Create Aggregate Variables

General

All Excel functionality as an integrated part of the reporting

Crosstabs / Banner Tables

All Basic Statistics (incl. Confidence interval, Chi Square & Median)

NPS & Top/Bottom N

Advanced Sorting (Rows & Columns)

Z-Test (Column Proportions)

Student's & Welch's T-Test (Column Means)

Low Base notification: 2 levels by optional characters

Weighting

Grid Tables (containing many variables)

Productivity

Create Many Tables in one step

Copy/Paste Tables

Copy/Paste & Filter Worksheets

Refresh Worksheet / Refresh Report

Mass-Edit Tables

Advanced

Filtering on 3-levels (Report & Table & Table Column)

Ignore Filters (from other levels)

Create Weighting Variables (RIM)

Correlation

Pairwise Sig Test: Show significance as font- or background-color

Second Pairwise Sig Test in same table

Sort Table Like (another table or range)

Report Automation

3 'Hierachy' Report Filters (for tracking surveys and generating many reports)

"Compset" functionality (International Brand Comparison)

Save Report as a Template

Generate Reports (using different filters, 3 'hierarchy' levels available)

MS Office VBA-Macro Integration

Presentation

PowerPoint Shapes

Link fill and font colors from the Excel range (use Excel's Conditional Formatting)

Text-to-Image

Customizable Infographics

Sliders

Filled Shapes

Conditional Shapes (e.g. Smiley)

General

Slide Library

Automatically create and attach a worksheet for every utilized slide

Generate "Table of Contents" Slide(s)

Interactive Filters

Dropdown Filters for 'Slide Show'

Slicer Filters for 'Slide Show'

PowerPoint Tables

Automatic adjustment of number of rows and columns based on selected Excel range

Link fill and font colors from the Excel range (use Excel's Conditional Formatting)

Color-Driven Icons based on Excel fill or font color

Text-to-Image

Switch row/column

Hide 'Zero Values' in tables and charts

Efficiently display long lists across multiple slides

Automatically remove 'zero' rows and/or columns

Report Automation

Copilot - Populates tables and chart on many slides using your specifications

Utilize 'dynamic' links: automatically adjust the linked number of rows and columns from Excel area

Automatically 'refresh' the entire presentation with data from another workbook

Generate Reports (controlled by 3 'Hierarchy' filters)

MS Office VBA-Macro Integration

PowerPoint Charts

Chart Types: Rotated Line, Quadrant, XY, Diverging Bar

Automated labeling for XY-charts, inside the chart or adjacent table

Color-Driven Icons based on Excel fill or font color

Text-to-Image

Switch row/column

Hide Zero Values

'Sticky' colors: Maintain consistent e.g. brand colors, even after sorting

Table-based Axis Text Display with text formatting and alignment

Automatically remove 'zero' rows and/or columns

Reorganizing Data in Excel

Linked Range - Links directly to the needed data

Lookup Range - Text search to find a range

Lookup Table - Text search to find specific cells