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
|
Select a BI tool. Currently, the information is shown for: |
Looker
MicroStrategy
Power BI
SSRS-PBRS
Tableau
|
|
| 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 |
| 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 |