Basic Data Analysis
Budget: $250 – $750 USD
Dataset Attached -- Here's the prompt (also, please review the ** below **)
** PLEASE RETURN ** a .docx file that can easily be converted to .pdf after any minor edits. Thank you! :)
**
Below is a glossary of definitions for the variables included in the data set:
**
Is ASAP: Equals TRUE for on-demand orders; FALSE for scheduled deliveries (e.g., a customer places an order at 10am for 12noon)
Order total: Amount customer spent (including delivery fee); units are in dollars
Amount discount: Amount of discounts redeemed (e.g., for referrals); units are in dollars
Amount of tip: Amount of tip given; units are in dollars
Refunded amount: Amount refunded to customer; units are in dollars
Times: Time is in UTC and we operate on PT
**
Please review the below and keep in mind when analyzing and assembling the .doxc, thank you!
**
Strategic analysis skills:
- Do you draw sound conclusions from data?
- As needed, do you highlight uncertainties (where data doesn't tell the full story), and how you might resolve those uncertainties with further investigation?
- Is your data analysis accurate?
- How creative and impactful are your recommendations and solutions?
**
A bias to action:
- Do actionable ideas and next steps accompany your recommendations?
Can you be scrappy while also thinking long-term and strategically?
**
Communication skills:
- Do you lead with principles when communicating a plan?
Is your written communication concise and clear?
- Do you present data in a way that is easy to digest and highlights key points?
**
Understanding of our business:
- Do you keep in mind the three sides of our marketplace?
Do you understand the context and strategies of marketplace businesses?
**
Attached is a month's worth of sample delivery data for [X COMPANY] from one of our earliest months of operation. This isn't the complete set, but it's comprehensive enough where you should be able to get a good look at the business. Feel free to make and clearly state any assumptions you need.
**
**
** PLEASE RETURN ** a .docx file that can easily be converted to .pdf after any minor edits. Thank you! :)
**
Below is a glossary of definitions for the variables included in the data set:
**
Is ASAP: Equals TRUE for on-demand orders; FALSE for scheduled deliveries (e.g., a customer places an order at 10am for 12noon)
Order total: Amount customer spent (including delivery fee); units are in dollars
Amount discount: Amount of discounts redeemed (e.g., for referrals); units are in dollars
Amount of tip: Amount of tip given; units are in dollars
Refunded amount: Amount refunded to customer; units are in dollars
Times: Time is in UTC and we operate on PT
**
Please review the below and keep in mind when analyzing and assembling the .doxc, thank you!
**
Strategic analysis skills:
- Do you draw sound conclusions from data?
- As needed, do you highlight uncertainties (where data doesn't tell the full story), and how you might resolve those uncertainties with further investigation?
- Is your data analysis accurate?
- How creative and impactful are your recommendations and solutions?
**
A bias to action:
- Do actionable ideas and next steps accompany your recommendations?
Can you be scrappy while also thinking long-term and strategically?
**
Communication skills:
- Do you lead with principles when communicating a plan?
Is your written communication concise and clear?
- Do you present data in a way that is easy to digest and highlights key points?
**
Understanding of our business:
- Do you keep in mind the three sides of our marketplace?
Do you understand the context and strategies of marketplace businesses?
**
Attached is a month's worth of sample delivery data for [X COMPANY] from one of our earliest months of operation. This isn't the complete set, but it's comprehensive enough where you should be able to get a good look at the business. Feel free to make and clearly state any assumptions you need.
**
**