priscillaedinamattah/Competitor_Analysis_Dashboard

An interactive Excel dashboard comparing Ghana's top ride-hailing companies across key metrics.(BOLT,SHAXI,UBER AND YANGO) Competitor Analysis Dashboard – Ride-Hailing Companies in Ghana Overview This project is an interactive Excel dashboard created to analyze and compare the performance of major ride-hailing companies in Ghana: Bolt, Uber, Yango, and Shaxi. The dashboard provides insights into: Revenue performance Total bookings Active drivers Market leadership Monthly performance trends The goal of the project was to transform raw business data into meaningful insights using data analysis and visualization techniques in Microsoft Excel. Project Objectives Analyze the performance of ride-hailing companies in Ghana Compare competitors using key business metrics Identify market leaders by revenue and bookings Track monthly performance trends Build an interactive and visually appealing dashboard Dataset The dataset used in this project contains: Company names Monthly revenues Total bookings Active drivers Monthly operational records from January to December The data was cleaned and structured before analysis to ensure accuracy and consistency. Tools & Skills Used Tools Microsoft Excel Skills Demonstrated Data Cleaning Data Analysis Dashboard Design Data Visualization Pivot Tables Pivot Charts KPI Reporting Trend Analysis Interactive Dashboard Development Project Steps 1. Data Collection Collected and organized ride-hailing company data for analysis. 2. Data Cleaning Removed duplicates Corrected formatting issues Standardized company names Checked for missing values 3. Data Analysis Analyzed key metrics such as: Total Revenue Total Bookings Active Drivers 4. Dashboard Creation Built an interactive Excel dashboard using: Pivot Tables Pivot Charts Slicers KPI Cards Bar and Line Charts 5. Data Visualization Designed charts to compare: Market leaders by revenue Market leaders by bookings Monthly revenue and booking trends Dashboard Features Interactive month filter (Jan–Dec) Revenue comparison by company Booking comparison by company Monthly trend analysis KPI summary cards C …