David Mwandairo

Data Engineer | Data Scientist Passionate about building scalable data pipelines, uncovering insights from complex datasets, and leveraging AI/ML to solve real-world problems.

Joined on May 26, 2026

David Mwandairo

Sep 29

Python Basics in the Matatu Context

#python #programming #tutorial #basics

10 min read

Want to connect with David Mwandairo?

Create an account to connect with David Mwandairo. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

David Mwandairo

Sep 29

Cleaning and Analyzing Tembo Hotel's Bookings

#showdev #postgres #sql #dataanalysis

27 min read

David Mwandairo

Sep 24

Building the SafariConnect Dashboard

#showdev #project #powerbi #dashboard

9 min read

David Mwandairo

Sep 23

The SafariConnect Data Story

#showdev #sqlproject #dataanalysis #postgressql

17 min read

David Mwandairo

Sep 22

Handling NULL Values in SQL

#sqlnullvalues #database #tutorial #postgres

6 min read

David Mwandairo

Sep 22

Window Functions: Seeing the Group Without Losing the Row

#windowfunctions #database #tutorial #postgres

6 min read

David Mwandairo

Sep 22

SQL Functions: The Toolbox Hiding Inside Every SELECT

#sqlfunctions #database #tutorial #postgres

7 min read

David Mwandairo

Sep 21

Subqueries and CTEs: Asking a Question Inside a Question

#sql #database #tutorial #ctes

8 min read

David Mwandairo

Sep 21

SQL Joins Explained: A Beekeeping Co-op in Six Queries

#sql #tutorial #database

7 min read

David Mwandairo

Sep 21

DDL and DML: how a database designs a room and remembers who escaped it

#sql #database #tutorial #postgres

8 min read

David Mwandairo

Jul 5

A Step-by-Step Tutorial on Power BI’s Local and Cloud Connections

#postgres #powerbi #tutorial #database

5 min read

David Mwandairo

Jun 29

Connecting Data the Right Way: Modeling, Relationships, and Schema Design in Power BI

#learning #data #modelling #powerbi

6 min read

David Mwandairo

Jun 15

Linux Fundamentals for Data Engineering

#linux #dataengineering #cli #learning

8 min read

DEV Community

David Mwandairo

GitHub Repositories

Python Basics in the Matatu Context

Want to connect with David Mwandairo?

Cleaning and Analyzing Tembo Hotel's Bookings

Building the SafariConnect Dashboard

The SafariConnect Data Story

Handling NULL Values in SQL

Window Functions: Seeing the Group Without Losing the Row

SQL Functions: The Toolbox Hiding Inside Every SELECT

Subqueries and CTEs: Asking a Question Inside a Question

SQL Joins Explained: A Beekeeping Co-op in Six Queries

DDL and DML: how a database designs a room and remembers who escaped it

A Step-by-Step Tutorial on Power BI’s Local and Cloud Connections

Connecting Data the Right Way: Modeling, Relationships, and Schema Design in Power BI

Linux Fundamentals for Data Engineering