Denzel Kanyeki articles - 18 total
Building a Fraud Detection Pipeline using Python, PostgreSQL, Apache Kafka, PySpark, Grafana and Scikit-learn
Introduction Fraud doesn’t happen once in a while, it happens every second. Every card...
Building a Real-Time Data Pipeline using Binance Websocket API, PySpark, Kafka and Grafana
Introduction Ever wondered how data is consumed in real-time via websockets? In this...
Using Data Engineering to Track Food Prices and Inflation in Kenya from 2006 to 2025
Rising food prices continue to be a critical issue affecting many households in Kenya. As a data...
A Real-Time Earthquake Monitoring Pipeline with Kafka, MySQL, PostgreSQL, and Grafana
In this project, I designed and built an end-to-end real-time data pipeline that monitors earthquakes...
Building a Real-Time Crypto Pipeline with Binance APIs, PostgreSQL, Debezium, Kafka, Spark & Cassandra
Introduction In this blog post, I’ll walk you through a real-time crypto data pipeline I...
Tracking Kenya’s External Debt Using Python, PostgreSQL, and Grafana
We always hear about Kenya’s external rising debt in headlines, but how fast is it growing? And what...
Extracting Data from the Premier League YouTube Channel Using `googleapiclient`, PySpark, Airflow, PostgreSQL and Grafana
Introduction In this post, I’ll walk you through how I built a scalable ETL data pipeline...
Testing Airflow DAGs 101: A Practical Guide for Modern Data Teams.
Apache Airflow is an essential tool for data engineers. Data engineers use Airflow to automate,...
Building a Stock Data Pipeline with requests, Apache Airflow and PostgreSQL
In this tutorial, I will walk you through how I built a fully functional ETL pipeline using Apache...
dbt for Normies - A Complete Guide.
Whether you are new to data engineering or you are quite conversant with the dataverse, you should...
Building and Deploying My First Python ETL Package to PyPI
Introduction Creating your own Python package is one of the most satisfying steps as a...
Learn Python Basics for Data Engineering (with Mini Project)
In today’s data-driven world, Data Engineers are the architects of pipelines that move and transform...
SQL for Beginners - A Complete Guide.
Introduction Structured Query Language (SQL) is a language that is used to interact with...
🚀 Building an ETL Pipeline with Python to Scrape Internship Jobs and Load into Excel
Have you ever needed up-to-date job listings but struggled to find one clean source? In this project,...
The Complete Guide to Time Series Models.
In this post, I would like to cover in detail what is time series analysis and time series models....
Data Modeling and its Importance in Data Science.
What is data modeling? Data modeling is the process used in database management to create a...
Exploratory Data Analysis(EDA) using Data Visualization Techniques.
Introduction to Exploratory Data Analysis: Exploratory Data Analysis is essential in the Data Science...
Data Science Roadmap 2023-2024 for beginners.
Before we get to the roadmap, let's answer the question, What's data science? Data science is the...