## DriveOut Analytics Dashboard: Multi-Page Visual Breakdown
[cite_start]This multi-page Power BI dashboard serves as a comprehensive visual predictive analytics platform for the DriveOut ride company dataset[cite: 7, 140]. [cite_start]The architecture translates raw transactional data across Lagos ride operations into high-impact, executive-level business intelligence[cite: 7, 140].
---
### PAGE 1: Pricing Dynamics & Demographic Insights
[cite_start]The first page focuses on the foundational relationship between core pricing metrics, regional distribution, and ride consumer demographics[cite: 7].
* [cite_start]**Executive Summary KPI Metrics:** Houses central performance figures detailing total aggregate distance metrics and pricing yields[cite: 2, 4, 5].
* [cite_start]**Monthly Revenue Optimization Analysis:** Features a structured matrix mapping out ride durations against financial performance[cite: 8, 9]. [cite_start]It explicitly pinpoints **May (the 5th month)** as the peak revenue generation period, achieving a yield of **N6 Million**[cite: 9].
* [cite_start]**Weekend Payment Infrastructure Distribution:** A clear area graph evaluating user transaction choices during weekends[cite: 18]. [cite_start]It demonstrates a heavy reliance on **Cash and E-Cards/Wallets**, noting a structural pivot toward electronic channels over the weekend due to regular financial houses being closed[cite: 18].
* [cite_start]**Demographic Segmentation (Marital Status):** A clean donut chart dissecting total client distribution[cite: 10, 11]. [cite_start]It shows remarkably balanced market usage across four distinct consumer categories: **Widowed (25.8%), Single (25.8%), Married (24.7%), and Divorced (23.7%)**[cite: 20, 21, 23, 24].
* [cite_start]**Geospatial Coverage Index:** Tracks total ride coverage across critical Lagos pickup locations (including Agege, Alimosho, and Surulere), isolating specific spikes in mileage where the kilometers are structurally longer[cite: 40, 41, 50, 51].
---
### PAGE 2: Operational Choice & Profit Maximization
[cite_start]The second page investigates how consumer ride selections under different traffic conditions impact the company's overall profit margins and driver performance ratings[cite: 72, 73, 74].
* [cite_start]**Market Share by Car Type:** A pie chart illustrating that the **Premium Model** captures the dominant share of total distance covered at **38%**, followed by Comfort at 25%, Executive at 23%, and Economy at 13%[cite: 76, 79, 82, 84, 86].
* [cite_start]**Vehicle Brand Fleet Performance:** A detailed line-and-area visualization detailing the total cumulative distance across primary manufacturers[cite: 77]. [cite_start]It highlights **Toyota (37.1K km) and Hyundai (36.6K km)** as the clear fleet leaders due to consumer convenience preferences[cite: 77, 78, 90, 88].
* [cite_start]**Weekend Traffic Density Highlight:** A breakdown showing that **Moderate Traffic** conditions constitute the highest operational environment share at **32.57%**, with Heavy traffic sitting at 28.66% and Very Heavy at 19.14%[cite: 75, 93, 106, 111].
* [cite_start]**Order Integrity Tracking:** A metric analysis tracking order cancellations to measure overall fleet booking retention[cite: 113].
---
### PAGE 3: Qualitative Performance & Financial Close out
[cite_start]The final page offers a qualitative and quantitative review of overall system throughput, transactional volumes, and driver ratings[cite: 140].
* [cite_start]**Total Sales Liquidity by Payment Medium:** Isolates exactly which transaction methods favor the business infrastructure, revealing **Cash** as a top liquidity driver at **906K**, outperforming direct Card payments (687K), Wallets (614K), and Bank Transfers (569K)[cite: 134, 136, 137, 139].
* [cite_start]**Driver Quality Rating Assessment:** Maps out the score distributions (clustering heavily around a professional 3.50 to 3.80 scale) and evaluates ratings by customer professional occupation[cite: 126, 128, 129, 132, 142]. [cite_start]It shows **Civil Servants** providing the highest overall cumulative assessment score at **218.30**[cite: 144, 147].
* [cite_start]**Hourly Traffic & Duration Highlights:** A dual-axis line graph analyzing vehicle distribution and estimated travel times across a 24-hour cycle, validating specific demand surges[cite: 145, 149].
* [cite_start]**Revenue Yield by Week Day:** A chart tracking total ride prices across the weekly calendar[cite: 161]. [cite_start]It identifies **Monday** as the highest total revenue yield day due to the massive surge of the professional working commuter base[cite: 162].
* [cite_start]**Dropoff Destination Revenue Tracking:** A clear regional table mapping total financial yield against dropoff locations, identifying high-yield transit zones such as **Badagry** at **N272,845.57**[cite: 156, 157].