Add Maple

AddMaple Glossary

This glossary defines key terms and concepts used throughout the AddMaple platform and documentation.


Core Platform Terms

AddMaple

A browser-based data analysis platform that processes data locally without uploading to the cloud. Uses modern web APIs (File API, Worker API) to read and analyze files directly in your browser.

Project

A workspace containing your dataset and all associated analyses, charts, dashboards, and reports.

Dataset

The raw data file you upload and analyze within AddMaple. Can be CSV, XLSX, SAV, JSON, Parquet, or AddMaple file formats.

Column Store

AddMaple's proprietary data structure designed for fast pivoting, binning, and filtering of data within the browser.


Data Types & Detection

Multiple Choice (MC)

Categorical columns with a limited set of text results. Appears with turquoise bars on the chart dashboard. Used for single-answer survey questions or categorical data.

Multiple Choice Plus (MC+)

Columns where there are multiple results per row. Appears with blue bars. Used for multi-select survey questions, tags, or any data where multiple values can be assigned to one record.

Numeric

Automatically detected numeric data (numbers, currency, percentages). Appears with green bars. AddMaple automatically creates bins/buckets for visualization in histograms.

Opinion Scale

Special detection for opinion scales including both numeric scales (1-10) and text-based answers (Very Important, Somewhat Important, etc.). Allows display of Likert charts.

Date/Datetime

Automatically detected date and time columns. Enables time-based analysis and special date binning features.

Text

Free text answers or responses. Future improvements will include full text search and automated tagging.

Unique

Columns with different values for each row, typically identifiers. Cannot be filtered or pivoted but can be viewed in table or raw data view.

Currency

Automatically detected currency columns with currency symbols. Can be filtered and viewed like numeric columns.

Percent

Automatically detected percentage columns containing numbers followed by "%" signs.


Data Processing & Preparation

Binning

The process of grouping numeric or date values into ranges for easier analysis and visualization.

Number Binning

  • Auto (Freedman-Diaconis rule): Statistically optimal bin width
  • Equal Frequency: Bins with similar counts
  • Fixed Width: Consistent interval bins
  • Custom: Manually defined ranges and labels

Date Binning

  • Auto: Optimal time-based bins
  • Calendar Periods: Year, Quarter, Month, Week, Day, Hour
  • Fixed Intervals: Every X minutes/hours/days/weeks
  • Custom Breakpoints: User-defined date boundaries

Weighting

Applying respondent weights to survey data for more accurate analysis. Adjusts results to better represent target populations when certain groups are over- or under-represented.

Column Grouping

Combining similar columns with overlapping categories to analyze their totals together. Useful for aligning data across similar questions.

Data Cleaning

Process of preparing data for analysis, including merging categories, renaming columns, and handling missing values.


Analysis & Visualization

Pivot/Pivoting

The process of cross-tabulating data by selecting two columns to analyze their relationship. Creates pivot charts and tables showing how one variable relates to another.

Filter/Filtering

Narrowing down your dataset to focus on specific segments or values. Can be applied by clicking bars in charts, using the sentence builder, or from table views.

Aggregation

Summarizing data using statistical measures:

  • Total/Sum: Adding up values
  • Average/Mean: Calculating the mean
  • Median: Finding the middle value
  • Count Unique: Counting distinct values

Chart Dashboard

The main interface showing all your data as interactive charts. Each column type appears with color-coded tiles (turquoise for MC, blue for MC+, green for numeric, etc.).

Pivot Chart

Interactive charts created when you pivot two columns together. Show relationships between variables with statistical summaries.

Likert Chart

Special chart type for opinion scale data, showing responses in a scale format. Created by pivoting opinion scale columns or grouping similar columns.

Histogram

Chart type for numeric data showing the distribution of values across bins or ranges.

Horizontal Bar Chart

Default chart type for categorical data, showing categories as horizontal bars with values.

Box Plot

Statistical visualization showing quartiles, median, and outliers for numeric data.

Scatter Plot

Chart showing relationship between two numeric variables, often with regression lines.


Statistical Analysis

Chi-Square Test

Statistical test determining significant relationships between two categorical columns. Provides p-value, Cramér's V (relationship strength), and chi-square statistic.

T-Test

Statistical test comparing means between two groups. Automatically performed when pivoting a numeric column with a categorical column having exactly 2 categories.

Correlation

Measures relationship strength between two numeric variables:

  • Pearson Correlation: For normally distributed data
  • Spearman Correlation: For non-normally distributed data

Regression Analysis

  • Linear Regression: Relationship between numeric variables
  • Logistic Regression: Relationship between numeric and binary variables
  • Multivariate Regression: Planned future feature

ANOVA (Analysis of Variance)

Statistical test comparing means across multiple groups.

Kruskal-Wallis Test

Non-parametric alternative to ANOVA for non-normally distributed data.

P-Value

Statistical measure indicating the probability that observed relationships are due to chance. Lower values indicate stronger evidence of real relationships.

