DEV Community

Jesse Ngugi profile picture

Jesse Ngugi

Backend and data enthusiast documenting my journey in databases, data science, and automation. Sharing practical developer tutorials.

Location Nairobi, Kenya Joined Joined on  Email address ngugigichuki21@gmail.com Personal website https://portfolio.ngugi.workers.dev github website twitter website

Education

LuxDevHQ.ai

Pronouns

HE / HIM

Work

Data Analyst at CoffeeKenya.Coop

SQL window functions I wish I knew earlier
ngugiauraa profile

SQL window functions I wish I knew earlier

#sql #datascience #windowfunctions #dataanalysis
Comments
4 min read

Want to connect with Jesse Ngugi?

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

Create Account
Already have an account? Sign in
Building a churn model that actually gets used
ngugiauraa profile

Building a churn model that actually gets used

#jupyternotebook #datascience #machinelearning #churnmodel
Comments
4 min read
Why I stopped using pandas for everything
ngugiauraa profile

Why I stopped using pandas for everything

#pandas #polars #duckdb #datascience
Comments
4 min read
Version control - Git and Github
ngugiauraa profile

Version control - Git and Github

#git #github #githubactions #datascience
1
Comments
3 min read
Python and how Python is used in the data analytics space.
ngugiauraa profile

Python and how Python is used in the data analytics space.

#python #jupyter #datascience #programming
Comments
5 min read
Subqueries vs CTEs in SQL: Master Nested Queries and Write Cleaner, Smarter Code
ngugiauraa profile

Subqueries vs CTEs in SQL: Master Nested Queries and Write Cleaner, Smarter Code

#sqlsubqueries #commontableexpressions #ctesinsql #sqlbestpractices
1
Comments
6 min read
How to Publish a Power BI Report and Embed It into a Website: A Complete Step-by-Step Guide
ngugiauraa profile

How to Publish a Power BI Report and Embed It into a Website: A Complete Step-by-Step Guide

#powerfuldevs #datascience #dataanalytics #beginners
2
Comments
6 min read
Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained
ngugiauraa profile

Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained

#datascience #dataanalytics #datamodelling #powerbi
Comments
5 min read
The Role of Microsoft Excel in Real-World Analytics:
ngugiauraa profile

The Role of Microsoft Excel in Real-World Analytics:

#microsoftexcel #datascience #dataanalytics #programming
Comments
5 min read
A Beginner’s Guide to Installing PostgreSQL and Connecting It to DBeaver in minutes
ngugiauraa profile

A Beginner’s Guide to Installing PostgreSQL and Connecting It to DBeaver in minutes

#database #seo #postgres #dbeaver
2
Comments
4 min read
loading...