We will explore a methodology for understanding and implementing Data Governance that relies on an ground up approach described by Michael Belcher from Gartner as using ETL and Data Warehouse techniques to build a metadata mart, in order to “boot strap” a Data Governance” effort.
Continue reading →
or Guerilla Data Governance Implementing a Metadata Mart the Road to Data Governance best viewed in PRESENTATION Mode, there is animation. This presentation has narrative, play in presentation mode with sound on. https://onedrive.live.com/redir?resid=E7059817CA5789D0!10028&authkey=!AE6eWl-gzh2mq_M&ithint=file%2cpptx
The key is to link source data in the Enterprise via a Business Vocabulary from MDM to the Source Data Metadata Vocabulary from a Metadata Mart to conform the triples collected internally and externally. Continue reading →
Using Metadata and code generation to programmatically set Validation Stats for all leaf members in an MDS Entity. Continue reading →
New post Kimball ETL (subsystem 1) Data Profiling via TSQL http://bit.ly/LIJksn #dataquality #dataprofiling @sqlservercentrl
I have recently had the opportunity to help in clarifying the issues and techniques in adapting an Agile/SCRUM “in progress” ENTERPRISE Data Warehouse project via the Extreme Scoping methodology from Larissa Moss. Thankfully I have been working with an excellent … Continue reading →
Also there is still time for you to sign up for the SQL Rally in Orlando Fl, I will be presenting “Creating a Metadata Mart with SSIS – Data Governance , Data Profiling & Code Generation” as well as Melissa … Continue reading →
 | John Indelicato on DNA and the concept of MDM(Mas… |
 | Data Profiling and D… on Creating a Metadata Mart via T… |
 | James Searle on Creating a Metadata Mart via T… |
 | irawarrenwhiteside on Creating a Metadata Mart via T… |
| James Searle on Creating a Metadata Mart via T… |
