Analyzing DoorDash Sales Throughout The Year

Ever since we experienced a lockdown for the first time, food delivery services have appeared and increased rapidly. Customers got used to the convenience of getting their food brought to them, and everyday there are more and more users following this trend.

I personally use this service not more than twice a week, since making it a habit can become very expensive. That got me thinking, how many people are ordering for Doordash and what are their food preferences? How old are their customers?

Using a dataset I found online, I started digging into interesting and key facts about DoorDash sales and their customers.

Using Microsoft Excel, we analyzed a 2,000 row data set and found:

• $1.13 Million was spent on DoorDash in 2018
• 67% of the spend variance can be explained by income levels
• Growth throughout the year was mostly constant at 183 new customers per month, with November and December being the low, and January being the high.

You can download the data set here

Starting with the Data

The following dataset was given as a data analyst use case for an interview process. Although this study has been done for educational purposes, it's based on real data.

These are the most important columns for our study:

• Income: Customer's Yearly Income
• MntTotal: Total Amount Spent at Store by Customer
• Customer_Days: How Many Days Has Customer Been a Customer
• DateJoined: The date the customer first became a customer

Each row represents a single DoorDash customer:

Why Do Some People Spend More

One of my main questions was always about the people who love food delivery and the ones who don't. There could be many different reasons some people prefer this service, but based on the data set we have, we could conclude that the higher their income is, the more they spend on DoorDash. I managed to create a scatterplot that shows this correlation.

With a 67% accuracy, we can predict how much money will someone spend on DoorDash based on their income.

DoorDash User's Growth

Another curious fact about the food delivery service had to do with the months when there's new users. In our dataset, we had the date a user joined the service. By getting the month's name out of that date and combining them, we could find which months were the highest and which ones were the lowest in terms of users joining DoorDash.

Conclusions

After analyzing our data set, we found that people love DoorDash so much, that they are willing to spend $1.13 Million. We also noticed that 67% of this money is related to the user's income levels.

In terms of growth, we can conclude that the average of new customers per month is 183. The lowest months for new customers subscribing to the service were November and December, and the highest month was January, followed by March.

Thank you very much for your attention. If you have any observations or question about this study, please feel free to reach out to my email: diegomanssur@gmail.com.

I'm also looking for new opportunities in data analytics. If you have any, let me know.