The History of War Analyzed

War is an ugly topic, but I wanted to know if we have learnt anything from history and so I downloaded the data for all the wars since 1900 till date to get an understanding of how things have changed. The below chart shows the duration in years on the x axis and the count…

SSIS – Starter kit for the uninitiated – Data enrichment

In this last post (after which there will be a video explaining how to bring all this together in Power view) I cover how to convert geo coordinates from 38° 53′ 55.133″ N to Decimal Coordinate system 38.898648. You can find the previous posts here. The calculations is fairly simple the sql for it is…

SSIS – Starter kit for the uninitiated Data Flow Task

In this post we explore how to use the DFT (Data Flow Task) to load data from an XML file into the database. For previous post on how we got till this step please click here. Step Screenshot Double Click and open the DFT we had added in the previous post. Drag and Drop an…

A simple change that could save Millions of $$$ in Support services

I recently came across the below error message “An exception was thrown by Target of invocation” What it really means is the application you tried to run has reported an error. This got me thinking about how software has ignored one of the most important yet frustrating aspects of user experience. Easy to understand and…

SSIS – Starter kit for the uninitiated – Dynamic File Paths

Continuing from our previous post here we explore how to configure tasks to behave dynamically. More specifically how to configure the file connection manager to accept dynamic paths to store the output of our web service task. Navigate to the connection managers in the bottom pane of SSIS and right click the Connection manager we…

SSIS – Starter kit for the uninitiated – Web Service Task

Continuing from the last post, we now configure the web Service task. If you visit the web service link you will see the below screen “http://free-web-services.com/web-services/geo/location-info/” Click the Link for Airport Information, it will take you to the below screen where you can find the URL for the web service.   Click the URL to…

SSIS – Starter kit for the uninitiated – Foreachloop

I was up at 3:00 AM in the morning and felt that the world needs to know where all the airports are and how you could use SSIS and PowerView to display this information in a clean and concise way. This need was so powerful that I spent the next 4 hours writing an SSIS…

Source Code for ETL performance test

There was a lot of response on the ETL performance test that was published last week so I have published the source code for all the tests at the below link. Happy testing, also please feel free to share any interesting finds. I have highlighted the first DFT to show the impact of not pre…