All
Articles 108,292Blog Posts 119,537Tech Tutorials 27,416Research Papers 22,424News 16,451
⚡ AI Lessons
Dev.to · John Wakaba
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo 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
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo 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
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo 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
💻 AI-Assisted Coding
⚡ AI Lesson
3mo 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
📊 Data Analytics & Business Intelligence
4mo 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
🧠 Large Language Models
⚡ AI Lesson
4mo 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
📐 ML Fundamentals
⚡ AI Lesson
4mo 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
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
4mo 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
📊 Data Analytics & Business Intelligence
4mo 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
☁️ DevOps & Cloud
4mo 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
📊 Data Analytics & Business Intelligence
5mo 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
🔧 Backend Engineering
5mo 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
📊 Data Analytics & Business Intelligence
7mo 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
📊 Data Analytics & Business Intelligence
8mo 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
📐 ML Fundamentals
⚡ AI Lesson
11mo ago
UNSUPERVISED LEARNING
Unsupervised learning falls under machine learning and it deals with unlabeled data. Without any...
DeepCamp AI