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 theaverage earnings per hour spent dashing by day of week.
Question 2:
Writea query to see how many dashes and deliveries were generated for each zip codein submarket 13.
Question 3:
Writea query to identify who the most efficient dasher was in terms of deliveriesper time spent dashing during the month of October 2017.
Question 4:
Writea query to determine what percent of total pay is generated by dasherscompleting an average of 2 or more deliveries per hour in October 2017?
The questions and the data set is in the excel file.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
