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