#converting data

Dataprojekt: Python med Google Analytics API

I den här artikeln tar jag dig igenom detaljerna för att skriva en Python Notebook-kod för att extrahera data från Google Analytics (GA4) med hjälp av Google API Python-biblioteket för att komma åt Google Analytics. (more…)

Dataprojekt: Python med 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. (more…)

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 guarantee this is the case.  (more…)

#Maritime #noonreport with #Google #Cloud #Dataprep #GCP #Trifacta

This was a very interesting project that I worked on, the use case for the project was to make the maritime noon report data available in Google BigQuery, sounds simple enough. There were a lot of requirements, first requirement was to change database table schema as each one of the ships that data was collected from had there owned database table schema and that was merged into one database…

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 pass or landing or departing from Schiphol airport, I live close to the Schiphol Airport in Amsterdam.

(more…)

#Excel with #Google #Cloud #SQL #Server #microsoft #google #googlesql

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 Excel against that server.

(more…)

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.

(more…)