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 about Speaking Files in Microsoft Data Insight Summit 2017[…]
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 about Optimising Power BI data models[…]
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 about Azure ML Part 5: A Machine Learning Prediction scenario (2)[…]
I’ve hear this question many times; “Do you think we need a date dimension?”. some years ago, date dimension has been used more, but nowadays less! The main reason is that there are some tools that are using their own built-in date hierarchy. As an example Power BI has a built-in date hierarchy that is Read more about Do You Need a Date Dimension?[…]
It is my pleasure to speak in PASS 24 Hours session for Evolution of Data Platform on the topic above. I look forward to meet you all in this webinar. registration is free, but limited. So reserve your seat now. Here are some information about my session and 24HOP. 24HOP 24 Hours of PASS is Read more about Temporal Tables and Their Roles in ETL and Data Warehouse[…]
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 about ETL Incremental Load with SSIS; Q&A and Recording[…]
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 about SSIS Incremental Load with Datetime Columns[…]
SQL Server 2016 CTP 3.0 is available, and some of you already played with it. There are great set of new features for BI in 2016 in all areas; SSIS, MDS, SSRS, and SSAS. However there are some features which are part of Database Engine but still relates to BI and Data Warehousing. Temporal Tables Read more about Temporal Tables: A New Method for Slowly Changing Dimension[…]
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 about Speaking at SQL Saturday 352 Sydney: ETL Architecture for Solving Data Warehouse Challenges[…]
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 about Speaking at TechEd New Zealand 2014[…]