Production grade Supply Chain & Logistics Optimization platform handling 100,000+ records. Built with Star Schema, Advanced DAX, and AI Root Cause Analytics in Power BI.
End-to-end logistics operations analytics project using SQL and Power BI. Built a relational database, created analytical views, and developed dashboards to analyze driver performance, revenue per trip, and on-time delivery trends.
🏗️ Modern Analytics Engineering project using dbt and BigQuery to model fleet operations. Implementing a Medallion Architecture, it transforms raw GPS data into a reliable Star Schema. Focuses on resolving data quality issues like sensor noise and duplicates through automated testing and CI/CD to ensure production-grade reporting.
Analyzing global flight patterns, passenger volumes, and airline performance to identify travel trends and logistics bottlenecks
This margin analysis quantifies unrecovered profit, identifies loss making jobs, clients, and routes, and delivers clear recommendations to improve pricing and operational efficiency.
End-to-end SQL analytics case study solving 7 real supply chain business problems across 180,519 orders. delivery performance, profitability, regional sales, and more.
Pipeline analítico de logística com PostgreSQL, dbt, Airflow e Streamlit para análise de SLA, performance regional e eficiência operacional aplicando arquitetura multicamadas e analytics engineering.
Supply chain analytics dashboard with Python, PostgreSQL and Power BI
Power BI Transport & Delivery Analytics Dashboard optimizing logistics. Features real-time GPS fleet tracking, route optimization, and multi-timeframe analytics to achieve a 40% reduction in delivery time, a 35% decrease in fuel consumption, and $75,000 in annual cost savings for supply chain operations.
End-to-end warehouse analytics system: SQL bottleneck detection, RandomForest delay prediction (ROC-AUC 0.876), and a 4-page Streamlit dashboard with automated business recommendations.
A Python-based decision support tool that forecasts short-horizon demand, evaluates capacity utilization risk, and produces prioritized mitigation actions with backtest accuracy (MAE/MAPE) and a professional PDF report.
An end-to-end Power BI dashboard analyzing sales performance, inventory efficiency, and logistics operations to identify revenue growth drivers and operational risks such as stockouts and late deliveries.
Real-time logistics monitoring system using Kafka, Spark Streaming, PostgreSQL, Docker, and Power BI for processing and visualizing live inventory and GPS data.
Análise de custos logísticos no e-commerce com foco na redução de frete e geração de insights financeiros (Potencial de~R$114 mil).
Interactive Excel logistics dashboard tracking OTIF, SLA compliance, delay trends and return rates across 200 shipments — revealing a 42.5% SLA breach rate and 235% increase in delays from January to July.
ML model to predict supply chain delivery delays using XGBoost
End-to-end Commerce & Logistics Analytics project using Python, SQL Server, and Power BI
Power BI dashboard analyzing OTIF, delivery performance, and supply chain KPIs to identify service bottlenecks and improve customer fulfillment outcomes.
EDA and dashboard for e-commerce delivery data
Optimizing logistics dispatch schedules using Simple Linear Regression to forecast delivery times.
Add a description, image, and links to the logistics-analytics topic page so that developers can more easily learn about it.
To associate your repository with the logistics-analytics topic, visit your repo's landing page and select "manage topics."