This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Category: Data Analysis
-
Cloud Data Warehouse Automation
A few months back I wrote an article on Maritime Noon report with Google Cloud Dataprep, the article was well received and led me to work with Trifacta and Data Science Central to structure the article into a webinar.
-
Data project: I became an environmental data collector
At the beginning of the Corona epidemic, I wrote an article about a personal data project I had worked on: The air I breathe how polluted is it?. After that project, I became an environmental data collector by purchasing a wearable, portable indoor-outdoor air quality monitor. My interest in air quality is about the fact that…
-
Data Project: Splitting addresses with Google Cloud Dataprep
This article is part of the article I wrote about how I became an environmental data collector, and the issue I run into during the project and how I finally resolved them. After I collected the data with the wearable, portable indoor-outdoor air quality monitor Atmotube PRO.
-
Maritime noon report with Google Cloud Dataprep
I recently worked on an exciting project, the use case for the project was to make the maritime noon report data available in Google BigQuery, which sounds simple enough. However, there were a lot of requirements, from collecting application data from the Greenpeace fleet in different formats leveraging Cloud Functions and API calls, landing the…
-
The world can’t afford to drop the ball again
We are all sharing a similar experience with the coronavirus pandemic, which we all remember in the future as the 2020 coronavirus outbreak. Each country has adopted different restrictions, we still all affected by what has taken place.
-
BigQuery federated queries against WordPress Cloud SQL Database
BigQuery has added a new feature, in which you can connect to a Cloud SQL instance and make federated queries. In this how-to, I will explain how I made an external connection from BigQuery, then using federated queries to query my cloud SQL WordPress database and made a Top Story report in Google Data Studio.
-
Data Project: The air I breathe how polluted is it?
I wanted to find out how polluted the air is around me, and if it had improved now when we work from home and there are fewer airplanes going past or landing or departing from Schiphol airport, I live close to the Schiphol Airport in Amsterdam.
-
Infographic Bitcoin Halving what does it mean
Bitcoin halving is expected to take place around May 12th, 2020, A bitcoin halving is an event when miners receive 50% fewer bitcoins for verifying transactions. Bitcoin halvings are scheduled to occur once every 210,000 blocks until the maximum supply of 21 million bitcoins has been generated by the network. Bitcoin began circulating in 2009 as an electronic…
-
Fun Tech Projects to spend time on
With our current situation with the Covid-19 virus affecting our lives, I can not spend so much time outside cycling as I normally do, as there are restrictions on how where to go. I do have other hobbies, one of them is doing programming and testing out new things with my Raspberry Pies, it gives…
-
Data Studio is so much easier to work with than Tableau
Tableau is an old product which I worked with from 2009 tills I discovered Data Studio and switched. I will give my view of why I think Data Studio is easier to work with.