An automated English/Urdu roadside rescue app for solo mechanics in Lahore that reduces manual coordination to 0% by capturing live browser GPS locations and offering instant upfront pricing in just 3 clicks.
Analyzed and transformed messy trip data from a 12-cab Rapido fleet into a clean, structured, and interactive Excel dashboard. The project involved cleaning and organizing raw data, identifying useful information, and creating summaries and visualizations to make the data easier to understand and analyze.
Excel features used: Fill Series, Sorting, Go To Special, Merge & Unmerge, Pivot Tables, Pivot Charts, and Slicers.
The final dashboard provides an easy-to-understand view of the cab trip data and helps turn raw, unorganized data into meaningful insights.