In many companies, data governance begins with a focus on roles and responsibilities.
Critical data assets, such as the Business Data Glossary, are captured in the easiest available tool, such as Excel.
At some point, the limitations of these “repositories” will show you that it’s time to move on to a better option.
1. You don’t know who is adding, updating or commenting on terms and definitions.
Data governance is a collaborative process and all stakeholders must be able to contribute to build a common enterprise glossary.[Tweet this]
How do you manage who is able to add, modify or otherwise contribute to a term? How do you keep track of who has made which changes? Who is responsible for the final approval and how do you stop changes being made to a definition once it is signed off?
2. Changes and comments are being lost
If multiple stakeholders are updating the same document then it is possible that one person may overwrite the changes made by another. In some cases, this may result in critical commentary being lost or ignored.
All versions of changes and comments must be kept in order to get the correct definitions for your business
3. Cannot link to other data assets, such as logical data model.
Glossaries offer the most value when placed in context. What database fields are used to derive calculation X? Who are the business stakeholders that must be consulted regarding changes to definition A? Does the same terms have different definitions (and uses) in different environments?
Modelling the complex, and varied, relationships between terms and their use requires a more sophisticated, semantic model
4. Approvals and inputs are getting lost in email
Are multiple stakeholders updating the spreadsheet and sending versions to the data steward for consolidation? Which is the most current version? Did a version get lost in the email? Did it get sent to the right person for approval? How long ago? Does the data steward have time to figure this all out?
Simple workflows make adding, consolidating and approving new terms quick and easy. The correct stakeholders are engaged at the right times to ensure user engagement and support. No wasting time and no frustration for anybody.
5 The Business Data Glossary is “cocooned”
A business data glossary is a living document that should be used within the organisation
.For example, business requirements documents should use the correct terms, as per the agreed definitions. For this to happen, business analysts and other users must easily be able to search for, find and embed terms in their documents.
Should we be engaging with a client, or a customer? Is there a difference? If it’s not clear, who can I ask?
Excel is not a searchable knowledge base.
If you are ready for your business glossary to become a valuable asset for your business, then you have outgrown Excel.[Tweet this]
Watch the short video to see how you can move from Excel to Business Data Glossary quickly and easily