Glossary
Plain-language explanations of data, analytics and security terms. Find out what each term means, why it matters and how it relates to DataMaus.
A
-
Aggregation
Combining multiple records into summary values, such as counts, totals or averages.
-
API (application programming interface)
An interface that lets one piece of software request data or actions from another.
-
API key
A value used by a service to identify an application or account making API requests.
-
App connectors
Built-in connections that pull data from business apps such as Stripe, HubSpot or Google Ads, without a separate data pipeline.
-
Audit logs
A record of who did what in a tool and when: sign-ins, permission changes, queries, exports and edits.
B
-
Business intelligence (BI)
The practices and tools used to turn business data into analysis, reports and dashboards.
C
-
CCPA
California's Consumer Privacy Act, which gives California residents rights over personal data businesses collect about them.
-
CSV (comma-separated values)
A plain-text file format that represents tabular data as records with comma-separated fields.
D
-
Dashboard
A page of charts, numbers and tables that shows the state of something at a glance, usually kept up to date automatically.
-
Data alert
A notification triggered when a metric or query result meets a defined condition.
-
Data model
A representation of how data is organised, related and understood.
-
Data notebook
A document that mixes code (SQL, Python or R), results, charts and written notes in cells, run top to bottom.
-
Data processing agreement
A contract that sets out how a processor handles personal data on behalf of a controller.
-
Data science
A discipline that uses data, statistics and computing to investigate questions and build models.
-
Data source
A database, app, file or dataset that supplies data for analysis.
-
Data warehouse
A data system designed to bring together information for analysis and reporting.
-
Database connectors
Built-in connections that let an analytics tool query your databases and data warehouses directly.
-
Dimension
An attribute used to group, filter or describe measurements, such as country, product or month.
E
-
ELT (extract, load, transform)
A data integration process that loads extracted data before transforming it in the destination.
-
Embedded analytics
Putting charts or dashboards from an analytics tool inside another website or app, often your own product.
-
ETL (extract, transform, load)
A data integration process that extracts data, transforms it, then loads it into a destination.
-
EU data residency
Storing data in data centres within the European Union.
G
-
GDPR
The EU's General Data Protection Regulation, which sets rules and rights for the processing of personal data.
H
-
HIPAA
US rules for protecting certain health information handled by covered entities and their business associates.
I
-
Incremental sync
Updating a stored data copy using changes since the previous sync, rather than importing everything again.
-
ISO 27001
An international standard for establishing, maintaining and improving an information security management system.
J
-
Join (SQL)
An operation that combines rows from tables according to a matching condition.
K
-
Key performance indicator (KPI)
A metric selected to show progress towards a specific business objective.
M
-
Metric
A defined measurement used to describe or track something in your business.
N
-
Natural-language querying
Asking questions about your data in plain language and getting an answer, table or chart back, without writing a query.
-
No-code query builder
A visual way to build queries by choosing fields, filters and groupings instead of writing code.
P
-
Public dashboard
A dashboard published for people to view without signing in to the analytics tool.
Q
-
Query caching
Storing a query result so it can be reused without running the same query again.
R
-
Row-level security
Rules that limit which rows of data each person can see, so one dashboard shows different people only their own data.
S
-
Scheduled refresh
Rerunning queries or syncing data automatically on a schedule, so dashboards stay up to date.
-
SCIM
A standard for automatically creating, updating and removing user accounts in a tool from your identity provider.
-
Self-hosting
Running an analytics tool on your own servers or cloud account instead of using the vendor's hosted service.
-
Semantic layer
A shared layer of business definitions (metrics, dimensions, relationships and descriptions) that sits between raw data and the people or AI asking questions.
-
Single sign-on (SSO)
Signing in to a tool with your company's identity provider, such as Okta, Microsoft Entra ID or Google Workspace, instead of a separate password.
-
SOC 2
An independent audit report on how a company protects customer data, based on the AICPA's Trust Services Criteria.
-
Spreadsheet
A grid of cells used to organise data, calculate values with formulas and create charts.
-
SQL (structured query language)
A language used to define, query and work with data in relational databases.
-
SQL editor
A place in a data tool to write, run and save SQL queries against your databases.
T
-
Text-to-SQL
AI that turns a plain-language question into a SQL query that runs against your database.
V
-
Version control
Tracking changes to work over time so earlier versions can be inspected, compared or restored.
No matching terms. Try another word or abbreviation.