Business Glossary tools for Google Big Query

List of tools that help build, maintain an share business glossaries.

Business Glossary is a collection of definitions and terms used within a business unitorganization. It is not used to define data, but rather to define what a particular term means from a business perspective. The definitions are mapped and logically linked to entities in the database. This enables structured communication between teams and allows them to reveal potential errors resulting from incorrect nomenclature.

Dataedo

Dataedo Business Glossary tool provides glossary of business terms, their definitions, relationships between each other and mapping to data assets elements. It allows creating different types of terms, such as term, category, policy and rule. Using Dataedo Business Glossary you can define relationships between terms, categories, rules and policies in the catalog.

Data Policies and Rules: Yes
Export: HTML,MS Excel,PDF
Integration with Technical Metadata: Yes
Linkage to reports/apps: Yes
Reference data: Yes
Support for workflow: Yes
Dataedo Business Glossary
Dataedo Business Glossary Table View
Dataedo Business Term

Informatica Enterprise Data Catalog

Informatica Enterprise Data Catalog allows to add rich business context to the data by associating business terms with the right technical metadata. It enables automatic association of business terms with the technical metadata, which helps eliminate a tedious manual process for data governance. This allows business and IT stewards to collaboratively manage business metadata that includes efficient human workflow automation.

Data Policies and Rules: Yes
Export: CSV,MS Excel,Plain text,XML
Integration with Technical Metadata: Yes
Linkage to reports/apps: Yes
Reference data: Yes
Support for workflow: Yes

Alteryx Connect

Alteryx Connect is one of a kind of data governance and collaborative exploration platform for data asset discovery, sharing, and validation. It can be used as an enterprise business glossary where you define your standard business terms in a data dictionary and link them to assets in the data catalog so that context and meaning of assets are consistent across teams with a common vocabulary.

Data Policies and Rules: Yes
Export: CSV,MS Excel,PDF
Integration with Technical Metadata: Yes
Linkage to reports/apps: Yes
Reference data: Yes
Support for workflow: Yes

OvalEdge

OvalEdge is a data governance tool that allows to build a business glossary and define data quality rules. It enables to manage data access through policies, controls, and workflows.

Data Policies and Rules: Yes
Export: -
Integration with Technical Metadata: Yes
Linkage to reports/apps: Yes
Reference data: Yes
Support for workflow: Yes

Alation Data Catalog

Alation’s Business Glossary enables the creation of definitions, policies, rules, and KPIs through a rich, user-friendly interface. By leveraging machine learning, Alation’s Business Glossary automatically suggests business terms, identifies stewards and subject matter experts based on usage patterns, and incorporates crowdsourcing and collaboration to easily scale documentation.

Data Policies and Rules: Yes
Export: MS Excel
Integration with Technical Metadata: Yes
Linkage to reports/apps: Yes
Reference data: Yes
Support for workflow: Yes

Atlan

Atlan Business Glossary allows data producers and consumers in an organization to create a living tribal knowledge network across all of their data assets. Powered by a knowledge graph, Atlan allows users to define business terms, categories, policies, relationships and more. Atlan's machine learning based bot ecosystem automates several repetitive tasks associated with maintaining a business glossary such as auto tagging business glossary terms to data assets, propagating classification and glossary tagging rules via lineage, bulk associate glossary terms to data assets via an API and more. Its easy to use google like search interface makes it easy for business users to find the meaning of business terms within seconds while ensuring the compliance of business metadata across the enterprise.

Data Policies and Rules: Yes
Export: -
Integration with Technical Metadata: Yes
Linkage to reports/apps: Yes
Reference data: Yes
Support for workflow: Yes

Select Star

Select Star has a metrics feature that allows you to define key terms and values based on data that aim to answer specific business questions. Select Star can automatically detect dimensions that you may want to group or pivot on, but you can remove these if desired or search for others.

Data Policies and Rules: No
Export: CSV,JSON
Integration with Technical Metadata: Yes
Linkage to reports/apps: Yes
Reference data: Yes
Support for workflow: No

There are many tools for creating business glossaries. Whether sophisticated or not, they allow to create:
• access and alternate names,
• descriptions,
• explanations of how to calculate metrics,
• links to other elements.

To ensure access to all terms from different platforms, many business glossary tools are cross-platform compatible. More advanced tools provide a workflow to ensure that term definitions are updated and approved. In addition to the glossary creation features, the tools allow you to export to user-friendly and easy-to-share formats like PDF and HTML.

Proper communication between teams in an organization is crucial for the success of the project. Similarly, it is important to interpret data correctly. Each of the teams working together (business team, developers, marketing teams), use different nomenclature and terms. Within a team the logical meaning of data elements, acronyms, etc. are defined and understood only by a narrow group of members. This makes the area of inconsistency really wide. Even small misunderstandings can lead to fatal consequences. This is where the business glossary comes into play.

What's more, using glossaries not only makes the communication more reliable, but also improves efficiency and speeds up the decision-making process (e.g. wondering if "customer" means a single person, an organization, and repeating the consideration next time the project is approached).

In our list, we have included noteworthy business tools for creating and reviewing business glossaries.