Latest Post:

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

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

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

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.