Category Archives: Metadata Mart

DNA and the concept of MDM(Master Data Management) have many similarities. 

Posted on May 7, 2017 by

Apply the science of DNA to Business MDM Continue reading →

Posted in agile, Data Governance, data profiling, data quality, data quality mart, Dna, Download Complete Data Profiling Kit - TSQL, Fuzzy Matching, Guerilla MDM, Mdm, Metadata Mart, Uncategorized | Tagged , , , , , , | 1 Comment

Organic Data Quality vs Machine Data Quality

Posted on December 18, 2014 by

Awarement of data quality issues is business as usual, awarement of specific data quality is enlightenment. Continue reading →

Posted in Awarement, Data Governance, data profiling, Download Complete Data Profiling Kit - TSQL, Fuzzy Matching, Guerilla MDM, Metadata Mart | Tagged , , | Leave a comment

Metadata Mart the Road to Data Governance

Posted on December 9, 2014 by

 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

Posted in Data Governance, data profiling, Dimensional Model, ETL, Guerilla MDM, Kimball ETL (subsystem 1), Metadata Mart, Uncategorized | Tagged , , , | 2 Comments

Self Service Semantic BI (Business Intelligence) Concept

Posted on December 8, 2014 by

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 →

Posted in Big Data, Data Governance, data profiling, ETL, Mdm, MDS, MDS Stored Procedures, Metadata Mart, Self Service Semantic BI, SSIS | Tagged , , , , , , , , , | Leave a comment

Mastering Microsoft SQL Server tools required for EIM (MDS, DQS, Profiling and SSIS) – Complete Kit

Posted on April 23, 2014 by

  Overview   Understanding and mastering the various Microsoft SQL Server Tools available for Data Quality , Master Data Management , Fuzzy Matching and Enterprise Information Management can be daunting and exasperating. In the hopes of reducing the anxiety and … Continue reading →

Posted in data profiling, ETL, Extreme Scoping Agile SCRUM, Fuzzy Matching, Mdm, Metadata Mart, SSIS, Uncategorized | 1 Comment

Guerilla MDM via Microsoft MDS: Force Model Validation or TSQL Script to force set Validation Status ID ‘s

Posted on December 30, 2013 by

Using Metadata and code generation to programmatically set Validation Stats for all leaf members in an MDS Entity. Continue reading →

Posted in agile, Awarement, Computers and Internet, data profiling, Ira Whiteside, Mdm, MDS, MDS Stored Procedures, Metadata Mart, Table Variable TSQL | Tagged , , , , , , , , | 1 Comment

Agile MDM Data Modeling and Requirements incorporating a Metadata Mart.(Guerilla MDM)

Posted on September 27, 2013 by

Recently an acquaintance of mine asked about my thoughts on the approach for creating a MDM data model and the requirements artifacts for loading MDM. I believe with this client and with most clients that the first thing that we … Continue reading →

Posted in agile, Awarement, Big Data, data profiling, extreme scoping, Mdm, Metadata Mart | Leave a comment

Fast, Data Driven Netezza Load – The Prittie Good Approach

Posted on November 28, 2012 by

A few years ago I have a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would … Continue reading →

Posted in Big Data, data profiling, ETL, Metadata Mart, SSIS | Tagged , , , , | Leave a comment

Microsoft BI Stack Leveraged with Vendor Add – In’s for Data Quality and Data Lineage.

Posted on October 24, 2012 by

Lineage as it applies to data in Business Intelligence provides the capability see track back where data came from. Essentially it supports “Metric Decomposition” which is a process for breaking down a metric (business calculation) into separate parts. With this capability you can determine your data’s ancestry or Data DNA. Continue reading →

Posted in Awarement, Computers and Internet, data profiling, Donal Farmer, Extreme Scoping Agile SCRUM, Fuzzy Matching, Ira Whiteside, Kimball ETL (subsystem 1), MelissaData, Metadata Mart, SSIS, Uncategorized | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

New post Kimball ETL (subsystem 1) Data Profiling via TSQL http://bit.ly/LIJksn #dataquality #dataprofiling @sqlservercentrl

Posted on May 24, 2012 by

New post Kimball ETL (subsystem 1) Data Profiling via TSQL http://bit.ly/LIJksn #dataquality #dataprofiling @sqlservercentrl

Posted in data profiling, Kimball ETL (subsystem 1), Metadata Mart, SQL Server Central | Tagged , , , | Leave a comment