Category Archives: Extreme Scoping Agile SCRUM

Mastering Microsoft SQL Server tools required for EIM (MDS, DQS, Profiling and SSIS) – Complete Kit

Posted on April 23, 2014 by

  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

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

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

Posted on April 13, 2014 by

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 , , | 13 Comments

Microsoft BI Stack Leveraged with Vendor Add – In’s for Data Quality and Data Lineage.

Posted on October 24, 2012 by

Lineage as it applies to data in Business Intelligence provides the capability see track back where data came from. Essentially it supports “Metric Decomposition” which is a process for breaking down a metric (business calculation) into separate parts. With this capability you can determine your data’s ancestry or Data DNA. Continue reading →

Posted in Awarement, Computers and Internet, data profiling, Donal Farmer, Extreme Scoping Agile SCRUM, Fuzzy Matching, Ira Whiteside, Kimball ETL (subsystem 1), MelissaData, Metadata Mart, SSIS, Uncategorized | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

MAD Skills: New Analysis Practices for Big Data

Posted on February 20, 2012 by

I have had my first exposure to MAD Skills: New Analysis Practices for Big Data , very interesting approach , in many ways an extreme expansion of the concept for operational analytics via OLAP. The use of the “Sandbox” environment … Continue reading →

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

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

Posted on October 17, 2011 by

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