Oyekanmi Olamilekan·Oct 8, 2025Building a Modern Data Pipeline with dbt, Postgresql and Docker.This project implements a modern data analytics pipeline for the Superstore Sales dataset using PostgreSQL, dbt, and Docker.
Oyekanmi Olamilekan·Jun 28, 2025From Spreadsheets to SQL: Mastering SQL Concepts Using the Superstore Dataset — Part 4 of 5This part we’ll use SQL to answer real-world business questions across sales, profit, operations, customer behavior, and more — all using…A response icon2A response icon2
Oyekanmi Olamilekan·Jun 28, 2025From Spreadsheets to SQL: Mastering SQL Concepts Using the Superstore Dataset — Part 3 of 5Now, it’s time to normalize this dataset — breaking it into smaller, logical tables to improve efficiency, reduce redundancy, and ensure…A response icon1A response icon1
InDev GeniusbyOyekanmi Olamilekan·Jun 27, 2025From Spreadsheets to SQL: Mastering SQL Concepts Using the Superstore Dataset — Part 2 of 5Welcome back to the second part of “From Spreadsheets to SQL”! In Part 1, we covered the fundamentals of SQL and databases — what they are…A response icon1A response icon1
Oyekanmi Olamilekan·Jun 27, 2025From Spreadsheets to SQL: Mastering SQL Concepts Using the Superstore Dataset — Part 1 of 5This article walk you through from understanding core concepts of databases to translating the Superstore dataset into a relational…A response icon2A response icon2
Oyekanmi Olamilekan·Jun 10, 2025Step-by-Step Guide: Launch a Linux System Using Vagrant on Mac or Windows (Ubuntu 22.04.3 LTS)Ever wanted to test scripts or configurations on a clean Linux box — without dual booting or spinning up a cloud instance (AWS or Azure)…
Oyekanmi Olamilekan·Jun 2, 2024“Speed Up Your Analytics”: Dockerized Olist Ecommerce DatasetAs a data engineer have you ever thought of the possibility of dockerizing a database with existing data?
InDev GeniusbyOyekanmi Olamilekan·Nov 5, 2023Portfolio Project Approach to Learning SQL (Part 2).Now, in Part 2, our goal is to dive headfirst into exploring the dataset using a wide array of SQL commands. We’ll unlock the power of SQL…
InDev GeniusbyOyekanmi Olamilekan·Nov 5, 2023Portfolio Project Approach to Learning SQL (Part 1).This blog post is born out of my passion for mastering SQL and the desire to share my progress with others. With every line of code I write
InDev GeniusbyOyekanmi Olamilekan·Sep 27, 2023Understanding PostgreSQL Database Administration.In this post I focused on guiding you on how to install PostgreSQL and DBeaver to your OS. As a DataEngineer…A response icon2A response icon2