Tag: Google Drive
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 […]
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 […]
Great new Visualisation starting the new 2020 decade with
New decade an all, I have always been fascinated by visualizations that tell a story about our world, for the good or the bad. I have come across some great new Visualisation to start the 2020 decade with, as many of us have seen in the news, the Coronavirus outbreak, the Australia fire has caught […]
Creating a table in BigQuery with your Google Sheet data
Did you know that you can link your Google Sheet with a BigQuery table and that any chances that you make in your Google Sheet are automatically updated in the BigQuery table? If you read on, I will provide the instructions on how you can do this, first I will provide some of my views […]
Connecting your Google Sheet to an external MySQL database
I have been working on a Data Studio project that uses various data sources such as Google Sheet, BigQuery and an external MySQL database. During the project, I came across a few issues with data missing or a date being 0000-00-00 00:00:00 in the dataset, it was Data Studio that flagged a problem and gave […]
UTM Tagging med Google Sheets
Spåra alla dina kampanjer kan vara en utmaning, särskilt om du gör flerkanalig marknadsföring. Låt mig visa dig ett enkelt verktyg som kommer att öka effektiviteten i kampanjhantering och ge bättre data i Google Analytics. UTM taggning är ett bra verktyg som Google Analytics ger till tusentals digitala marknadsförare.
How to make a copy of a G Suite Doc and keep comments
The other day I got a question from a G Suite users, regarding how to keep the comments when making a copy of the G Suite Doc. It went a step further, the user wanted to just keep some comments.
Using Google Drive for Collaborative Writing for WordPress
Are you using Google Drive, did you know that you can now compose a document in Google Docs and publish it directly to your WordPress site.
Google Apps training extension delivers interactive training
Are you using Google Apps, do you feel like you really don’t know how to use it properly?
How to use Google docs for text translation and voice recording
Did you know that you now can use voice recording with Google docs, I just love this feature as it helps me when I to write, I noticed that the older I got I talk to myself when I type. With the voice recording features from Google, I can just speak out loud and my […]