Diksha Madan – Medium

Diksha Madan

Diksha Madan

JSON Column Unnesting: A Guide to Transforming BigQuery Data in Snowflake

If you have worked on or seen GA4 data in BigQuery, you’d know how some columns are not integers or strings, but JSON. This is because GA4…

Mar 11

JSON Column Unnesting: A Guide to Transforming BigQuery Data in Snowflake

Mar 11

Diksha Madan

Campaign Analysis in PowerBI using GA4 Data in BigQuery

We will see what kind of insights can we gather from the data, and what some of the questions can be answered from the data using SQL, PBI.

Nov 28, 2023

Campaign Analysis in PowerBI using GA4 Data in BigQuery

Nov 28, 2023

Diksha Madan

How to Fetch Data From an API and Save as a CSV File using Python

Photo by Ferenc Almasi on Unsplash

Nov 15, 2023

How to Fetch Data From an API and Save as a CSV File using Python

Nov 15, 2023

Diksha Madan

BigQuery + GA4: Create GA4 Metrics using SQL in BigQuery — Part II

This is Part 2 of BigQuery + GA4: Create GA4 Metrics using SQL in BigQuery. In this, we’ll try to understand some advanced GA4 metrics and…

Sep 6, 2023

BigQuery + GA4: Create GA4 Metrics using SQL in BigQuery — Part II

Sep 6, 2023

Diksha Madan

BigQuery + GA4: Create GA4 Metrics using SQL in BigQuery

Since bigQuery collects raw data from GA4, everything in the form of dimensional value with complex nesting of rows, it becomes essential…

Sep 1, 2023

BigQuery + GA4: Create GA4 Metrics using SQL in BigQuery

Sep 1, 2023

Diksha Madan

Advanced SQL Functions

Let's discuss some advanced SQL topics- CTE Functions, Row_number(), rank() and dense_rank() functions.

Jul 30, 2023

Advanced SQL Functions

Jul 30, 2023

Diksha Madan

Data Layer Implementation: Unleashing the full potential of Google Tag Manager

The data layer is a crucial component in the world of digital analytics and website tracking. This empowers a marketer to unleash the full…

Jun 17, 2023

Data Layer Implementation: Unleashing the full potential of Google Tag Manager

Jun 17, 2023

Diksha Madan

Twitter Data Pipeline using Airflow and AWS

Let's create an end-to-end data pipeline using Twitter API, Airflow and AWS. This project is just an introduction to how EC2 Instance can…

Apr 30, 2023

Twitter Data Pipeline using Airflow and AWS

Apr 30, 2023

Diksha Madan

GA4 E-commerce DataLayer for Add-ons & Customized Products

DataLayer is a common word when you are associated with Tag Manager in any way. DataLayer is the most robust way to track events in GA4. It…

Feb 16, 2023

GA4 E-commerce DataLayer for Add-ons & Customized Products

Feb 16, 2023

Diksha Madan

Understanding ELT and ETL Pipelines

If you are new to Data Engineering, or for that matter data in general, you would have come across the words like pipeline, ETL, ELT, Data…

Feb 4, 2023

Understanding ELT and ETL Pipelines

Feb 4, 2023

Diksha Madan

Diksha Madan

Passionate data enthusiast transforming raw numbers into actionable insights for a brighter, data-driven future.

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams