Ira and Vic's session "Guerrilla MDS" will be a walk-through of a real-world implementation for a master data model (MDM) and metadata mart utilizing SSIS, MDS and POWER BI EXCEL addins as well as applying proper data quality techniques. We will walk through in detail the processes necessary for utilizing the complete MDS functionality as follows: creating entities attribute, relating entities the domain based attributes , staging leave table, updated entity content, apply business rules, create subscription view and set up security. Source code for all samples and PowerPoints will be made available
I am a Business Intelligence Architect with over 38 years of industry experience(TechnoGeezer) , I have worked with the Microsoft BI Stack DTS, OLAP Services, SSIS, SSAS, SSRS PowerPivot, and Data Mining extensively since 1998.
I have led many teams in building "Best Practice" ETL and Integration architectures, in many platforms Oracle, DB2, Cobol, Microsoft. Informatica, Data Stage and SSIS.
I have published several article for SQL Server Central and other publications.
My wife(Tessie) and I along with our family(Christina, Victoria, Brandon) develop and market SSIS Data Quality Components.
I have led entire organizations in implementing BI Architecture including Technical as well as Business requirements Methodology , Data Modeling and supported by a TCO Business Case Methodology and Applying Agile to Data Warehousing via Extreme Scoping.