Category Archives: Mdm

Data Governance Navigating the Information Value Chain Demystifying the path forward

Posted on December 13, 2021 by irawarrenwhiteside

Information Value Chain

• Business is based on Concepts.

• People thinks in terms of Concepts.

• Concepts come from Knowledge.

• Knowledge comes from Information.

• Information comes from Formulas.

• Formulas determine Information relationships based on quantities.

• Quantities come from Data.

• Data physically exist.

Continue reading →

Posted in agile, Awarement, Big Data, Data Governance, data profiling, data quality, data quality mart, Dimensional Model, Download Complete Data Profiling Kit - TSQL, graph, Master Relationship Management, Mdm, Metadata Mart, Uncategorized | Leave a comment

Merry Christmas Data Classification, Feature Engineering , Data Governance. ‘How to’ do it and some code take a look

Posted on November 30, 2021 by irawarrenwhiteside

Therefore I decided, to update some of the techniques and code patterns, I’ve used in the past regarding the information value chain and or record linkage , and we are going to make the results available with associated business and code examples initially with SQL Server and data bricks plus python Continue reading →

Posted in agile, Awarement, Big Data, blocking index, Data Governance, data profiling, data quality, data quality mart, Dimensional Model, Download Complete Data Profiling Kit - TSQL, ETL, extreme scoping, Extreme Scoping Agile SCRUM, Fuzzy Matching, Guerilla MDM, Guerilla MDS, Ira Whiteside, Machine Learning, Master Relationship Management, Mdm, Metadata Mart, MRM, Self Service Semantic BI, serverless, SQL Saturday, SQL Server Central, SSIS, stroke, Table Variable TSQL, Uncategorized | Tagged , , , , , , , | Leave a comment

Chocolate cake, MDM, data quality, machine learning and creating the information value chain’

Posted on May 3, 2018 by irawarrenwhiteside

The primary take away from this will be that you don’t start your Machine Learning project, MDM or Analytical project with “data” analysis you start with the end business objective in mind. We don’t need to analyze data to know it is, it’s like oil or water or sand or flour. Continue reading →

Posted in Data Governance, data profiling, data quality, Machine Learning, Master Relationship Management, Mdm, MRM, Uncategorized | Tagged , , , , , | Leave a comment

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

Posted on May 7, 2017 by irawarrenwhiteside

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

Informatica Cloud MDM for Salesforce (formerly Data Scout) Review

Posted on December 12, 2014 by irawarrenwhiteside

In general and product is positioned to provide a transactional MDM within Salesforce. Continue reading →

Posted in Data Governance, Fuzzy Matching, Guerilla MDM, Guerilla MDS, Mdm, Uncategorized | Tagged , , , , , | Leave a comment

Self Service Semantic BI (Business Intelligence) Concept

Posted on December 8, 2014 by irawarrenwhiteside

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 irawarrenwhiteside

  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

Guerrilla MDS MDM The Road To Data Governance

Posted on April 18, 2014 by irawarrenwhiteside

For tomorrow’s MDM You must be ready to embrace Agile Iterative and/or Extreme Scoping in order to fully realize the benefits and learn the constraints of MDS
Continue reading →

Posted in Extreme Scoping Agile SCRUM, SQL Saturday, data profiling, Fuzzy Matching, Mdm, MDS, MDS Stored Procedures, Data Governance, Dimensional Model, Guerilla MDM, Guerilla MDS | Leave a 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 irawarrenwhiteside

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 irawarrenwhiteside

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