Category Archives: Big Data

Self Service Semantic BI (Business Intelligence) Concept

Posted on December 8, 2014 by

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

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

Agile MDM Data Modeling and Requirements incorporating a Metadata Mart.(Guerilla MDM)

Posted on September 27, 2013 by

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

Posted on November 28, 2012 by

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