Diksha MadanBuilding ETL Pipeline: Stock Market Data to PostgreSQL with PythonIn this article, I’ll walk you through the process of building an ETL (Extract, Transform, Load) pipeline using Python to fetch real-time…3d ago33d ago3
Diksha MadanJSON Column Unnesting: A Guide to Transforming BigQuery Data in SnowflakeIf 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 11Mar 11
Diksha MadanCampaign Analysis in PowerBI using GA4 Data in BigQueryWe 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, 2023Nov 28, 2023
Diksha MadanHow to Fetch Data From an API and Save as a CSV File using PythonPhoto by Ferenc Almasi on UnsplashNov 15, 20231Nov 15, 20231
Diksha MadanBigQuery + GA4: Create GA4 Metrics using SQL in BigQuery — Part IIThis 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, 2023Sep 6, 2023
Diksha MadanBigQuery + GA4: Create GA4 Metrics using SQL in BigQuerySince bigQuery collects raw data from GA4, everything in the form of dimensional value with complex nesting of rows, it becomes essential…Sep 1, 2023Sep 1, 2023
Diksha MadanAdvanced SQL FunctionsLet's discuss some advanced SQL topics- CTE Functions, Row_number(), rank() and dense_rank() functions.Jul 30, 2023Jul 30, 2023
Diksha MadanData Layer Implementation: Unleashing the full potential of Google Tag ManagerThe 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, 2023Jun 17, 2023
Diksha MadanTwitter Data Pipeline using Airflow and AWSLet'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, 2023Apr 30, 2023
Diksha MadanGA4 E-commerce DataLayer for Add-ons & Customized ProductsDataLayer 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, 2023Feb 16, 2023