Tag Archives: Data profiling

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

Navigating the Information Value Chain

Posted on May 19, 2021 by irawarrenwhiteside

Data Governance Navigating the Information Value Chain Demystifying the path forward The challenge for businesses is to seek answers to questions, they do this with Metrics (KPI’s) and know the relationships of the data, organized by logical categories(dimensions) that make … Continue reading →

Posted in Uncategorized | Tagged , , , , , | 2 Comments

Data Scoring and the Advent of Serverless Capabilities – Athena, Bigquery

Posted on March 27, 2018 by irawarrenwhiteside

Data is not information, rather information is derived from data and is the foundation and of course can be questionable. Continue reading →

Posted in serverless, Uncategorized | Tagged , , , , , , , , , , , , , | 1 Comment

Crap vs Data Governance

Posted on January 18, 2016 by irawarrenwhiteside

Crap vs Data Governance Continue reading →

Posted in agile, Data Governance, Uncategorized | Tagged , , | Leave a comment

Actuality Business Intelligence – the path to Enlightenment

Posted on April 10, 2015 by irawarrenwhiteside

Data enlightenment data profiling Continue reading →

Posted in 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

Organic Data Quality vs Machine Data Quality

Posted on December 18, 2014 by irawarrenwhiteside

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 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

Creating a Metadata Mart via TSQL – Complete Data Profiling Kit – Download

Posted on April 13, 2014 by irawarrenwhiteside

With Data Profiling “You get what you inspect, not what you expect” Readers Digest. Complete Data Profiling Kit (Code and Samples) providing capabilities similar to leading vendor tools, such as Informatica, Data Stage, Dataflux etc… Continue reading →

Posted in agile, Big Data, data profiling, extreme scoping, Extreme Scoping Agile SCRUM, Ira Whiteside, Kimball ETL (subsystem 1), Uncategorized | Tagged , , | 14 Comments