About this blog

Hello and welcome to my first data analysis blog!
In order to further improve my skills in these fields I decided to start a blog where I could post some of my analysis to get feedback from the community. Since I really appreciate the freely available resources online, I also wanted to give something back. That’s why I am planning to post resources which helped me on my continuing path to becoming a data analyst or to provide some small tutorials for things I recently learned.

You’ll find my work in the Post section. Feel free to contact me for questions or feedback.

Recent Posts

More Posts

Dashboards are nice tools when it comes to analyzing quickly changing data. Nevertheless, you may also use them for reporting purposes by taking snapshots. R has a nice library called flexdashboard which you can use for creating dashboards out of RMarkdown files. During a project at work we found a nice solution for dynamically rendering flexdashboard pages by using R Markdown child templates which I want to share with you in this blog post.

CONTINUE READING

During this year’s summer break there had been a railway construction site which affected the train I usually use for commuting to work. This led to a lot of additional commuting time. Thus, I decided to repair my old mountain bike and give it a try to go to work by bike. During the one hour ride I wondered how many people made the same decision and if there would be any data about Munich bike traffic with the use of which I could get some insights about Munich’s bike traffic.

CONTINUE READING

22… … this is the count of school shootings which took place in USA within the first 21 weeks in 2018. Statistically this means that there has been more than 1 shooting per week. The Washington Post wrote that this led to more deaths at schools than members of the US military have been killed while being deployed this year. We hear about those shootings quite often in the news, and after almost every of theses a new discussion about the USA gun laws arises.

CONTINUE READING

The aim of today’s blog post is to give a short introduction into the usage of BigQuery inside of R. BigQuery is a product within the Google Cloud Platform and serves as a data warehouse for storage and analytics at high scale. It supports standard SQL dialect which makes it easy to use for people with SQL experience. We are going to use one of the public data sets available on BigQuery and have a short look at the recorded incidents of the San Francisco Police Departments.

CONTINUE READING

Everybody knows the Oktoberfest which takes place in Munich every year. In this blog post series we are going to look into a public availabe dataset and try to gain some insights about the Oktoberfest. In the first part we loaded and described the data. We also analysed the price and consumption of beer and hendl (chicken) over the years. In this second part we are going to have a closer look at the Bavarian Central Agricultural Festival - also known as “ZLF”.

CONTINUE READING

Contact