Data analyst
Budget: €8 – €30 EUR
Data analyst, i need asap
1) Calculate the total number of unique searches with 100% coverage and illustrate the unique searches.
2) Illustrate in a chart the demand and supply throughout the week.
3) In a form of a 24x7 grid (hour-weekday grid), visualize a coverage heatmap.
4) If it was possible to introduce higher pricing during specific hours to increase supply and decrease demand, what weekly schedule of price multipliers would you choose? Visualise in a heatmap and provide specific multipliers.
5) Find the 5-hour period (consecutive hours) with highest demand and calculate how much we can spend on driver incentives, given that we want to re-invest all the revenue received in this timeframe. Assume that Finished Rides have the average value of €10 and our commission is 20%.
6) Estimate the number of weekly trips we could have done (finished) with maximum Coverage Ratio.
7) Find the 5 most utilized hours of the week (not necessarily consecutive), and calculate the sum of trips finished in these 5 hours. Explain how you understand the concept of driver utilization rate.
1) Calculate the total number of unique searches with 100% coverage and illustrate the unique searches.
2) Illustrate in a chart the demand and supply throughout the week.
3) In a form of a 24x7 grid (hour-weekday grid), visualize a coverage heatmap.
4) If it was possible to introduce higher pricing during specific hours to increase supply and decrease demand, what weekly schedule of price multipliers would you choose? Visualise in a heatmap and provide specific multipliers.
5) Find the 5-hour period (consecutive hours) with highest demand and calculate how much we can spend on driver incentives, given that we want to re-invest all the revenue received in this timeframe. Assume that Finished Rides have the average value of €10 and our commission is 20%.
6) Estimate the number of weekly trips we could have done (finished) with maximum Coverage Ratio.
7) Find the 5 most utilized hours of the week (not necessarily consecutive), and calculate the sum of trips finished in these 5 hours. Explain how you understand the concept of driver utilization rate.