How suhani059/logistics-delivery-analytics works
This repository is a logistics-delivery analytics project. Its main workflow prepares raw delivery data, explores and queries the cleaned data, presents performance in a Power BI dashboard, and turns findings into recommendations. The README documents these relationships; no source excerpts were provided, so implementation-level calls and dashboard internals cannot be verified.
Main entry points: logistics_and _delivery_dashboard.pbix Power BI Dashboard · README.md Business Insights · delivery_cleaned.csv Cleaned Dataset · 02_Data_Cleaning.ipynb Data Cleaning
Components 11
Data Preparation
- Raw Dataset
Dataset/delivery.csv - Data Cleaning
notebooks/02_Data_Cleaning.ipynb - Cleaned Dataset
Dataset/delivery_cleaned.csv - Data Loading
notebooks/01_Data_Loading.ipynb
Business Analysis
- Exploratory Analysis
notebooks/03_Exploratory_Data_Analysis.ipynb - SQL Analysis
sql/Delivery_SQL_Analysis.sql
Reporting & Action
- Power BI Dashboard
Dashboard/logistics_and _delivery_dashboard.pbix - Dashboard Export
Dashboard/logistics_and _delivery_dashboard.pdf - Business Insights
README.md - Recommendations
README.md
Other components
- Analyst
Connections 17
- Analyst → Data Loading: loads data
README.md - Data Loading → Raw Dataset: reads
README.md - Analyst → Data Cleaning: cleans data
README.md - Data Cleaning → Raw Dataset: processes
README.md - Data Cleaning → Cleaned Dataset: saves
README.md - Analyst → Exploratory Analysis: explores data
README.md - Exploratory Analysis → Cleaned Dataset: analyzes
README.md - Analyst → SQL Analysis: queries data
README.md - SQL Analysis → Cleaned Dataset: analyzes
README.md - Analyst → Power BI Dashboard: builds dashboard
README.md - Power BI Dashboard → Cleaned Dataset: reports on
README.md - Power BI Dashboard → Dashboard Export: exports
- Power BI Dashboard → Business Insights: supports
README.md - SQL Analysis → Business Insights: informs
README.md - Exploratory Analysis → Business Insights: informs
README.md - Business Insights → Recommendations: inform
README.md - Analyst → Power BI Dashboard: monitors KPIs
README.md