Speaking Files in Microsoft Data Insight Summit 2017

Microsoft Data insight Summit 2017 has been held in Seattle from 12 to 13 Jun. It is the main conference for Microsoft Data Analysis with Power BI. All interesting and new topics in Power BI has been presented. Most of the speakers are from Microsoft product team or  experienced speakers in this fields. there are ...

Read More

Optimising Power BI data models

Posted by on Jun 3, 2017 in ETL, Power BI, Uncategorized | 7 Comments

For this blog I thought I would share a handy trick for optimising Power BI using a data modelling solution that is often forgotten or overlooked.  It involves focusing on certain columns based on the degree of uniqueness they contain and converting or removing all together from a data model.  I will explain how and why this ...

Read More

Azure ML Part 5: A Machine Learning Prediction scenario (2)

In the previous Post , I start to do prediction the cancer diagnosis using some laboratory data. I have explained some of the main components for doing the data cleaning such as “SQL Transformation”, “Edit Meta Data”, “Select Columns” and “Missing Values”. In this post I am going to show the rest of data cleaning ...

Read More

ETL Incremental Load with SSIS; Q&A and Recording

Posted by on Jan 27, 2016 in ETL, SSIS | No Comments

Thanks to all attendees to my webinar today, with more than 400 registration I’m thrilled to say this very first RADACAD webinar was a successful step towards regular free webinars. If you are interested in future webinars please stay tuned, we will announce them all in our events page. Today’s webinar was about ETL Incremental ...

Read More

SSIS Incremental Load with Datetime Columns

Posted by on Jan 12, 2016 in ETL, SSIS | 14 Comments

Previously I’ve mentioned how to implement Incremental Load within SSIS using CDC (Change Data Capture) feature. Unfortunately CDC is not always supported by the source database, so you have to implement an incremental load solution without CDC. In this post I’ll explain how to implement incremental load if there is a modified datetime column in ...

Read More

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