Speaking at SQL Saturday 352 Sydney: ETL Architecture for Solving Data Warehouse Challenges

Posted by on Nov 2, 2014 in ETL, Presentations, SSIS | No Comments

Hi, Thanks for all attendees to my session at SQL Satuday 352 Sydney, It was great to meet Grant, and Iman and also some Persian folks in this event. I was talking about my favorite subject: ETL Architecture for Solving Data Warehouse Challenges Session Description: Data Warehouses are heavily in use nowadays in most of ...

Read More

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 Description: Data Warehouses are heavily in use nowadays in ...

Read More

SQL Satuarday 316: Christchurch: ETL Architecture for Solving Data Warehouse Challenges

Posted by on May 24, 2014 in ETL, MDS, Presentations, SSIS | No Comments

I am honored that I will speak in SQL Saturday 316 Christchurch on 14th of June 2014. Presentation topic is : ETL Architecture for Solving Data Warehouse Challenges presentation 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 ...

Read More

ComCamp 2014; Presentation Files: Solution Architecture for Inferred Dimension Members with SSIS and MDS

Posted by on Mar 26, 2014 in ETL, MDS, Presentations, SSIS | No Comments

Thanks to all attendees of my session in ComCamp 2014 in Auckland about Solution Architecture for Inferred Dimension Members with SSIS and MDS. Here is session Title, Description, and presentation file; Title: Solution Architecture for Inferred Dimension Members with SSIS and MDS Description: Data Warehouses are heavily in use nowadays in most of businesses around ...

Read More

Presentation Materials: TechDays Hong Kong 2014, ETL Architecture for Solving Data Warehouse Challenges

Posted by on Mar 26, 2014 in ETL, MDS, Presentations, SSIS | No Comments

Thanks to all attendees of my session in TechDays 2014 Hong Kong about ETL Architecture for Solving Data Warehouse Challenges. Here is session Title, Description, and presentation file; Title: 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 ...

Read More

Script to Generate and Populate Date Dimension Version 2: Adding Multiple Financial Years

Posted by on Dec 11, 2013 in ETL, T-SQL | One Comment

Almost a year ago I published first version of T-SQL script to generate and populate a general purpose date dimension here. Today I want to publish the second version of that date dimension which has some corrections (fiscal calendar calculation fixed), and additional attributes (such as current year, current month, and current day) Multiple countries ...

Read More

Script for Creating and Generating members for Date Dimensions: General Purpose

Posted by on Jan 9, 2013 in Business Intelligence, ETL, SQL Server, T-SQL | No Comments

Date Dimension can be found in every Data Warehouse, because Date dimension is one of the most important factors of each operational system that users like to view reports based on date dimension. So the importance and requirement to a date dimension persuade me to write a t-sql script to generate records for date dimension. ...

Read More