Building ETL pipeline using Google Cloud Storage

From Kaggle Data Dump to Clean Data: Hands-on Project with Zomato API Data using Python and GCS, you’ll see how raw datasets can be ingested, cleaned, and stored for analysis.

Everything about “Slowly Changing Dimensions” or SCD’s

While working on any data projects or watching Data-related videos, you must have encountered the term “Slowly Changing Dimensions” or SCDs.

Running dbt transformations on local Postgres database

This blog post guides you through the procedure of running dbt transformations on a local Postgres database and transforming data using SQL and Jinja templates. Finally, we will set up a Streamlit server to visualize the data using a plotly graph library.

Extracting Yahoo Finance Stock Data: Building a Simple ETL Script

In this blog, we will delve into the workings of Yahoo Finance’s historical data and explore Extract, Transform, Load (ETL) script that powers this pipeline.