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
@artempohribnyi8 ай бұрын
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 😅
@christopherchang462510 ай бұрын
This is super helpful for an analyst with a case study interview coming up, thank you!!
@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🙂.
@learnanalyticsorg24 күн бұрын
True, next case study ill share more on the data manipulation piece. Thank you
@pandagamerz95662 жыл бұрын
Great video guy
@jenif3r1 Жыл бұрын
Great video! You seemed bit nervous but is wonderful how you manage to teach us all this valuable info. Thanks!!
@poojasikdar35835 ай бұрын
very insightful. Thanks.
@YashSharma-eq3sn2 жыл бұрын
Thanks for deconstructing such type of case studies it was really useful.
@learnanalyticsorg2 жыл бұрын
Glad u found it useful Yash!
@stephanieblack62312 жыл бұрын
thanks for making this! You're helping a newbie!
@learnanalyticsorg2 жыл бұрын
Glad you enjoyed the video, we will make more videos. stay tune.
@MiguelHernandez-oe8tl Жыл бұрын
Awesome example, thank you for sharing!
@showmoon27892 жыл бұрын
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 Жыл бұрын
Glad it was insightful
@Sparta.10 Жыл бұрын
Hey Matt, could you please share the dataset, on like google docs if you would be kind sir!
@user-yc7yt1vc3w7 ай бұрын
Hi thank you so much, where can i download this data set?
@zenalu956811 ай бұрын
GREAT VIDEO! Thank you so much for sharing
@johnsuscovich40852 жыл бұрын
This was such a great and helpful video. Thank you.
@learnanalyticsorg2 жыл бұрын
Great, if you enjoyed it please give it a like and subscribe for more content.
@aizhan61612 жыл бұрын
Hi, thanks for sharing! How can I find more Data Analytics Interview Cases for practice?
@RG-kk5oo7 ай бұрын
Super useful! can you provide similar dataset?
@shittabeyjoshua14843 жыл бұрын
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.
@darthramen4412 жыл бұрын
Bump on this. How was this and the timezone change to from UTC to PT calculated?
@ching-yenlin8552 жыл бұрын
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.
@moniquethakur96692 жыл бұрын
@@ching-yenlin855 Curious what kind of equation you applied to those cases where deliveries were the next day?
@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 Жыл бұрын
Great content! thanks. Are you able to share how you created those charts? Thanks.
@learnanalyticsorg Жыл бұрын
the graphs were created in google sheets
@user-ln6zu5lc7l7 ай бұрын
Hi This is really useful, where can I get this data set, thank you!
@SandeepSingh-pn3nm4 ай бұрын
hey r u making this assignment for marketing analytics needed one help
@mattmcallister2 жыл бұрын
Does anyone know how to convert the timestamps in excel to calculate the difference between timestamps? Any help would be appreciated!
@dangeradams58240 Жыл бұрын
this was really helpful. Thanks.
@Yeonp2 жыл бұрын
thank you so much! Great video!
@rulez1612 жыл бұрын
Thanks for sharing. Would the analysis have been possible with excel formulas - without using python/sql?
@learnanalyticsorg2 жыл бұрын
Yes of course, you can do both data analysis and data visualizations in excel. it is a powerful tool
@Justamomhere Жыл бұрын
Can anyone complete this for me? I’ll pay to have this completed in the next 36 hours.
@ngunghuong6938 Жыл бұрын
Thank you very much, its really helpful!
@learnanalyticsorg Жыл бұрын
Glad it was helpful!
@ad_astra_crimson3 жыл бұрын
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!
@learnanalyticsorg3 жыл бұрын
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_crimson3 жыл бұрын
Thanks for the tips! I'll look into those!
@anirbanpatra3017 Жыл бұрын
Can I get a copy of your assignment? It's very hard to follow along without the materials
@deeparai55522 жыл бұрын
Can you please share the data set?
@keithhoyt1003 жыл бұрын
Nicely done. How long did it take for them to get back to you to arrange next-step interviews?
@learnanalyticsorg3 жыл бұрын
Took them about 3-4 days to arrange to next steps. Fairly quickly
@ilyayuzefovich8150 Жыл бұрын
How was the date/time conversion to something that can be summed/subtracted done? having trouble subtracting the date/times
@learnanalyticsorg Жыл бұрын
Hello! Did you give datediff function a try?
@abigailnenkai1619 Жыл бұрын
Hello is it possible for you to share the data sheet for one to practice with
@mrrahulkansal10 ай бұрын
Thank you for the video, I would like to know how to obtain a dataset like this?
@SandeepSingh-pn3nm4 ай бұрын
hey r u making this assignment for marketing analytics needed one help
@youtubevanced59132 жыл бұрын
Where do one get link to that google doc you are sharing on the screen?
@madankaran212 жыл бұрын
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 😲
@utkarshkumar55752 жыл бұрын
can you please share the link of dataset ?
@learnanalyticsorg2 жыл бұрын
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 :)
@dannywallace13582 жыл бұрын
How did your interview go? I have this same data set exercise as I'm interviewing with a large food delivery app.
@learnanalyticsorg2 жыл бұрын
@@dannywallace1358 it went well. moved onto the next round.
@dannywallace13582 жыл бұрын
@@learnanalyticsorg did you complete your analysis only in excel or did you use Postgres SQL
@silentgeek96203 жыл бұрын
Pls provide dataset and link for the same
@learnanalyticsorg3 жыл бұрын
For anyone looking for similar dataset, refer to this person's github, it is very similar. ghayward.github.io/TipsAnalysis_June2018.html
@skynetrules3402 жыл бұрын
What is the diffrence between customer placed order time vs placed order with restaurant time.? They both should be same right?
@learnanalyticsorg2 жыл бұрын
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.
@MashiroRedo2 жыл бұрын
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.
@learnanalyticsorg2 жыл бұрын
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.
@lizashtonda850811 ай бұрын
@@learnanalyticsorghi! Thanks for such a useful video! I’d like to join your community if it’s possible 🙏🏻
@mohamedfaeezmohamedaroos3943 жыл бұрын
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 Жыл бұрын
His english is very good, he doesnt think before speaking
@giggslhf3 жыл бұрын
Thanks for sharing! Just out of curiosity did you pass this analytics test?
@learnanalyticsorg3 жыл бұрын
Yes
@zeeshanmalik47083 жыл бұрын
Thanks for sharing
@bhuralal52992 жыл бұрын
Please make more case studies.
@melikaahmadi66302 жыл бұрын
Especially online shop and e-commerce commpanies
@mohamed.montaser Жыл бұрын
great work, can you share the dataset?
@alexrichter23812 жыл бұрын
Hello! I was given this case study as well, are you able to help me formulate the graphs? I'm having trouble.
@learnanalyticsorg2 жыл бұрын
What trouble are you facing?
@bradb87922 жыл бұрын
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.
@learnanalyticsorg2 жыл бұрын
happy to help, can you share your email and we can take it off.
@jamylemichael22032 жыл бұрын
@@learnanalyticsorg Hi, I am having the same issue with the timestamps in the pivot tables. Can you assist?
@simplya16512 жыл бұрын
Hi @@learnanalyticsorg, would you be able to show me how to manipulate as well? Your help would be greatly appreciated!
@learnanalyticsorg2 жыл бұрын
@@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.
@learnanalyticsorg2 жыл бұрын
@@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.
@XDataLab2 жыл бұрын
can you share masked data set or link for data ?
@noebautista47543 жыл бұрын
Thanks! Do you use more techniques ?
@learnanalyticsorg3 жыл бұрын
Thanks Noe, are you asking what additional techniques are useful for case studies?
@noebautista47543 жыл бұрын
@@learnanalyticsorg yep and another tools like python, thanks!
@mhmodsalla5873 жыл бұрын
Upwork project sent me here, many thanks
@learnanalyticsorg3 жыл бұрын
Cool, what do you mean by Upwork project?
@varunsingh.varunsingh2 жыл бұрын
Can we access this data? And how?
@jgojiz Жыл бұрын
Beautfiful
@Mohammedismailsiddiqui Жыл бұрын
hey how can i get uber eats data pleasehelp
@alialmahari5439 Жыл бұрын
Can I have the dataset File?
@mariadanicar.esparrago1320 Жыл бұрын
Question: What is your tool in generating these insights?
@piec1 Жыл бұрын
was the slide done in powerpoint?
@learnanalyticsorg Жыл бұрын
Yes it was done in slides format.
@kashch7853 жыл бұрын
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
@kanishkchandra56793 жыл бұрын
@@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
@lindaporter51722 жыл бұрын
Search a Great video
@learnanalyticsorg2 жыл бұрын
Thank you. We plan on creating another case study video soon. Stay tune.
@RaviSingh-xx2wq2 жыл бұрын
I wish you could share the code as well. Otherwise really good work. :)
@learnanalyticsorg Жыл бұрын
I dont have the code at hand, but hopefully it helped you!
@datascience8803 жыл бұрын
I can't see the dataset on your Facebook?
@learnanalyticsorg3 жыл бұрын
Check out this persons github as well. ghayward.github.io/TipsAnalysis_June2018.html
@samwiseup2 жыл бұрын
Why can't I leave comments?
@learnanalyticsorg2 жыл бұрын
i think you are able to
@samwiseup2 жыл бұрын
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.
@samwiseup2 жыл бұрын
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
@niiniiy99402 жыл бұрын
1:38
@lushunci59782 жыл бұрын
umm
@haroldmarquez84716 ай бұрын
You hesitate too much er er er it is difficult to understand