Skip to content
BENIBIX Learn

Analytics & BI

Turning processed data into answers people use · 33 terms

Sort
Compare

Data Analysis

7

Looking at data to answer a question. It runs from a first look at a new file to answers that come in seconds.

Looking at data to answer a question. The answer helps people choose what to do.

The first look at new data. You check its shape, its gaps and its odd values.

Looking at data seconds after it is made. The numbers change as you watch.

Types of Analytics

4

The questions you can ask of data. What happened, why it happened, what comes next and what to do.

Looks back at past data and adds it up. It answers: what happened?

Looks for the cause of a change. It answers: why did it happen?

Uses the past to guess the future. It answers: what will happen next?

Suggests the best thing to do. It answers: what should we do now?

Business Intelligence (BI)

8

Turning warehouse data into dashboards, quick answers and charts people build for themselves.

Data turned into charts, so people can make good calls.

BI Reports

3

The pages where people read their numbers. Live dashboards, fixed reports and charts set inside other apps.

One screen of charts and key numbers. It updates on its own.

A fixed page of numbers, often sent on a schedule. Everyone sees the same page.

Charts shown inside another app. Users do not need to open a BI tool.

Data Exploration

4

Ways to dig into numbers on your own. Make a chart, click into a total, or turn a list into a grid.

People get their own answers from the data. No code, no wait.

A quick, one-time question to the data. You write it on the spot.

Click a total to see the parts under it. Each click goes one level down.

A grid that sums up a long list. The rows and columns are fields you pick.

BI Tools

9

The tools that draw the charts, free and paid, and the languages some of them use to define numbers.

A free BI tool in the browser for charts, dashboards and SQL.

A simple, free BI tool. Anyone can ask the data a question.

A Google BI tool. Data is set out once in code, then all can explore it.

The code that tells Looker what tables, fields and numbers mean.

A free Google tool for building dashboards in the browser. It was called Looker Studio.

A BI tool where you drag fields onto a canvas to make charts.

Microsoft's BI tool. Reports sit on a model, with sums written in DAX.

The way to write sums and counts in Power BI.

A Microsoft tool in Excel and Power BI that gets and cleans data. It saves each step.

Semantic Layer

3

One place where each business number is defined, so every tool gives the same answer.

One place that sets the rule for each number. Every tool gets the same answer.

A number you add up or count, like revenue. You split it by dimensions.

Totals worked out ahead of time, for each mix of a few fields.

Query Engines

6

Software that runs SQL on data kept somewhere else, from big shared engines to one on a laptop.

A tool that runs SQL on data kept somewhere else.

A free tool that runs SQL on many data sources at once.

The SQL engine built at Facebook. Trino was split from it.

An AWS service that runs SQL on files in S3. You pay for the data each query reads.

A small database for sums and counts. It runs inside your own program.

One SQL query that reads from more than one system.