Explain what final methodology you used to determine this stack rank and provide 1 – 3 bullet points for each market that help explain why that market performed well or poorly.

Excel
Question 1:
Please give your stack rank of markets in terms of overall performance from best (#1) to worst (#5). Explain what final methodology you used to determine this stack rank and provide 1 – 3 bullet points for each market that help explain why that market performed well or poorly.

Question 2:
Please give 1 – 2 strategic recommendations for each market based on your analysis of the data that could help improve performance in that market. This can be high-level or tactical (e.g. Market X: acquisition costs are higher than average, investigate more efficient marketing channels).

SQL
Question 1:
Write a query to calculate the
average earnings per hour spent dashing by day of week.

Question 2:
Write
a query to see how many dashes and deliveries were generated for each zip code
in submarket 13.

Question 3:
Write
a query to identify who the most efficient dasher was in terms of deliveries
per time spent dashing during the month of October 2017.

Question 4:
Write
a query to determine what percent of total pay is generated by dashers
completing an average of 2 or more deliveries per hour in October 2017?

The questions and the data set is in the excel file.

Last Completed Projects