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 22

Window Functions: Seeing the Group Without Losing the Row

#windowfunctions #database #tutorial #postgres

6 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 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