Tag: Google Cloud Platform

  • #simpleit: How to build a data platform without a budget

    #simpleit: How to build a data platform without a budget

    This article is for small companies that may not have a dedicated data team or just a single resource to operate a data platform. The focus of this article is on a small business data platform setup. This article aims to show how to create the best data platform for your organization without a data […]

  • Endangered Languages Around the World

    Endangered Languages Around the World

    Recently in my newsfeed, I came to see a note that 21st February was the International Mother Language celebration day, this “piqued my interest” further, so I started to read up on what the celebration was all about and it lead me into the area of Endangered Languages.

  • #Datapipeline: The T in ETL with SQL

    #Datapipeline: The T in ETL with SQL

    If you read this I assume you are familiar with Extract Transform and Load (ETL), this is just a short article to show how you can do ETL and especially T, the transform using a SQL statement.

  • A Historic perspective of how SaaS has simplified software delivery

    A Historic perspective of how SaaS has simplified software delivery

    If you have read my previous article, 23360 days old and counting, you know that I have been around the software industry for a while. In my early days, I worked for Philips Telecommunication, a global IT company in the 1980s that delivered a turnkey solution from hardware, operating system to client software for their […]

  • Data Project: Splitting addresses with Google Cloud Dataprep

    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.

  • Types of Cloud Deployment Models and How They Benefit Businesses

    Types of Cloud Deployment Models and How They Benefit Businesses

    The fast development of the internet brought new ways in which businesses are conducted. What was unimaginable only a few years ago, today is the norm. Businesses around the globe have seen new opportunities and decided to grab them. One such opportunity is cloud computing. 

  • Should You Move Your Business To The Cloud?

    Should You Move Your Business To The Cloud?

    In the technology world, the cloud is used all the time. Some people are confused as to what the cloud actually is, and that’s understandable. Contrary to what you might think, the cloud isn’t just one big thing on its own. In reality, it’s loads of different servers, provided by various companies. There’s a Google […]

  • Maritime noon report with Google Cloud Dataprep

    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 […]

  • Securing HTTP trigger in Google Cloud Functions

    Securing HTTP trigger in Google Cloud Functions

    In this how-to article, I’m going to show how you can secure your Google Cloud Platform (GCP) Functions HTTP trigger, it has not been that straightforward to secure HTTP trigger in Cloud Functions in the past HTTP triggers in GCP were publicly available. While this might be useful in a lot of scenarios, it’s also […]

  • BigQuery federated queries against WordPress Cloud SQL Database

    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.