Big Data

Mini-glossary: Business intelligence and analytics terms you should know

These 21 terms are essential to learn if your IT job requires you to work with BI or analytics.

Image: iStock

Business intelligence (BI) and data analytics give tech decision makers a clearer idea of how well their companies are running, and if they are meeting goals. Some business users struggle to understand how BI and analytics work in concept and in practice. These 21 terms should be in every BI or data analyst's vocabulary.

SEE: Mini-glossary: Big data terms you should know

Ad Hoc Query

The ability to create a one-off, "on demand" report from BI or analytics software that answers a specific business question.

Anonymization

The severing of links between people in a database and their records to prevent the discovery of the source of the records, and to maintain privacy and confidentiality.

Behavioral analytics

Using data about people's behavior to understand intent and predict future actions.

Balanced Scorecard

A performance management tool that holistically captures an organization's performance from several vantage points (e.g., sales results vs. inventory levels) on a single page.

Contextual data

A structuring of big data that attaches situational contexts to single elements of big data to enrich them with business meaning (e.g., instead of a customer record that tells you the customer's name and address, data appended to this record data also gives the customer's buying preferences, which is gathered from recent web activity data). The result is a more complete understanding of the customer and her lifestyle.

Database

A collection of data arranged for convenient and quick search and retrieval by applications and analytics software.

Data broker

A business that collects personal information about consumers and sells that information to other organizations.

Data mart

A small data repository that is focused on information for a specific subject area of the company, such as Sales, Finance, or Marketing.

Data model

A data model is the result of a collaborative effort between end business users and IT database analysts. The first step is to define in plain English what data the business needs in order for its various functions to communicate with each other, and how this data must be ordered and structured so it makes the most sense. The second step is for the data analysts and other IT staff to devise a technical data base, a data storage and security plan, and a plan that enables application and analytic report development using this data. Together, these processes result in a data model for the business.

Data point

An individual item on a graph or a chart.

Data visualization

A method of putting data in a visual or a pictorial context as a way to assist users in better understanding what the data are telling them (e.g., a map is a way to visualize which areas of the country get the most rainfall).

Data warehouse

A data repository that deals with multiple subject areas (or data marts).

Filter

A mechanism that includes or excludes specific data from reports based upon what the user decides to filter (e.g., to tightly tailor a report, you might strictly want records of customers between the ages of 25 and 35 who like skiing, but you want to exclude everyone else).

Gap analysis

A study of whether the data that a company has can meet the business expectations that the company has set for its reporting and BI, and where possible data gaps or missing data might exist.

Key performance indicator (KPI)

A metric a business measures its progress against when performing BI analytics to determine whether it is meeting its goals. The results are reported in the form of a dashboard or a scorecard report that enables executives, managers, and employees to assess performance, and whether a given goal (or metric) is being met, exceeded, or missed.

Metadata

Data that gives information about what the primary data is about (e.g., if a photo is the primary data, its metadata might consist of what its resolution is, when the photo was taken, etc.).

Metrics

Measures of performance that observe progress and evaluate trends within an organization.

Multipolar analytics

A distributed big data model where data is collected, stored, and analyzed in different areas of the company instead of being centrally located and analyzed.

Schema

The structure that defines the organization of data in a database.

Slice and Dice

Data manipulation tools in reporting or spreadsheet software that allow users to view data from any angle.

Snapshot

A view of data at a particular moment in time.

Also see

About Mary Shacklett

Mary E. Shacklett is president of Transworld Data, a technology research and market development firm. Prior to founding the company, Mary was Senior Vice President of Marketing and Technology at TCCU, Inc., a financial services firm; Vice President o...

Editor's Picks

Free Newsletters, In your Inbox