Power BI can use a wide variety of data sources. This is one of the things that makes it very powerful. In this post I show how you can use an R script as a data source. If you have…
Lee Hawthorn15 June 2019
Cleaning data is a big part of Data Science. Being able to script data cleaning makes it repeatable and transparent. The best tools to do this with in my opinion are R/Python/Power Query/SQL. In this post I take some scrapped…
Lee Hawthorn10 June 2019
We can use DiagrammeR & Sprockit to discover Server Integration Services (SSIS) Dependencies. SSIS is a mature data integration tool bundled with SQL Server. SSIS like many other tools can lead to 'dependency hell'. This is where packages or stored…
Lee Hawthorn5 June 2019