Data Insights & AI Expertise
Bleib auf dem neuesten Stand mit Experten-Insights, Case Studies und Best Practices in Data Analytics und AI Consulting.
Featured Posts

Latest Updates on Google Data Analytics (January 2026)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke
All Posts
108 posts found
Latest Updates on Google Data Analytics (August 2026)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (July 2026)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (June 2026)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (May 2026)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke
)
Latest Updates on Google Data Analytics (April 2026)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (March 2026)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (February 2026)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (January 2026)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (December 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM).

Latest Updates on Google Data Analytics (November 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By [Alexander Junke](https://www.linkedin.com/in/alexander-junke-461375201/)

Latest Updates on Google Data Analytics (October 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM) for October 2025, including new AI functions, data transfers, and enhanced features.

Latest Updates on Google Data Analytics (September 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM) including new data preparation features, Data Science Agent improvements, and cost import options for Pinterest and Snapchat.

Latest Updates on Google Data Analytics (August 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM).

Latest Updates on Google Data Analytics (July 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (June 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (May 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (April 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (March 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

AI-Powered SQL Modeling: Claude 3.7 Sonnet + Aider for Data Analysts
Discover how data teams use AI assistants to improve query logic, speed, and accuracy. By Sanyukta Suman

Latest Updates on Google Data Analytics (February 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (January 2025)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (December 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (November 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Introducing BigQuery Workflows
A New Era of Data Orchestration. By Fassil S. Yehuala

Latest Updates on Google Data Analytics (October 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (September 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Latest Updates on Google Data Analytics (August 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Upgrade Your ls Command to eza
A Guide to Adding Flair to Your Terminal. By Sanu Maharjan

Latest Updates on Google Data Analytics (July 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

How to Choose the Right Color Theme for Your Dashboard?
Choosing right color scheme for your data dashboard. By Sanyukta Suman

Latest Updates on Google Data Analytics (June 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (May 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

9 Tips and Tricks to enhance user experience on Power BI
Optimizing your dashboard for better user engagement. By Sanyukta Suman
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (April 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

How to use Google Gemini with BigQuery
A Guide for SQL Code AI Assistance. By Fassil S. Yehuala
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (March 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

How to set up Row Level Security in Power BI?
Data Privacy with Power BI Row Level Security. By Sanyukta Suman

How to Apply Custom Value Formatting in Looker Studio
A Guide to Custom Value Formatting. By Fassil S. Yehuala
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (February 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (January 2024)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

5 Steps to Add Intervals in Looker Studio Time Series Chart
Reliable Prognosis in your Charts. By Fassil S. Yehuala
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (December 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

What are Bookmarks in Power BI?
Beyond Basics: 5 Creative Approaches to Utilizing Bookmarks in Power BI. By Sanyukta Suman

How to make Sankey Chart in Looker Studio
Learn how to add Sankey Chart in Looker Studio
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (November 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

How to create a stunning Power BI Dashboard Theme
With Power BI and Canva you can create themes with just a few clicks. By Sanyukta Suman

Adding waterfall chart in Looker Studio and its limitations
Handling the new Waterfall charts in your dashboards. By Fassil S. Yehuala
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (October 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke


All in one data analytics with Microsoft Fabric
An introduction to Microsoft Fabric. By Deborah Menezes

6 Free Social Media Dashboard Templates in Looker Studio
Elegant dashboard design template that are easy to replicate in Looker Studio
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (September 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

How to use Duet AI with BigQuery
How to get started with Google Duet AI to improve your query writing skills and its use cases.
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (August 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

How to create alert system in Slack using BigQuery
Create Your Slack Bot with BigQuery and Google Sheets. By Deborah Menezes
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (July 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

3 Ways to keep your Power BI File under 1 GB
How to bypass one of the most annoying limits. By Sanyukta Suman
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (June 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

How to set up scheduled queries in BigQuery
Automate and Optimize Your Data Processing with Release and Workflow Configurations. By Fassil S. Yehuala

Webflow 101: A Beginner's Guide to build stunning websites
And how to track a webflow website with GTM. By Timon Mayer

Deploy Airbyte and Airflow in Compute Engine on GCP
Efficiently build and manage data pipelines. By Sanu Maharjan
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (April 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (May 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke


6 design tips to create stunning Power BI dashboards
6 design tips to create stunning Power BI dashboards · 1. Pick a Color Theme and Font Style · 2. Use Alignment tools · 3. Adjust multiple visuals in one go · 4.

OpenAI does it again! ChatGPT4 is available
A selfwritten! summary on what's NEW. By Deborah Menezes
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (March 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (January 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke
How I want to become a Web Tracking Specialist
My first hands-on experience with GTM. By Timon Mayer

How to add primary key and foreign key to a BigQuery?
Google is starting to add features from systems like MySQL. By Alexander Junke

9 Easy steps to start with Dataform
How to level up your BigQuery ETLs. By Fassil S. Yehuala

Analyze GA4 Landing and Exit Pages Using BigQuery
Use the raw data export to BigQuery instead. By Sanu Maharjan

Extract Sessions & Engagement from GA4 with BigQuery
Use GA4 raw data in BigQuery. By Sanu Maharjan
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (February 2023)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

All-in-One Power BI Guide with DAX formulas and date tables
Move your data analysis project with this Power BI tutorial to the next level. By Sanyukta Suman

Big Data vs. Data Warehouse vs. Data Lake vs. OLTP vs. OLAP
Explore key concepts in data management, from big data to OLTP vs. OLAP, data lakes vs. warehouses, and machine learning for business intelligence.

The Complete 2023 Beginner's Guide to Power BI
A Power Bi Quickstart based on BigQuery Data - By Sanyukta Suman

How to do internal knowledge transfer: The Dashboard Circle!
A Guide to one of the knowledge-sharing strategies at datadice. By Fassil S. Yehuala

OpenAI launches ChatGPT Professional!
Unleashing the Power of ChatGpt Pro, By Deborah Menezes

Creating data pipeline with Dataform in BigQuery (Part 1)
What is Dataform and how does it work? By Fassil S. Yehuala
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (December 2022)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

4 reasons why shopify sales report is not accurate
Which data do I need to align to get valuable and correct business information? By Fassil S. Yehuala

How to use RAWGraphs: Free data visualization tool
The what and how-to of RAWGraphs. By Fassil S. Yehuala and Ying Wang
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (November 2022)
The highlights of the updates on BigQuery, Looker Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (October 2022)
The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Working with Nested and Repeated Fields in BigQuery
This unnest function helps to flatten the data, making accessing nested data easier. Now, let's try to solve the previous error by using UNNEST.

How to Model Time Series Forecasting using Vertex AI AutoML
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

Eine einheitliche BI-Plattform mit Google Data Studio und Looker
Mehr Leistung und mehr Daten. Von Sanu Maharjan

A unified BI platform with Google Data Studio and Looker
Data Studio is now Looker Studio. Learn all about this change.
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (September 2022)
The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Universal Analytics vs. Google Analytics 4 (Part 1)
Google Analytics 4 is taking over. By Ying Wang
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (August 2022)
The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

New Data Studio (Looker Studio) feature: Linking API
New management possibilities for your dashboards. By Alexander Junke

Generate dummy data with Faker with Python
A guide on how to use Faker package in Python to populate a dummy dataset.
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (July 2022)
The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Google Analytics 4 in Data Studio (Looker Studio)
It’s Time to play around in Data Studio with The New GA4! By Vaishnavee Baskaran

More Data Modeling Functions in Y42 (Part 3)
Start modeling your data with the Union and Date Formatter nodes. By Sanu Maharjan

How to create a Google Account without Gmail
Step-by-step guide on creating a Google Account without Gmail. By Sanyukta Suman
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (June 2022)
The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Drag-and-drop Data Modeling in Y42 (Part 2)
Use function nodes to transform your data. By Deborah Menezes
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (May 2022)
The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

Raw Google Analytics 4 (GA4) Data in BigQuery (BQ)
Investigate the first visits from users. By Sanu Maharjan

Drag-and-drop Data Modeling in Y42 (Part 1)
Start modeling your data with the Input and Field nodes. By Sanu Maharjan

Handle Google Analytics 4 Data in BigQuery Like a Pro
A Head Start: Still hanging around with Google’s Universal Analytics? It’s Time to be more profound with The New GA4! By Vaishnavee Baskaran
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (April 2022)
The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

How to do Data integration with Y42 | Quick Guide
How Y42 can take ELT to the next level. By Deborah Menezes
/pictures/ls_highlight_filter.gif)
Latest Updates on Google Data Analytics (March 2022)
The highlights of the updates on BigQuery, Data Studio, Google Analytics (GA) & Google Tag Manager (GTM). By Alexander Junke

New Data Studio (Looker Studio) feature: New blending menu
The ultimate guide for the new blending possibilities. By Alexander Junke
Bleib informiert
Erhalte die neuesten Einblicke und Updates von unseren Data Analytics-Experten.