AkarExcel/Bolt-Trip-Analysis-Project-Report

This project investigates Bolt Nigeria’s trip data for the period of September 1 to September 30, with the aim of improving operational efficiency, revenue performance, and customer experience. Using the PPDAC analytical framework and Power BI for data modeling and visualization, the study evaluates trip patterns, rider behavior... ## Bolt Trip Analysis Project Report ### Executive Summary This project investigates Bolt Nigeria’s trip data for the period of September 1 to September 30, with the aim of improving operational efficiency, revenue performance, and customer experience. Using the PPDAC analytical framework and Power BI for data modeling and visualization, the study evaluates trip patterns, rider behavior, and location-based demand across the company’s service ecosystem. The analysis reveals that Bolt completed approximately 104 thousand trips, generating a total booking value of about 388.4 million naira. The average trip produced about 3,700 naira in revenue, with most trips covering short urban distances of roughly 1 kilometer and lasting an average of 16 minutes. These metrics indicate that Bolt’s business model in Nigeria is largely driven by high frequency, short distance mobility in dense urban centers. Customer behavior shows a strong preference for daytime travel, with daytime trips nearly doubling nighttime trips. Payment patterns remain predominantly cash based, accounting for about 67 percent of all transactions. This suggests limited adoption of digital payment options and highlights an opportunity for Bolt to promote wallet usage through targeted incentives. Spatial analysis identifies Kosofe as the dominant mobility hub, serving as both the most frequent pickup and dropoff location. Other high demand zones include Eko Atlantic, Lekki, Ikotun, and Ogba. These hotspots align with commercial and residential activity centers and form the backbone of Bolt’s operational network. Vehicle category comparisons show that Bolt Premium generates the highest booking value and records the highest number of pickups. Despite the higher cost of premium services, customer preference appears to favor comfort and reliability. Average booking amounts, however, remain consistent across vehicle types due to uniform pricing structures. Overall, the project provides actionable insights for opti …