Effect Size

Measures the practical significance of statistical relationships:

  • Cramér's V: For categorical relationships (0-1 scale)
  • Cohen's d: For mean differences

Dashboard & Reporting

Dashboard

A collection of pages containing charts, text, images, and KPIs arranged for storytelling and sharing findings.

Page

Individual canvas within a dashboard containing various items. Tabs can be reordered by dragging.

Item Types

Components that can be added to dashboard pages:

  • Text: Written content
  • Section: Content dividers
  • Call Out: Highlighted information
  • Image: Visual content
  • Video: Video content
  • Charts: Saved analyses from My Collection

My Collection/Insights

Storage area for saved charts and notes. Items can be organized into Collections and added to dashboards.

Collections

Folders for organizing Insights by theme (e.g., "Q3 Feedback", "Launch Readout").

Report

Document containing selected charts and analyses for presentation or sharing.

Publishing

Making dashboards publicly accessible via shareable links. Can include password protection and explorable data options.

Explorable Data

Feature allowing dashboard viewers to interact with underlying data by exploring selected columns.

Public Link

Shareable URL for published dashboards that can be accessed without AddMaple accounts.


Text Analysis & AI Features

AI Summary

Automated analysis of text columns using AI to generate summaries of responses. Processing time varies by dataset size.

Thematic Coding

Process of categorizing text responses into themes or codes for analysis. Can be done manually or with AI assistance.

AI Chart Explanation

AI-powered summaries explaining what current charts show and their key insights.

Clean with AI

Automated feature for cleaning, renaming, ordering, and merging categories in legends.

Text Search

Feature for filtering text responses by specific words or phrases.


User Interface Elements

Sentence Builder

The top black menu bar that displays applied filters and pivots in plain English. Interactive interface for adding filters, pivots, and aggregations.

Legend

Interface for managing how categories appear in charts:

  • Rename categories
  • Reorder categories
  • Merge categories
  • Assign colors
  • Hide/show categories
  • Toggle between Ordered vs Independent categories

More Menu

Context menu providing additional options for charts, columns, and analyses.

Column Settings

Interface for configuring individual column properties including binning, types, and display options.

Manage Columns

Central interface for configuring all columns in a project, including types, binning, and other settings.

Project Settings

Configuration area for project-wide settings including color presets, weighting, and data management.


Data Views

Graph View

Default view showing all columns as interactive charts on the chart dashboard.

Table View

Tabular display of data with options to add/remove columns, sort, filter, and explore individual rows.

Row-by-Row View

Individual record view showing complete responses with comparison to overall dataset. Useful for reading free-text responses and understanding context.

Raw Data View

Direct display of original data without processing or formatting.


Export & Sharing

Export Formats

  • CSV: Comma-separated values
  • XLSX: Excel format
  • JSON: JavaScript Object Notation
  • Parquet: Columnar storage format
  • AddMaple Fast: Optimized for fast loading
  • AddMaple Compressed: Smallest file size

PowerPoint Export

Export charts and analyses to PowerPoint presentations.

Excel Crosstabs

Export pivot tables to Excel format with proper formatting.

Public Sharing

Sharing dashboards and reports via public links with optional password protection.


Technical Terms

Browser-Based Processing

All data analysis happens locally in your browser without uploading to cloud servers.

File API

Modern web API allowing browsers to read files directly from your computer.

Worker API

Web API enabling background processing for large datasets without blocking the user interface.

Columnar Storage

Data storage format optimized for analytical queries and fast aggregation.

Effective Sample Size

Adjusted sample size accounting for weighting schemes in statistical calculations.

Degrees of Freedom

Number of values free to vary in statistical calculations.

Expected Values

Theoretical counts expected if no relationship existed between variables (used in chi-square tests).

Outlier Handling

Statistical methods for identifying and managing extreme values that might distort analysis.

Welch-Satterthwaite Degrees of Freedom

Method for calculating degrees of freedom in weighted t-tests.

Kish Effective Sample Size

Method for adjusting sample size calculations when using survey weights.


Workflow Terms

Save/Add to Dashboard

Process of saving charts or analyses to My Collection for later use in dashboards.

Swap Columns

Feature allowing you to switch which column is being pivoted vs. which is doing the pivoting.

Related Columns

Columns that AddMaple suggests as potentially related based on data patterns.

Cross-tabulation

Statistical table showing relationships between two categorical variables.

Segmentation

Process of dividing data into meaningful groups for analysis and comparison.

Demographic Analysis

Analysis focusing on population characteristics like age, gender, income, education, etc.

Response Rate

Percentage of contacted individuals who completed a survey or provided data.

Sample Size

Number of observations or responses in your dataset.

Confidence Level

Statistical measure of certainty in results (typically 95% or 99%).


This glossary covers the main terms and concepts used throughout AddMaple. For detailed explanations and step-by-step instructions, refer to the specific user guide sections.