The PASS Business Intelligence and Data Warehousing Virtual Chapter serves to connect BI professionals globally over ongoing webinars.


Web: | Twitter: @PASSBIVCEmail:  



PASS Summit 2016


$150 off Registration Discount Code


November 2016 Upcoming Session


Next Meeting

Thu, Dec 19 2013 12:00 (UTC-08:00) Pacific Time (US & Canada)

Guerrilla MDS/MDM The Road To Data Governance


Guerrilla MDS/MDM The Road To Data Governance

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.