Speaking at TechEd New Zealand 2014

Posted by on Sep 3, 2014 in ETL, Presentations, SSIS | No Comments

It is my pleasure to speak in TechEd New Zealand 2014

TechEd is happening between 9th to 12th of September, and it will be held in SkyCity, Auckland, New Zealand.

the topic that I will talk about is:  

ETL Architecture for Solving Data Warehouse Challenges


Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis out of operational databases. By the way there are some challenges in design and implementing Data Warehouses which needs robust and reliable ETL implementation. In this session you will learn an ETL Architecture implemented by SSIS and MDS to solve couple of most challengeable Data Warehousing scenarios which are Slowly Changing Dimension and Inferred Dimension Member. There will be many demos through this session which helps you to understand design and implementation of the architecture. Using Master Data Services as a MDM solution and SSIS as an ETL tool, require more architectural consideration, especially for Inferred Dimension Members. MDS will keep a single version of truth of the record, and Dimensions in the Data Warehouse will use MDS entity records as source. With Appearing new records that are not exists in MDS, an inferred record should be added into MDS, and the update structure for Data Warehouse should apply only update for inferred members instead of applying Slowly Changing Dimension. In this chapter you will learn an architecture as a best practice to implement Inferred Dimension Members with MDS and SSIS. 

you can find details about hour of the presentation and conference room here:


I have to thank Myles Matheson and Microsoft New Zealand who gave me the opportunity to speak. and I look forward to see those of you who can make this event at the venue. 

Here are list of all sessions at this event:


Reza Rad
Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in Data Platform for seven continues years (from 2011 till now) for his dedication in Microsoft BI. He is author of some SQL Server and BI books, and also Power BI online book; from Rookie to Rock Star.

Leave a Reply

Your email address will not be published. Required fields are marked *