ROTIMI AYOMIDE
PORTFOLIO

Data Analyst skilled in SQL, PowerBI and Excel @6urnt1

Supply Chain & Logistics Analysis

In this project, I designed a supply chain logistics & shipping analytics dashboard to evaluate transportation efficiency, disruption risks, and shipment patterns — quantifying a 61.26% disruption rate, 19.36-day average lead time, and 38,520,319 km total distance covered, with air and sea modes showing highest shipment volumes and hurricanes posing the greatest weather-related risk.

Procurement Compliance Performance Analysis

In this project, I developed a data-driven analytical framework to evaluate supplier performance, compliance, and savings from negotiated prices — quantifying 7.97% savings and 82.24% compliance, with top-performing suppliers driving measurable value.

Pizza Sales Performance & Revenue Analytics

In this project, I performed a comprehensive pizza sales analysis using SQL for data extraction and transformation, and Power BI for interactive visualization, to assess revenue trends, examine order volume patterns, and identify best-selling pizza categories by revenue contribution and sales quantity.

Oraimo Product Performance & Sales Analysis

In this project, I designed and implemented a Power BI–driven product performance dashboard to assess total units sold, compare product demand, and identify high- and low-performing Oraimo products to support data-driven inventory and sales decisions.