Learning Club 00: Set up your development environment (Getting started with R)

A few weeks ago I became aware of Renee’s (owner of the blog Becoming a data scientist) plan to start a data science learning club and I thought it was a cool idea. In the learning club she will post activities and the first one was about setting up your development environment: Activity 00: Set … Continue reading Learning Club 00: Set up your development environment (Getting started with R)

Downgrading an ETL project from SSIS 2014 to SSIS 2012

Recently I came into the situation that I had a SSIS package built with Visual Studio 2013 and SQL Server Data Tools (SSDT) 2014 which should be deployed to SQL Server 2012. Running the packages from Visual Studio 2013 and inserting data in a database on SQL Server 2012 worked, it also worked to deploy … Continue reading Downgrading an ETL project from SSIS 2014 to SSIS 2012

[Howto] Using Google URL builder, Google Analytics and R to create trackable QR codes

Some time ago I needed a QR code for a project and also wanted to find out how many people used that QR code. Googling returns many, many options, too many in my opinion. Each web site has different features, some provide counters, every web site has different data types you can export (from bad … Continue reading [Howto] Using Google URL builder, Google Analytics and R to create trackable QR codes

[SSIS tips] Error when file path variable is not set at design time

A few weeks ago I had to create a foreach container in an ETL package to loop over subdirectories of a folder. There are many tutorials out there for this purpose: microsoft-ssis.blogspot.co.at blogs.msdn.com/b/changliw/ In each iteration of the loop some files of each subdirectory where read. And since the path of these files were created … Continue reading [SSIS tips] Error when file path variable is not set at design time

Add non-overlapping labels to a plot using {wordcloud} in R

Several times when I create a plot I want to add labels for some dots directly on the plot. For this purpose I have looked for a solution to do this, because implementing it with text would probably take a lot of work. Luckily I found this two links: [stackoverflow] How do I avoid overlapping … Continue reading Add non-overlapping labels to a plot using {wordcloud} in R

[SSIS Errors] The process cannot access the file because it is being used by another process

This is an error message that took me a few hours because I could not find that particular solution on the internet and … I did not look properly at the SSIS output So I’d like to share it with you. Information: 0x402090DC at Load Observations, Flat File Destination [268]: The processing of file “D:\test\Log.txt” … Continue reading [SSIS Errors] The process cannot access the file because it is being used by another process

what3words in R: threewords V0.1.0 and my own language extension

Recently I scrolled through the list of recently published R packages when something caught my eye: threewords: Represent Precise Coordinates in Three Words which sounded interesting. What is what3words? The about page of their website explains it very well. what3words is an alternative to represent coordinates using exactly three words (instead of GPS coordinates for … Continue reading what3words in R: threewords V0.1.0 and my own language extension

Statistical tests: One sample t-test in R

This is the second post about statistical testing. In the first one I explained the principal concept behind statistical tests. Parametric tests are, in contrast to non-parametric tests, statistical tests that make some kind of assumption about the data. In general parametric tests are used when we assume normality for the source population of our … Continue reading Statistical tests: One sample t-test in R

[wordpress tips] Change permalinks

As suggested by several websites I wanted to change my permalinks from the structure p=123 to structure /post-title/ because it should be easier to find my content using a search engine. First you have to go to you wordpress admin panel. Then you do the following: Click on “Settings” Click on “Permalinks” Apply the changes … Continue reading [wordpress tips] Change permalinks