📰 Dev.to · John Wakaba
Articles from Dev.to · John Wakaba · 15 articles · Updated every 3 hours · View all reads
All
⚡ AI Lessons (9011)
ArXiv cs.AIDev.to · FORUM WEBForbes InnovationOpenAI NewsDev.to AIHugging Face Blog

Dev.to · John Wakaba
1d ago
ETL vs ELT: Which One Should You Use and Why?
A Beginner's Guide to Data Pipeline Architecture If you have ever worked with data or heard...

Dev.to · John Wakaba
2d ago
Advanced SQL Techniques Every Data Analyst Should Know
You can write a SELECT statement. You can JOIN tables and slap on a WHERE clause. But somewhere...

Dev.to · John Wakaba
2d ago
CONNECTING POSTGRESQL WITH POWERBI (FOR A LOAN PERFORMANCE DASHBOARD)
INTRODUCTION Power BI is one of the most widely used business intelligence tools out...

Dev.to · John Wakaba
1mo ago
Building an AI-Powered Personalized Learning Platform with FastAPI, PostgreSQL, and Mistral AI
Artificial Intelligence is transforming education by enabling systems that adapt to individual...

Dev.to · John Wakaba
1mo ago
# Understanding Joins and Window Functions in SQL
When working with relational databases, data is rarely stored in one single table. Instead, it is...

Dev.to · John Wakaba
1mo ago
## I Built an AI Tourism Assistant for Kenya Using RAG, pgvector, and Streamlit
Imagine asking: "What's the best luxury safari in Maasai Mara?" and instantly getting...

Dev.to · John Wakaba
1mo ago
🏠 Building a Machine Learning Property Price Predictor (From Web Scraping to Deployment
In this project, I built a complete end-to-end machine learning system that: Scrapes property...

Dev.to · John Wakaba
2mo ago
From Messy Data to Confident Decisions: How Analysts Use Power BI, DAX, and Dashboards in the Real World
Power BI skills are often misunderstood as “just reporting.” In reality, professional analysts use...

Dev.to · John Wakaba
2mo ago
📊 Understanding Schemas and Data Modelling in Power BI
Data modelling is the foundation of building scalable and high-performance dashboards in Power BI....

Dev.to · John Wakaba
2mo ago
Getting Started With Linux for Data Engineers (With Vi and Nano Examples)
If you're getting into data engineering, there's one skill that keeps showing up everywhere:...

Dev.to · John Wakaba
2mo ago
Real-World ETL Pipeline from a Public Google Sheet
Spreadsheets are everywhere. They’re easy to use, easy to share, and often become the first home of...

Dev.to · John Wakaba
2mo ago
Building a MedAdvantage RAF Engine with dbt & PostgreSQL (Step-by-Step Guide)
In this project, I built a mini Medicare Advantage Risk Adjustment Factor (RAF) engine using...

Dev.to · John Wakaba
4mo ago
INTRODUCTION TO DBT(Data Build Tool)
A Beginner-Friendly Guide to Modern Analytics Engineering This article introduces dbt (data build...

Dev.to · John Wakaba
5mo ago
🌍 Automating Africa’s Energy Data Collection Using Python, Playwright(+Why Playwright ?), and MongoDB (2000–2024)
⚡ Introduction In today’s data-driven world, access to reliable and structured energy data...

Dev.to · John Wakaba
8mo ago
UNSUPERVISED LEARNING
Unsupervised learning falls under machine learning and it deals with unlabeled data. Without any...
DeepCamp AI