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.