I am working for a medium sized company that is interested in managing data effectively and building up MDM within the business.
However, the company relies more than any I've ever seen on siloed Excel based data. I've tried to roll out Master Data Solutions as a way of enforcing some governance over the data but due to technical issues with Master Data Solutions and the license that we have/technical constraints meaning that we cannot patch these issues...this tool has not been successful.
What are your experiences of developing a technical solution- bringing together Excel based data in disparate and siloed environments- together enacting both Data Quality rules, Data Governance Standards and centralising data so that it can be analysed by e.g. a BI team?
The knowledge in this forum is exceptional so please share it if you can.