-
Recent Posts
Recent Comments
Gordon Gifford on Data Scoring and the Advent of… Merry Christmas Data… on Creating a Metadata Mart via T… Merry Christmas Data… on Navigating the Information Val… Zack Camerin on Navigating the Information Val… Claudius Pereira on Bright Insight – Lost Ci… Archives
- June 2022
- March 2022
- December 2021
- November 2021
- August 2021
- May 2021
- April 2021
- March 2021
- December 2020
- November 2020
- October 2019
- September 2018
- June 2018
- May 2018
- March 2018
- May 2017
- June 2016
- January 2016
- April 2015
- January 2015
- December 2014
- November 2014
- April 2014
- January 2014
- December 2013
- September 2013
- November 2012
- October 2012
- August 2012
- July 2012
- May 2012
- April 2012
- February 2012
- December 2011
- November 2011
- October 2011
- May 2011
- April 2011
- December 2010
- October 2010
- January 2010
- October 2009
- January 2009
- May 2008
Categories
- agile
- Awarement
- Big Data
- blocking index
- BrandonStasiewicz
- Christina Whiteside
- Computers and Internet
- Data Governance
- data profiling
- data quality
- data quality mart
- Diabetic Come
- Dimensional Model
- Dna
- Donal Farmer
- Download Complete Data Profiling Kit – TSQL
- ETL
- extreme scoping
- Extreme Scoping Agile SCRUM
- family
- Fuzzy Matching
- Gnostic
- God
- Gospel
- graph
- Guerilla MDM
- Guerilla MDS
- insulin
- Ira Whiteside
- Jack Stasiewicz
- Jacob Stasiewicz
- Julia Stasiewicz
- Kimball ETL (subsystem 1)
- LOVE
- Machine Learning
- Master Relationship Management
- Mdm
- MDS
- MDS Stored Procedures
- MelissaData
- Metadata Mart
- MRM
- Pavlov
- Plato
- PONS Stroke
- Quotes
- Self Service Semantic BI
- serverless
- Soul Mate
- SQL Saturday
- SQL Server Central
- SSIS
- stroke
- Table Variable TSQL
- Tessie Whiteside
- Theresa Whiteside
- Uncategorized
- Victoria Stasiewicz
- Yoda
Meta
Category Archives: Metadata Mart
Data Governance Navigating the Information Value Chain Demystifying the path forward
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.
Merry Christmas Data Classification, Feature Engineering , Data Governance. ‘How to’ do it and some code take a look
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 Big Data LinkedIn Science OLAP Agile SCRUM Extreme Scoping BI Data Quality Metadata Mart, Business Discovery, data governance, data lineage, Data profiling, data quality, data quality mart, metadata mart
|
Leave a comment
DNA and the concept of MDM(Master Data Management) have many similarities.
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 data, Dna, fuzzy, Lineage, matching, MDM, Profiling
|
1 Comment
Organic Data Quality vs Machine Data Quality
Awarement of data quality issues is business as usual, awarement of specific data quality is enlightenment. Continue reading →
Metadata Mart the Road to Data Governance
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
Self Service Semantic BI (Business Intelligence) Concept
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 Big Data LinkedIn Science OLAP Agile SCRUM Extreme Scoping BI Data Quality Metadata Mart, Business Discovery, data lineage, Data profiling, JSOM-LD, metadata mart, RDFa, Self Service Semantic Business Intelligence, semantic web, Triple store
|
Leave a comment
Mastering Microsoft SQL Server tools required for EIM (MDS, DQS, Profiling and SSIS) – Complete Kit
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
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 Agile, MDM, MDS, metadata mart, Table Variable TSQL, TSQL Code Generation, Tyler Graham, udpMembersValidationStatusUpdate, udpMemberValidationStatusUpdate
|
1 Comment
Agile MDM Data Modeling and Requirements incorporating a Metadata Mart.(Guerilla MDM)
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
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 BIG DATA, ETL, METADATA.DATA DRIVEN, NETEZZA, SSIS
|
Leave a comment