Tag Archives: metadata mart

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

Explaining the Path to Data Governance from the Ground Up!

Posted on January 7, 2015 by irawarrenwhiteside

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 →

Posted in Data Governance, data profiling | Tagged , , , , , , | Leave a comment

Metadata Mart the Road to Data Governance

Posted on December 9, 2014 by irawarrenwhiteside

 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 Uncategorized, Metadata Mart, data profiling, Kimball ETL (subsystem 1), ETL, Data Governance, Dimensional Model, Guerilla MDM | Tagged , , , | 2 Comments

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

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

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

Posted on May 24, 2012 by irawarrenwhiteside

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

BI / Enterprise Data Warehouse using Agile/SCRUM modded via Extreme Scoping

Posted on October 17, 2011 by irawarrenwhiteside

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 →

Posted in Extreme Scoping Agile SCRUM, Metadata Mart | Tagged , , , , , | Leave a comment

Visual Analytics for Data Profiling(QlikView, PowerPivot) via MelissaData SSIS Components

Posted on May 7, 2011 by irawarrenwhiteside

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 →

Posted in Uncategorized | Tagged , , | Leave a comment