Tag: Converting data

  • #datapipeline the hourly electricity rate

    #datapipeline the hourly electricity rate

    I spent my Christmas holiday in the southern part of Sweden, the weather was cold with several days of temperatures down under -10 celsius. In the news were stories about new price records for a KwH of electricity. I started to get worried that our electricity bill for December or for the whole winter period…

  • Do you know how much CO2 your computer use?

    Do you know how much CO2 your computer use?

    Have you ever wondered how much Co2 your computer use and what impact computers have on climate change? I set out to investigate and came to the conclusion that it is now easy to figure, accordingly to Worldometer there has been shipped over 2 billion computers as of 2007, the number is high. This year…

  • What uses the most electricity in your home?

    What uses the most electricity in your home?

    This year when the electricity prices skyrocket in my village, I wanted to find out how much electricity my appliances consumed, and while I was at it I also calculated the carbon impact of my electrical appliances.

  • Data Project: Python with Google Analytics API

    Data Project: Python with Google Analytics API

    In this article, I will take you through the details of writing a Python Notebook code to extract data from Google Analytics (GA4) using the Google API Python library to access Google Analytics.

  • 4 Ways To Take Your Business Into The Future

    4 Ways To Take Your Business Into The Future

    Are you thinking about ways that you can improve your business? There are lots of possibilities worth exploring here. However, we recommend that you put a strong focus on trying to guarantee that your company is ready for the future and that your brand looks forward-thinking. Here are some of the ways that you can…

  • Data project: I became an environmental data collector

    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…

  • 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…

  • Data Project: The air I breathe how polluted is it?

    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.

  • Excel with Google Cloud SQL Server

    Excel with Google Cloud SQL Server

    Google has added the SQL server as an option to the Google Cloud SQL service. In this article, I will explore how to set up a Google Cloud SQL server I received a question what was the best way to move a Cloud BI server to the GCP Cloud, and run VB Script from an…

  • Creating a Google Cloud Dataprep recipe with no newline delimited JSON file

    Creating a Google Cloud Dataprep recipe with no newline delimited JSON file

    This is to follow up on my previous article Detecting non newline delimited JSON file with Google Cloud Dataprep in this article I will show you how to create a Cloud Dataprep recipe that transforms the no newline delimited JSON file.