Did you ever see different reports or charts showing same metric (or called the same) that showed completely different values or even trends? I did, quite often. Why is that so? Well, there are many reasons but let me narrow it down to 2:
Lack of common understanding of business concepts - you can solve it with a Business Glossary, a common vocabulary with precise definitions,
Lack of understanding of data and its logic (calculations, relationships, etc.) - and you can solve it with a Data Dictionary.
You can build both artifacts in one catalog and share in one UI - using Dataedo.
Do you know this that feeling of guilt that after phase of the extensive analysis, design, and implementation, you apply last minute changes or fixes without a trace in the documentation?
Team spent countless hours on documentation of requirements and the design, and just like that it becomes out of date and loses its value. And only because there was no time, budget, processes in place, or someone was just lazy.
Do you know that feeling that after a while of the release you have no idea how this system is supposed to work?
Well, the solution is quite simple, and yet so hard: keep your documentation up to date whenever system changes. Easier said than done.
Do you feel that data is locked out somewhere in your organization for the selected few? That is normal. That is how things were historically. Only a few architects, developers, admins and analysts had the access to the data. Now, things are changing with the advent of Data Democratization, Self-Service Analytics, Data Catalogs that help open that closed doors and make data clubs more inclusive.
Is IT a bottleneck in your reporting and analytics? Do you need to wait in line before you could get this data or report? If so, then your organization cannot utilize data fully for insights and efficiency.
A solution is building of data literacy and promotion of use of data in a business community so they do not need help to access and get value out of data. You can do this with self-service BI or analytics tools, providing access to databases and promotion of SQL, and implementation of data catalogs – an inventory and documentation of your data.
Is your data in your organization guarded against business users by the IT? No worries, there’s always a secret path in the mountains. That path has many names - data catalog, metadata repository, data dictionary or database documentation. What ever you call it – give your business a map to the data.