What is Dataform and how does it work? By Fassil S. Yehuala — Dataform is an IDE (Integrated Development Environment) that allows you to create modern data flows in cloud Data warehouses such as Google BigQuery, Amazon Redshift, or Snowflake. …

Which data do I need to align to get valuable and correct business information? By Fassil S. Yehuala — When we integrate data from Shopify into our customer’s analytics dashboards we always get one question: Why is my Shopify Report showing different results? Of course, there are many reasons why the two reports are not the same. Most of the differences appear in the way KPIs are calculated. Since…

The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke In this blog post, I want to summarize the new releases from the Google tools, that we use daily in datadice. Therefore I want to give an overview of the…

The what and how-to of RAWGraphs. By Fassil S. Yehuala and Ying Wang — This article aims at introducing a free and open-source data visualization tool called RAWGraphs an open-source data visualization tool designed to make complex data easy to visualize.

The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke — In this blog post, I want to summarize the new releases from the Google tools, that we use daily in datadice. Therefore I want to give an overview of the new features of BigQuery, Looker Studio, Google Analytics and Google Tag Manager. …

Use GA4 raw data in BigQuery. By Sanu Maharjan — When you are using GA4 to track your website or app, looking at sessions and engagement could be very insightful. Without any delay, first, let’s look at how sessions and engagement are defined in GA4 and then how we can extract them to Bigquery. Sessions A session is triggered when one…

The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke — In this blog post, I want to summarize the new releases from the Google tools, that we use daily in datadice. Therefore I want to give an overview of the new features of BigQuery, Data Studio, Google Analytics and Google Tag Manager. …

The What, Why, and How of BigQuery Nested and Repeated Data. By Fassil S. Yehuala and Sanyukta Suman — If you have worked with nested and repeated columns and found them a bit challenging, then this article is for you. In this blog, we explain the nitty-gritty of such kinds of fields in BigQuery. We will discuss in detail why they are preferred in data warehousing and how to…

A Unique One Solution for ML with NO CODING: Google’s Vertex AI is the best platform to train ML models using the AutoML feature. By Vaishnavee Baskaran — Google Cloud Platform brought a unique platform for all AI solutions. Vertex AI brings AutoML and AI Platform together into a unified API, client library, and user interface. In Vertex AI, you can easily train and compare models using AutoML or custom code training.