Goodcabs Business requests

Goodcabs business request

Business request 1:
City-Level Fare and Trip Summary Report

• generate report displaying total trips, average fare per km, average fare per trip & percent contribution for each city

city_name	totaltrips	fareper_km	tripfare	percentcontribution
Jaipur	76,888	16.12	483.92	0.18
Lucknow	64,299	11.76	147.18	0.15
Surat	54,843	10.66	117.27	0.13
Kochi	50,702	13.93	335.25	0.12
Indore	42,456	10.90	179.84	0.10
Chandigarh	38,981	12.06	283.69	0.09
Vadodara	32,026	10.29	118.57	0.08
Visakhapatnam	28,366	12.54	282.67	0.07
Coimbatore	21,104	11.15	166.98	0.05
Mysore	16,238	15.13	249.71	0.04

Business request 2:
City level trips target performance
instructions:

• if actual trips are greater than target trips, mark it as “Above Target”.
• if actual trips are less than target trips, mark it as “Below Target”.

• for months Apr, May, Jun: Chandigarh above target
• for months Jan,Feb,Mar: Chandigarh below target
• for months Jan,Feb,Mar,Apr, May, Jun: Coimbatore above target
• for months Jan,Feb,Mar: Indore above target
• for months Apr, May, Jun: Indore below target
• for months Apr, May, Jun: Jaipur above target
• for months Jan,Feb,Mar: Jaipur below target
• for months Jan,Feb,Mar: Kochi above target
• for months Apr, May, Jun: Kochi below target
• for months Jan,Feb,Mar,Apr, May, Jun: Mysore above target
• for months Jan,Feb,Mar: Surat above target
• for months Apr, May, Jun: Surat below target
• for months Jan,Feb,Mar: Visakhapatnam above target
• for months Apr, May, Jun: Visakhapatnam below target
• for months Jan,Feb,Mar,Apr, May, Jun: Vadodara below target
• for months Jan,Feb,Mar,Apr, May, Jun: Lucknow below target

Business Request 3:
City-Level Repeat Passenger Trip Frequency

• generate report showing percentage distribution of repeat passenger by number of trips taken for each city

• for repeat trip frequency categorized under 2 trips it is Jaipur that contributes the most 8%

• for repeat trip frequency categorized under 2 trips Kochi that contributes 6%
• for repeat trip frequency categorized under 2 trips Indore and Visakhapatnam that contribute 4%
• for repeat trip frequency categorized under 2 trips Indore and Visakhapatnam that contribute 4%
• for repeat trip frequency categorized under 2 trips Chandigarh that contribute 3%
• for repeat trip frequency categorized under 2 trips Lucknow that contribute 2%
• for repeat trip frequency categorized under 2 trips Vadodara, Surat & Mysore that contribute 1%
• for repeat trip frequency categorized under 3 trips Kochi, Jaipur & Indore that contribute 3%
• for repeat trip frequency categorized under 3 trips Visakhapatnam, Surat & Lucknow, Chandigarh that contribute 2%
• for repeat trip frequency categorized under 3 trips Vadodara, Mysore & Coimbatore that contribute 1%
• for repeat trip frequency categorized under 4 trips Lucknow that contribute 3%
• for repeat trip frequency categorized under 4 trips Surat,Jaipur and Indore that contribute 2% the rest contributed 1%
• for repeat trip frequency categorized under 5 trips Surat,Lucknow that contribute 3% the rest contributed 1%
• for repeat trip frequency categorized under 6 trips Surat,Lucknow that contribute 3% the rest contributed 1%
• for repeat trip frequency categorized under 7 trips Surat,Lucknow that contribute 2% while Vadodara and Indore contributed 1% the others contributed less the 0%
• for repeat trip frequency categorized under 8 trips Surat,Lucknow that contribute 1% while the others contributed less the 0%

Business Request 4: Identify Cities with highest and Lowest Total New Passengers

The top three cities are Jaipur, Kochi and Chandigarh

Surat, Vadodara and Coimbatore have the lowest total new passengers

Business Request - 5: Identity Month with Highest Revenue for each City

• in the month of February Jaipur had highest revenue
• in the month of May Kochi had highest revenue
• in the month of February Chandigarh had highest revenue
• in the month of February Lucknow had highest revenue
• in the month of April Visakhapatnam had highest revenue
• in the month of May Indore had highest revenue
• in the month of April Surat had highest revenue
• in the month of May Mysore had highest revenue
• in the month of April Vadodara had highest revenue
• in the month of April Coimbatore had highest revenue







Business request 6:
Repeat Passenger Rate Analysis

• calculate monthly RPR% and city RPR%











• Chandigarh has highest monthly RPR in May and June and lowest RPR in January
• Coimbatore has highest monthly RPR in May and lowest RPR in February
• Indore has highest monthly RPR in May and lowest RPR in January
• Jaipur has highest monthly RPR in May and lowest RPR in January
• Kochi has highest monthly RPR in May and lowest RPR in January
• Lucknow has highest monthly RPR in May and lowest RPR in January
• Mysore has highest monthly RPR in May & June and lowest RPR in February and January
• Surat has highest monthly RPR in May and lowest RPR in January
• Vadodara has highest monthly RPR in June and lowest RPR in January
• Visakhapatnam has highest monthly RPR in April and lowest RPR in January









• May has the highest city repeat passenger rate at .34 or 34% January has the lowest city repeat passenger rate at .20 or 20%
• from January to May there is an upward trend in city RPR% and then as we go from May to June we see the trend begin to reverse