Copy environment variables between SSIS catalogues on different servers

Problem Usually when developing SSIS packages, you want the project to run on different servers, e.g. development, test and production server. If you have many environment variables creating all of them is tedious and unnecessary work. I’ll show you how you can copy environment variables between SSIS catalogues that are located on different servers. Solution … Continue reading Copy environment variables between SSIS catalogues on different servers

Presentation “R for Data Science”

Some weeks ago I had a presentation at my work place about “R for data science” that I’d like to share with you. I’ve written the slides in R and rmarkdown and uploaded them to rpubs.com. I chose to use rmarkdown for my slides although we have great company PowerPoint templates, because I wanted to … Continue reading Presentation “R for Data Science”

Accessing MSSQL Server with R (RSQLServer with dplyr)

Recently I have been starting to use dplyr for handling my data in R. It makes everything a lot smoother! My previous workflow – running an SQL query, storing the results as CSV, loading it in RStudio – is now history. With dplyr you can directly query data from many different databases in a very … Continue reading Accessing MSSQL Server with R (RSQLServer with dplyr)

Neuerungen beim Fitbit Charge HR 2

Wer mich in den verschiedenen sozialen Medien ein bisschen verfolgt, hat vielleicht mitbekommen, dass ich letztes Jahr begonnen habe, meine “Fitness” aufzuzeichnen. Begonnen hat das Ganze mit einem Jawbone UP 3, den ich nach wenigen Wochen wieder zurück gesendet habe. Anschließend habe ich ein paar Monate den Fitbit Charge HR (heart rate) verwendet, bis sich … Continue reading Neuerungen beim Fitbit Charge HR 2

PawSense: Den Computer vor Katzenpfoten beschützen

Vor einiger Zeit habe ich auf futurezone.at einen Artikel über das Tool PawSense gelesen und war von der Idee sofort begeistert. Das Tool soll dir dabei helfen, deinen Computer vor deiner Katze zu beschützen, indem es erkennt wenn eine Katze auf der Tastatur herumläuft. Sobald das passiert wird der Computer gesperrt und optional ein nerviges … Continue reading PawSense: Den Computer vor Katzenpfoten beschützen

Accessing your Fitbit data

Since I am a data junkie and bought my Fitbit Charge HR mainly because I wanted to collect and analyse data about myself, I was looking for ways to download the data to my computer. For most people the great stats overview in the app and in the online dashboard will be sufficient but some … Continue reading Accessing your Fitbit data

Learning Club 05-07: Starting to love rmarkdown (Naive Bayes, Clustering, Linear Regression)

I remember when I had an R course at university I was really not a fan of rmarkdown and knitr. But since I participate in a Learning Club, where people are encouraged to document and present their code, data and results, I started to love it. Prior to that I’ve always documented my assignments at the university either … Continue reading Learning Club 05-07: Starting to love rmarkdown (Naive Bayes, Clustering, Linear Regression)

I was guest at the Becoming a Data Scientist Podcast!

Almost 2 weeks ago the Becoming a Data Scientist podcast had 4 special interviews – each of them with members of the Learning Club, including me! I was super excited when Renee asked me some weeks ago if I wanted to participate and I was a little bit nervous during the interview. But I think … Continue reading I was guest at the Becoming a Data Scientist Podcast!

Netflix Socks Part 1: Set up the Arduino

Some weeks ago Netflix posted a cool project on their website, Netflix socks that will pause your show when you fall asleep. Since I fall asleep a lot during watching TV, I thought this was a cool idea for a small project. In this post I’ll show you how to set up the Arduino for … Continue reading Netflix Socks Part 1: Set up the Arduino

Finding data sets PART 3: Weather, geographical and government data

This is the third post in my dataset series. The first part gave a more general overview on where to get data. In the second post I listed sources for sports, movies, music and books data. This section will give you information on how to get weather, public/governmental data and how to find GIS data. … Continue reading Finding data sets PART 3: Weather, geographical and government data