Skip to content

Build a data warehouse, ask SQL queries and make key visualizations with PowerBI to find real-life logistics insights

Notifications You must be signed in to change notification settings

nmhongtram/logistics-operations-database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Logistics Operations Data Warehouse & Data Analysis Project

About Dataset

As described in [1], this dataset is a complete operational database from a fictional Class 8 trucking company spanning three years (2022-2024). This isn't scraped web data or simplified tutorial content—it's a realistic simulation built from 12 years of real-world logistics experience, designed specifically for analysts transitioning into supply chain and transportation domains.

The dataset contains 85,000+ records across 14 interconnected tables covering everything from driver assignments and fuel purchases to maintenance schedules and delivery performance. Each table maintains proper foreign key relationships, making this ideal for practicing complex SQL queries, building data pipelines, or developing operational dashboards.

Most logistics datasets are either proprietary (unavailable) or overly simplified (unrealistic). This fills the gap: operational complexity without confidentiality concerns.

More details about the dataset can be found in the original source [1].

High Level Architecture of Data Warehouse

high level architecture


Reference:

[1] Yogape Rodriguez (2025), Logistics Operations Database

About

Build a data warehouse, ask SQL queries and make key visualizations with PowerBI to find real-life logistics insights

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages