BI tool terminology

The following tables show the supported BI tool terminology and corresponding asset types and terminology in Collibra Data Intelligence Platform.

Note Keep in mind, it is possible that your organization has renamed the out-of-the-box asset types.

Steps

Tip 

Select a BI tool.

Currently, the information is shown for:

 

X
Tableau term Description Collibra equivalent

Site

A site is a stand-alone collection of content, such as projects, workbooks and users. Each site has its own URL and its own set of users.

Subcommunity and Tableau Site asset

Project

A project organizes related content resources. Content resources are workbooks, views and data sources.

Tableau Project asset

Workbook

A workbook is a collection of views.

Tableau Workbook asset

Dashboard

A dashboard is a collection of views from multiple worksheets.

Tableau Dashboard asset

Worksheet

A worksheet contains a single view, along with shelves, legends, and the Data pane.

Tableau Worksheet asset

Tableau data source

Tableau Data Sources consist of metadata that describe the connection information, information about how to access or refresh the data and customizations.

Tableau Data Model asset

Dimension

Dimensions contain qualitative values (such as names, dates, or geographical data).

Attribute type Role in Report on a Tableau Data Attribute asset page

Measure

Measures contain numeric, quantitative values that you can measure.

Attribute type Role in Report on a Tableau Data Attribute asset page

Tableau data attribute

Tableau Data Attributes define a property of a Tableau data entity.

Tableau Data Attribute asset

Tableau data entity

Tableau Data Entities are an abstraction of the physical implementation of database tables, used for Tableau report creation.

Tableau Data Model asset

Tableau data model

Tableau Data Models are an abstraction for the physical implementation of databases, schemas, files, etc., used for Tableau report creation.

Tableau Data Model asset

Tableau server

A Tableau server is a server on which Tableau users can publish data sources, as a means to share the data connections they've defined.

Tableau Server asset

Published versus embedded data sources

You can create data sources in Tableau when you connect to data. After you set up the data sources in Tableau, you can publish data sources as standalone resources, or you can publish workbooks with the data sources embedded in.

Unless you take actions to publish the data source separately, the data source is published as embedded in a workbook by default. For more information, see the Tableau documentation on Publishing data separately or embedded in workbooks.

Collibra Data Lineage ingests metadata of data sources as assets of the Tableau Data Model asset type, regardless of the way the data sources are published.

eTDM and pTDM

When you ingest a Tableau data source in Collibra, each asset is identified as eTDM or pTDM with [eTDM] or [pTDM] added to the asset name.

eTDM stands for embedded Tableau Data Model, which indicates that the asset represents the data source that is embedded in a workbook in Tableau. pTDM stands for published Tableau Data Model, which indicates that the asset represents the data source that is published separately in Tableau.

For a data source that is both published separately and embedded in a workbook, Collibra Data Lineage ingests the metadata in one of the following ways:

  • If the metadata of the embedded data source matches that of the published data source, Collibra Data Lineage ingests the metadata only from the published data source to avoid duplication.
  • If the metadata of the embedded data source contains more fields than that of the published data source, Collibra Data Lineage ingests metadata from both the published and embedded data sources.

As a result, a Tableau workbook can have one of the following relations:

  • To the published and embedded data source.

  • To the published data source only.

Power BI term Description Asset type in Collibra

Capacity

 A resource that hosts Power BI Workspaces. Power BI Capacity

Dashboard

 A collection of Power BI tiles with metrics from one or more Reports and Data Models.

Power BI Dashboard
Dataflow A collection of tables that are created and managed in workspaces in the Power BI service. Power BI Data Flow
Datamart A self-service analytics solutions, enabling users to store and explore data that is loaded in a fully managed database. Power BI Data Mart

Data Set

 A collection of data that is used to create a Power BI report. Power BI Data Model

Data Set Column

 A column in a Power BI Data Model. Power BI Column

Data Set Table

A table in a Power BI Data Model.

Power BI Table

Report

 A detailed view of a Power BI Data Model, with visualizations of findings and insights. Power BI Report

Server or Tenant

 A visual analytics platform for creating and storing Power BI Reports and Data Models. Power BI Server

Tile

 An element representing data on the Power BI Dashboard. Power BI Tile

Workspace

A collection of Power BI Dashboards, Reports and Data Models.

 Power BI Workspace
MicroStrategy term Description Asset type in Collibra

Attribute / Fact

A detailed view of a MicroStrategy visualization, with findings and insights.

MicroStrategy Data Entity

Attribute Form / Fact expression

Additional descriptive information about an attribute.

MicroStrategy Data Attribute

Column

 A column in a MicroStrategy data model.

MicroStrategy Data Attribute

Dataset

A collection of data that is used to create MicroStrategy reports.

MicroStrategy Data Model

Document

A collection of grid and graph reports that can be viewed at the same time, along with images and text.

MicroStrategy Document

Dossier

A collection of MicroStrategy chapters and pages.

MicroStrategy Dossier

Folder

A collection of MicroStrategy reports and data models.

MicroStrategy Folder

