Speaking at TechEd New Zealand 2014

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

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

Description:

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:

https://newzealand.msteched.com/conference/sessions/etl-architecture-for-solving-data-warehouse-challe/

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:

https://newzealand.msteched.com/events/sessions/

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for eight continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

Leave a Reply

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