Hello,
BACKGROUND!:
I'm currently working as a BI/DE developer for a big Telco company (1000+ employees/1+ billion reve.), where we are in the process of having to document our data assets, from data source/Data Warehouse to BI assets!
Tooling!:
Currently we're a heavy microsoft customer. doing most of our DE/BI with on-prem microsoft solutions. Powershell scripts/SSIS for integration tasks. SQL server for Data Warehouse. SSAS/PBI for BI-solutions.
Question!:
How do you go around documenting your data assets, have you build up your own inhouse-solutions and how do you share this documentation with the users? How do you allow SME(subject matter experts) and Data Stewards to edit and ensure the correct Business glossary and definitions?
Have you worked with dedicated Data Catalogs, such as Qlik data catalog/Collibra/Purview or others? pros/cons of Data Catalogs?
Your experience both good and bad going into Data governance and Metadata management intiatives - What worked and what did not!
Thanks in advance!