Intelligent Cube

A set of data that can be shared as a single in-memory copy among many different reports created by multiple users.

MicroStrategy Data Model

Project

A collection of MicroStrategy visualizations, report attributes and tables.

MicroStrategy Project

Report

 A detailed view of a MicroStrategy data model, with visualizations of findings and insights.

MicroStrategy Report

Server

 A visual analytics platform for creating and storing MicroStrategy reports and data models.

MicroStrategy Server

Visualization

A visual representation of the data in a dossier, such as a grid, line chart, or heat map.

MicroStrategy Visualisation
Looker term Description Asset type in Collibra
Dashboard

A collection of Looker tiles with metrics from one or more Looker Looks.

 Looker Dashboard
Explore

A collection of data that is used to define Looker Dimensions and Measures.

 Looker Data Set
Dimensions, Measures

An atomic unit of data that is used in a Looker Look or Looker Tile. It represents a column in a Looker Data Set.

 Looker Data Set Column
Folder or Space

A container that stores Looker Looks, Dashboards and other folders.

 Looker Folder
Look

A detailed view of a Looker Data Set, with visualizations of findings and insights.

 Looker Look

Dimensions, Measures

An atomic unit of data that is used in a Looker Look or Looker Tile. It represents the actual use a Looker Data Set Column.

Looker Report Attribute

Query

A query that creates a simple report in a Looker Tile or Looker Look.

Looker Query

Looker instance

 A platform to create Looker Dashboards and rich visualizations. Looker Tenant

Tile or Dashboard element

An element that represents data on the Looker Dashboard.

Looker Tile

Note The SAP Analytics Cloud integration is in beta.

To ingest SAP Analytics Cloud metadata in Collibra Data Catalog, Edge connects to SAP Datasphere Catalog. Therefore, as part of the SAP Analytics Cloud set up procedure, you need to ensure that your SAP Analytics Cloud data is synchronized in SAP Datasphere Catalog. The following table describes the terminology and descriptions of data objects in SAP Analytics Cloud, and the equivalent terminology in SAP Datasphere Catalog and in Collibra Data Catalog.

SAP Analytics Cloud term SAP Datasphere Catalog equivalent Collibra equivalent

Tenant

The actual SAP Analytics Cloud product, either in public or private cloud.

System

When you connect to SAP Datasphere Catalog, you are prompted to specify the system. SAP Analytics Cloud is identified in SAP Datasphere Catalog as the system type.

SAP Tenant

The name of the system that you specify in SAP Datasphere Catalog will be the name of the SAP Tenant in CollibraData Catalog.

Container

  • PRIVATE: A container that stores private data.
  • PUBLIC: A container that stores public data.

Container contains folders.

Container

The folder that contains the SAP Analytics Cloud data.

SAP Datasphere Catalog also shows the paths to the assets in SAP Analytics Cloud.

SAP Container

This is the highest level of the folder structure. It’s either a container or a workspace.
Workspace

Container

The folder that contains the SAP Analytics Cloud data.

SAP Datasphere Catalog also shows the paths to the assets in SAP Analytics Cloud. When the asset is in a workspace, the path starts with "WORKSPACE".

SAP Container

This is the highest level of the folder structure. It’s either a container or a workspace.

Folder

A folder that contains SAP Analytics Cloud data and stories.

Container

A folder that contains SAP Analytics Cloud data and stories.

SAC Folder

Folder structure that is the parent of Story and SAC Data Model assets.
Model
  • Model (planning)
  • Model (analytic)

SAC Data Model

SAC Data Model assets have the attribute Source Type, with one of the following values:

  • Planning
  • Analytic

Story Story SAC Story
  • Measure
  • Dimension
Not applicable

SAC Data Attribute

SAC Data Attribute assets have the attribute Source Type, with one of the following values:

  • Dimension
  • Measure
SSRS-PBRS term Description Asset type in Collibra

Column

 A column in an SQL Server Reporting Services Report Data Set. SSRS Column

Data Set

A collection of data that is used to create an SQL Server Reporting Services Report.

SSRS Data Model

Folder

A collection of SQL Server Reporting Services and Power BI Report Server Reports and Data Sets.

SSRS Folder

KPI

A key performance indicator of SQL Server Reporting Services.

SSRS KPI

Mobile report

 A detailed view of an SQL Server Reporting Services Data Set, with visualizations of findings and insights. SSRS Report

Paginated report

 A detailed view of an SQL Server Reporting Services Data Set, with visualizations of findings and insights. SSRS Report

Parameter

A column that is part of an SQL Server Reporting Services Data Set and that is used in a KPI.

SSRS Parameter

Power BI Report Server report

 A detailed view of a Power BI Data Model, with visualizations of findings and insights. Power BI Report

SQL Server Reporting Services or Power BI Report Server server or tenant

 A visual analytics platform for creating and storing SQL Server Reporting Services and Power BI Report Server Reports and Data Sets. SSRS Server

Table

A table in an SQL Server Reporting Services Report Data Set.

SSRS Table