How to level up your BigQuery ETLs. By Fassil S. Yehuala — The Google-acquired Dataform offers data transformation for cloud data warehouses (DWHs) such as BigQuery, Redshift, and Snowflake. Unlike traditional ETL, Dataform is a platform for managing data in ELT format, where data is extracted from the source, added to the DWH, and then transformed. At datadice, we use Dataform to…

Use the raw data export to BigQuery instead. By Sanu Maharjan — One of the frequent KPIs that our clients like to see is the page views of their website. Keeping that in mind, we always provide the following metrics, namely, page views, unique page views, landing page, page path, and exit page. In this way, our clients have an overview of…

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. Furthermore, I will focus on the releases that…

Step-by-Step instructions for advanced data transformations. By Sanyukta Suman — Power BI is a popular data visualization tool that enables organizations to analyze and visualize their data. However, simply importing data into Power BI is not enough to make meaningful insights. …

Unlocking the power of data buzzwords. By Sanu Maharjan — The use of data in numerous businesses to inform choices, enhance operations, and gain a competitive edge has made it an essential part of modern life. Understanding the fundamental words used in the profession is essential as data gathering and analysis grow more and more relevant. This blog will provide…

A Power Bi Quickstart based on BigQuery Data — By Sanyukta Suman — When my data lead asked me to recreate a Looker dashboard on the Power BI platform, I was curious as a user of Looker/Data Studio to try out this data visualization tool myself. My first impression of Power BI was that its interface looked like any other Microsoft office product…

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

A Guide to one of the knowledge-sharing strategies at datadice. By Fassil S. Yehuala — Over the past few months, the datadice team has come together for the first sprint of the Dashboard Circle. Datadice employees organized into groups and worked on various data analysis and engineering tasks in the Dashboard Circle. In this article, we will see the nitty-gritty of the Dashboard Circle, one…

Unleashing the Power of ChatGpt Pro, By Deborah Menezes — OpenAI released ChatGPT-pro as an enhanced version of the original ChatGPT model, with improved performance and capabilities. The pro version has been fine-tuned on a larger dataset, which allows for more accurate and natural language understanding. Additionally, the pro version has been optimized for commercial applications, such as chatbots and…