-
Recent Posts
Recent Comments
Claudius Pereira on Bright Insight – Lost Ci… John Indelicato on DNA and the concept of MDM(Mas… Data Scoring when yo… on Creating a Metadata Mart via T… Data Profiling and D… on Creating a Metadata Mart via T… James Searle on Creating a Metadata Mart via T… Archives
- 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
- Guerilla MDM
- Guerilla MDS
- insulin
- Ira Whiteside
- Jack Stasiewicz
- Jacob Stasiewicz
- Julia Stasiewicz
- Kimball ETL (subsystem 1)
- 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
Tag Archives: metadata mart
Explaining the Path to Data Governance from the Ground Up!
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 data governance, Data profiling, data quality, guerilla data governance, Ira Whiteside, MDM, metadata mart
|
Leave a comment
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
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
New post Kimball ETL (subsystem 1) Data Profiling via TSQL http://bit.ly/LIJksn #dataquality #dataprofiling @sqlservercentrl
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 code generation, Data profiling, metadata mart, tsql
|
Leave a comment
BI / Enterprise Data Warehouse using Agile/SCRUM modded via Extreme Scoping
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 →
Visual Analytics for Data Profiling(QlikView, PowerPivot) via MelissaData SSIS Components
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 →