No video

A Data-Driven Case Study Analysis (Doordash, Uber)

  Рет қаралды 92,119

LearnAnalytics Org

LearnAnalytics Org

Күн бұрын

Walk over how a Analytics Case Study looks like --Example is from Food Delivery.
Talk about the prompt, bring business insights, and how to build a finished product/solution.

Пікірлер: 112
@artempohribnyi
@artempohribnyi 8 ай бұрын
This is very useful. Thanks a lot for sharing. I’m struggling now with my own case study for a portfolio. And it’s like when you understand everything, but don’t know what to start with 😅
@christopherchang4625
@christopherchang4625 10 ай бұрын
This is super helpful for an analyst with a case study interview coming up, thank you!!
@anastasiosvra9024
@anastasiosvra9024 Ай бұрын
Interesting case study and thanks for sharing your work with us. I see though that the middle part of this analysis is missing, the part which you manipulate the data and prepare it for analysis. You shared with us the first part, pretty interesting to see the raw process of thinking and identifying where should you look for insights and which questions should you try to answer. Then there is a gap and finally we are seeing the fruits of your analysis with charts, comments etc. Its equally important and crucial for all us data analysts to learn the tools you used, the process you followed, the data manipulation you did, like formulas, custom columns, pivot tables, maybe grouping any make more. That's real gold. What ever you can share, even in comments, would be highly highly appreciated and helpful for your audience🙂.
@learnanalyticsorg
@learnanalyticsorg 24 күн бұрын
True, next case study ill share more on the data manipulation piece. Thank you
@pandagamerz9566
@pandagamerz9566 2 жыл бұрын
Great video guy
@jenif3r1
@jenif3r1 Жыл бұрын
Great video! You seemed bit nervous but is wonderful how you manage to teach us all this valuable info. Thanks!!
@poojasikdar3583
@poojasikdar3583 5 ай бұрын
very insightful. Thanks.
@YashSharma-eq3sn
@YashSharma-eq3sn 2 жыл бұрын
Thanks for deconstructing such type of case studies it was really useful.
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
Glad u found it useful Yash!
@stephanieblack6231
@stephanieblack6231 2 жыл бұрын
thanks for making this! You're helping a newbie!
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
Glad you enjoyed the video, we will make more videos. stay tune.
@MiguelHernandez-oe8tl
@MiguelHernandez-oe8tl Жыл бұрын
Awesome example, thank you for sharing!
@showmoon2789
@showmoon2789 2 жыл бұрын
Thank you very much for sharing your results, I was given a similar case study and this was extremely helpful in perspectives and ideas, cheers!
@learnanalyticsorg
@learnanalyticsorg Жыл бұрын
Glad it was insightful
@Sparta.10
@Sparta.10 Жыл бұрын
Hey Matt, could you please share the dataset, on like google docs if you would be kind sir!
@user-yc7yt1vc3w
@user-yc7yt1vc3w 7 ай бұрын
Hi thank you so much, where can i download this data set?
@zenalu9568
@zenalu9568 11 ай бұрын
GREAT VIDEO! Thank you so much for sharing
@johnsuscovich4085
@johnsuscovich4085 2 жыл бұрын
This was such a great and helpful video. Thank you.
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
Great, if you enjoyed it please give it a like and subscribe for more content.
@aizhan6161
@aizhan6161 2 жыл бұрын
Hi, thanks for sharing! How can I find more Data Analytics Interview Cases for practice?
@RG-kk5oo
@RG-kk5oo 7 ай бұрын
Super useful! can you provide similar dataset?
@shittabeyjoshua1484
@shittabeyjoshua1484 3 жыл бұрын
How did you work with the date-time format? I can see 01 03:08:09. That definitely signifies dd hh:mm:ss. Wouldn't you have a negative value or error if the time stamp falls in a new month? Like, having the order time at 31 23: 50: 59 and delivery time at 1 00 : 20: 45.
@darthramen441
@darthramen441 2 жыл бұрын
Bump on this. How was this and the timezone change to from UTC to PT calculated?
@ching-yenlin855
@ching-yenlin855 2 жыл бұрын
My way is using mid function to separate Day/HH/MM/SS and convert to the same unit (min or sec), with a if statement to check if delivered date and placed order date are not the same day and placed order date is 31, then to add give special calculation to those cases.
@moniquethakur9669
@moniquethakur9669 2 жыл бұрын
@@ching-yenlin855 Curious what kind of equation you applied to those cases where deliveries were the next day?
@user-wr4yl7tx3w
@user-wr4yl7tx3w Жыл бұрын
I’m not sure what to generalize from your presentation. It’s specific to those locations. Is there an overarching point?
@Calvin-ok1pg
@Calvin-ok1pg Жыл бұрын
Great content! thanks. Are you able to share how you created those charts? Thanks.
@learnanalyticsorg
@learnanalyticsorg Жыл бұрын
the graphs were created in google sheets
@user-ln6zu5lc7l
@user-ln6zu5lc7l 7 ай бұрын
Hi This is really useful, where can I get this data set, thank you!
@SandeepSingh-pn3nm
@SandeepSingh-pn3nm 4 ай бұрын
hey r u making this assignment for marketing analytics needed one help
@mattmcallister
@mattmcallister 2 жыл бұрын
Does anyone know how to convert the timestamps in excel to calculate the difference between timestamps? Any help would be appreciated!
@dangeradams58240
@dangeradams58240 Жыл бұрын
this was really helpful. Thanks.
@Yeonp
@Yeonp 2 жыл бұрын
thank you so much! Great video!
@rulez161
@rulez161 2 жыл бұрын
Thanks for sharing. Would the analysis have been possible with excel formulas - without using python/sql?
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
Yes of course, you can do both data analysis and data visualizations in excel. it is a powerful tool
@Justamomhere
@Justamomhere Жыл бұрын
Can anyone complete this for me? I’ll pay to have this completed in the next 36 hours.
@ngunghuong6938
@ngunghuong6938 Жыл бұрын
Thank you very much, its really helpful!
@learnanalyticsorg
@learnanalyticsorg Жыл бұрын
Glad it was helpful!
@ad_astra_crimson
@ad_astra_crimson 3 жыл бұрын
For a beginner that want to penetrate/transition to Data Analytics what books or subjects should I focus on? I do have basic excel knowledge and that's just about it. Thanks!
@learnanalyticsorg
@learnanalyticsorg 3 жыл бұрын
Hey there Mark! I'd recommend learning about the basics of statistics as that is core to data analysis and machine learning. There are plenty of books out there, or even video series (Skillshare, Coursera, KZfaq) where you can get started on this. Data becomes more fun when you seek out a dataset that is interesting to you! What I mean is: if you can ask basic data questions around a subject/topic you enjoy, you're more prone to seek out answers for something you already have interest in. Start with Stats, move on to SQL, and then Python. My recommendation is to look at a job you'd want to have in 1-2 years, and see what skills would be necessary to land that job!
@ad_astra_crimson
@ad_astra_crimson 3 жыл бұрын
Thanks for the tips! I'll look into those!
@anirbanpatra3017
@anirbanpatra3017 Жыл бұрын
Can I get a copy of your assignment? It's very hard to follow along without the materials
@deeparai5552
@deeparai5552 2 жыл бұрын
Can you please share the data set?
@keithhoyt100
@keithhoyt100 3 жыл бұрын
Nicely done. How long did it take for them to get back to you to arrange next-step interviews?
@learnanalyticsorg
@learnanalyticsorg 3 жыл бұрын
Took them about 3-4 days to arrange to next steps. Fairly quickly
@ilyayuzefovich8150
@ilyayuzefovich8150 Жыл бұрын
How was the date/time conversion to something that can be summed/subtracted done? having trouble subtracting the date/times
@learnanalyticsorg
@learnanalyticsorg Жыл бұрын
Hello! Did you give datediff function a try?
@abigailnenkai1619
@abigailnenkai1619 Жыл бұрын
Hello is it possible for you to share the data sheet for one to practice with
@mrrahulkansal
@mrrahulkansal 10 ай бұрын
Thank you for the video, I would like to know how to obtain a dataset like this?
@SandeepSingh-pn3nm
@SandeepSingh-pn3nm 4 ай бұрын
hey r u making this assignment for marketing analytics needed one help
@youtubevanced5913
@youtubevanced5913 2 жыл бұрын
Where do one get link to that google doc you are sharing on the screen?
@madankaran21
@madankaran21 2 жыл бұрын
Thanks for sharing. I have the same dataset for the interview and am getting the same numbers as you are showing in this video. Is it okay to follow your approach and present to them? I am sure they also know that the solution is already online for this. Wondering what's the catch here 😲
@utkarshkumar5575
@utkarshkumar5575 2 жыл бұрын
can you please share the link of dataset ?
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
I think its best to take what you learn in this video and try to apply your own approaches. I am sure creative is valued, this intent is to be a starting point :)
@dannywallace1358
@dannywallace1358 2 жыл бұрын
How did your interview go? I have this same data set exercise as I'm interviewing with a large food delivery app.
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
@@dannywallace1358 it went well. moved onto the next round.
@dannywallace1358
@dannywallace1358 2 жыл бұрын
@@learnanalyticsorg did you complete your analysis only in excel or did you use Postgres SQL
@silentgeek9620
@silentgeek9620 3 жыл бұрын
Pls provide dataset and link for the same
@learnanalyticsorg
@learnanalyticsorg 3 жыл бұрын
For anyone looking for similar dataset, refer to this person's github, it is very similar. ghayward.github.io/TipsAnalysis_June2018.html
@skynetrules340
@skynetrules340 2 жыл бұрын
What is the diffrence between customer placed order time vs placed order with restaurant time.? They both should be same right?
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
Hello, these can be different for example. Customer placed order time is when customer placed the order while restaurant order placed time is when the restaurant time of order actually goes through. It depends on how the dataset is good to check if they are different or same.
@MashiroRedo
@MashiroRedo 2 жыл бұрын
Really helpful vid! How was the "45 min Delivery Time" report created? I'm trying to figure out the name to creat a similar one for practice.
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
Hey Mashiro! thanks for your question - we are trying something new and started a community page on Luma, let me know if you are interested to join and can ask questions there.
@lizashtonda8508
@lizashtonda8508 11 ай бұрын
@@learnanalyticsorghi! Thanks for such a useful video! I’d like to join your community if it’s possible 🙏🏻
@mohamedfaeezmohamedaroos394
@mohamedfaeezmohamedaroos394 3 жыл бұрын
Do you mind sharing the link to your Facebook group, please? I am working on a similar exercise for big tech and would love to hear some feedback/insights.
@TheDarkchaos25
@TheDarkchaos25 Жыл бұрын
His english is very good, he doesnt think before speaking
@giggslhf
@giggslhf 3 жыл бұрын
Thanks for sharing! Just out of curiosity did you pass this analytics test?
@learnanalyticsorg
@learnanalyticsorg 3 жыл бұрын
Yes
@zeeshanmalik4708
@zeeshanmalik4708 3 жыл бұрын
Thanks for sharing
@bhuralal5299
@bhuralal5299 2 жыл бұрын
Please make more case studies.
@melikaahmadi6630
@melikaahmadi6630 2 жыл бұрын
Especially online shop and e-commerce commpanies
@mohamed.montaser
@mohamed.montaser Жыл бұрын
great work, can you share the dataset?
@alexrichter2381
@alexrichter2381 2 жыл бұрын
Hello! I was given this case study as well, are you able to help me formulate the graphs? I'm having trouble.
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
What trouble are you facing?
@bradb8792
@bradb8792 2 жыл бұрын
Thanks again for this AWESOME video! I have my assessment now and not the greatest with charts and graphs. Can anyone simply tell me how to manipulate the day and time fields to make pivot charts and graphs in excel ? I’m really struggling here.
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
happy to help, can you share your email and we can take it off.
@jamylemichael2203
@jamylemichael2203 2 жыл бұрын
@@learnanalyticsorg Hi, I am having the same issue with the timestamps in the pivot tables. Can you assist?
@simplya1651
@simplya1651 2 жыл бұрын
Hi @@learnanalyticsorg, would you be able to show me how to manipulate as well? Your help would be greatly appreciated!
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
@@jamylemichael2203 Hey we are trying something new and started a community page on Luma, let me know if you are interested to join and can ask questions there.
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
@@simplya1651 Hey there! we are trying something new and started a community page on Luma, let me know if you are interested to join and can ask questions there.
@XDataLab
@XDataLab 2 жыл бұрын
can you share masked data set or link for data ?
@noebautista4754
@noebautista4754 3 жыл бұрын
Thanks! Do you use more techniques ?
@learnanalyticsorg
@learnanalyticsorg 3 жыл бұрын
Thanks Noe, are you asking what additional techniques are useful for case studies?
@noebautista4754
@noebautista4754 3 жыл бұрын
@@learnanalyticsorg yep and another tools like python, thanks!
@mhmodsalla587
@mhmodsalla587 3 жыл бұрын
Upwork project sent me here, many thanks
@learnanalyticsorg
@learnanalyticsorg 3 жыл бұрын
Cool, what do you mean by Upwork project?
@varunsingh.varunsingh
@varunsingh.varunsingh 2 жыл бұрын
Can we access this data? And how?
@jgojiz
@jgojiz Жыл бұрын
Beautfiful
@Mohammedismailsiddiqui
@Mohammedismailsiddiqui Жыл бұрын
hey how can i get uber eats data pleasehelp
@alialmahari5439
@alialmahari5439 Жыл бұрын
Can I have the dataset File?
@mariadanicar.esparrago1320
@mariadanicar.esparrago1320 Жыл бұрын
Question: What is your tool in generating these insights?
@piec1
@piec1 Жыл бұрын
was the slide done in powerpoint?
@learnanalyticsorg
@learnanalyticsorg Жыл бұрын
Yes it was done in slides format.
@kashch785
@kashch785 3 жыл бұрын
I really doubt you passed this case. If restaurant 9 has such a high amount of daily average then how can restaurant 350 have higher average orders. it should be 9 or 20 or any other that generated higher revenue. if I take 30$ to be average order size then restaurant 350 does not even come close. The basic math is not sound
@kanishkchandra5679
@kanishkchandra5679 3 жыл бұрын
@@rontep6162 i actually got this case, merchant 9 has higher order volume and avg order amount as well. I also found the RFM of customers and clustered them and saw which region was better customer wise. I tried a few other things but did a lot of things similar to what is done in the video. But I was not taken to the next round. Very confused about this lol
@lindaporter5172
@lindaporter5172 2 жыл бұрын
Search a Great video
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
Thank you. We plan on creating another case study video soon. Stay tune.
@RaviSingh-xx2wq
@RaviSingh-xx2wq 2 жыл бұрын
I wish you could share the code as well. Otherwise really good work. :)
@learnanalyticsorg
@learnanalyticsorg Жыл бұрын
I dont have the code at hand, but hopefully it helped you!
@datascience880
@datascience880 3 жыл бұрын
I can't see the dataset on your Facebook?
@learnanalyticsorg
@learnanalyticsorg 3 жыл бұрын
Check out this persons github as well. ghayward.github.io/TipsAnalysis_June2018.html
@samwiseup
@samwiseup 2 жыл бұрын
Why can't I leave comments?
@learnanalyticsorg
@learnanalyticsorg 2 жыл бұрын
i think you are able to
@samwiseup
@samwiseup 2 жыл бұрын
Hi, for some reason when I comment on my laptop the comment is deleted. I just wanted to say it was an excellent video and I thought for the benefit of beginners or BI developers like myself wanting to transition to analytics, it would be great if you could do a follow-on video covering the many statistical concepts you implicitly relied on in this video. A question i had was on the last visualisation, have you split the data into quartiles ordered by delivery time (overall I assume ie placed to delivered), chosen the top 3 quartiles, and given the medians within those quartiles? And if yes, why did you choose to only show the top 3 rather than 4 quartiles and why did you find it of value to highlight in bold the second quartile (50%)? Thank you.
@samwiseup
@samwiseup 2 жыл бұрын
When I say a video on, what I mean was a video on WHY, I know what the median is I know what a quartile is etc
@niiniiy9940
@niiniiy9940 2 жыл бұрын
1:38
@lushunci5978
@lushunci5978 2 жыл бұрын
umm
@haroldmarquez8471
@haroldmarquez8471 6 ай бұрын
You hesitate too much er er er it is difficult to understand
Data Analyst Case Study Interview
15:57
LearnAnalytics Org
Рет қаралды 10 М.
Grow Your Career in Strategy & Operations | Hosted by DoorDash
58:52
Strategy & Operations @ Doordash
Рет қаралды 4,8 М.
Joker, what is this doing?!#joker #shorts
00:31
Untitled Joker
Рет қаралды 9 МЛН
黑天使遇到什么了?#short #angel #clown
00:34
Super Beauty team
Рет қаралды 32 МЛН
UNO!
00:18
БРУНО
Рет қаралды 4,1 МЛН
Day in the Life of a Data Analyst - SurveyMonkey Data Transformation
1:17:14
Shashank Kalanithi
Рет қаралды 3,4 МЛН
Learn how to SOLVE a data analytics case study problem
14:21
Jay Feng
Рет қаралды 73 М.
How to Solve a DATA ANALYTICS CASE STUDY
8:23
Mo Chen
Рет қаралды 43 М.
Joker, what is this doing?!#joker #shorts
00:31
Untitled Joker
Рет қаралды 9 МЛН