Azure ML workbench-Data Wrangling -Part 3

In the last posts, I have explained how to install Azure ML workbench and how to run a sample and check the accuracy. In this post, I am going to show how to do data wrangling using Azure ML workbench. Just click on the left menu, on the database icon. There are 2 separate groups ...

Read More

New Series of Time Series: Power BI Custom Visual (Part 4)

In this post, I am going to show how we can do time series inside Power BI using custom visual from Office store. First you need to download custom visual from office store, to download R custom visual please follow the below link   now we are going to download some timeseries custom visuals ...

Read More

Interactive Charts using R and Power BI: Create Custom Visual Part 1

I am so excited about using Plotly packages in Power BI. So What is Plotly: is an R package for creating interactive web-based graphs via the open source JavaScript graphing library : this feature has been added recently and had been announce by Christian Christian Berg in Data insight summit 2017. I started to search about ...

Read More

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 | 8 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