UBER Drive Case Study | Data Analysis Using Excel

[@phanhuyhoang3720]

I remember we only used average function when it is normal distribution. Other we should use median

[@wanderingsuku]

Thank you for the video. 1.5x for better clarity

[@stoicreader]

52:35 (for my assignment 😅😅) thanks man!

[@RSVERMA948]

in 5:18 you can double click on the edge rather than dragging it

[@himakshipahuja3015]

Amazing!! Thank you so much!!

[@nature7921]

Can you do an example of porttfolio project?

[@CloudyML]

Sure, we will add one on it

[@aatifzeya8070]

Hey man thanks for sharing this. It would be great, if you can share link, form where we can download the dataset.

[@CloudyML]

docs.google.com/spreadsheets/d/1nEXLARK3RjrPLsL9nei_j2-lRuHiEK8y/edit?usp=share_link&ouid=117552746394951055076&rtpof=true&sd=true

[@shubhamshukla5093]

​@@CloudyML Data is not in the original form. Some missing value in start date and end date is there. Also, some derived variable is also present in the data.

[@CloudyML]

@@shubhamshukla5093 You can take uber data from kaggle to work upon.

[@muradayyad]

How did u get the Time in Fraction ? In my Excel it was calculated in Time Format : 0:06:00 instead of 5.999999

[@CloudyML]

Hi Murad… Suppose you give 21:11:10 - 21:16:00 (in time format) the result will be 00:04:50 and when you multiply this result by 24*60 the result will be 4.83333…now this result is a fraction ….. Lets take another case.. When you do 21:11:00 - 21:16:00 (in time format) the result will be 00:05:00 and now when you multiply this by 24*60 you will get 5… The conclusion is when get result without seconds, the output is without fractions and when you get result in fraction format that mean the result has seconds also in it… I hope this clarifies your doubt

[@muradayyad]

@@CloudyML Thanks a lot for ur Explanation , i really appreciate ur Effort . I've followed along with u what u did in the Video and once more have tried it now , but it gives me always the Result 00:00:00 after multiplying the Outcome (00:06:00) with 24*60 . I don't know if i did sth wrong . I can't continue the Project without finishing this Step .

[@CloudyML]

@@muradayyad 00:05:00 jo hai…make sure it is in time format…not in General or integer format…. It’s suppose to be in Time format

[@muradayyad]

@@CloudyML It didn't work , but i thank u anyway for ur Consideration and Effort . I'll try to make do with this

[@CloudyML]

@@muradayyad If you are our existing learner, you can connect TA through chat support. Keep learning. Good luck.

[@beetelvj10]

We're is the practice excel sheet that was used in tutorial n must be there for viewers for practice ...

[@CloudyML]

docs.google.com/spreadsheets/d/1eC5agCeobbwEA44cyr5epk-Ir3tTN9QT/edit?usp=sharing&ouid=110220880814595264065&rtpof=true&sd=true

[@deeppatel4002]

@@CloudyML not working

[@CloudyML]

@@deeppatel4002 drive.google.com/file/d/1RqzSVxrue0w4krrZDPZRRQeqOJozEH5X/view?usp=sharing

[@deeppatel4002]

@@CloudyML Thanks Sir

[@roopthikav7275]

Sir, Could you suggest some more projects for Data analysis using Excel?

[@CloudyML]

You can take Covid dataset and analyze it using excel.

[@CloudyML]

Incase you want a full fledge course on data analysis, you can check our data analyst course, we have a lot of case studies and you can try those dataset to analyze in excel or in tableau / powerbi.

[@roopthikav7275]

@CloudyML Okay Sir, Thank You !

[@mohdtoufique7446]

Thanks...Can you post the link to Dataset...

[@CloudyML]

docs.google.com/spreadsheets/d/1nEXLARK3RjrPLsL9nei_j2-lRuHiEK8y/edit?usp=share_link&ouid=117552746394951055076&rtpof=true&sd=true

[@Rex-Solis]

Can i get this dataset

[@Mr.Potato23]

Brother why didn't you create any dashboard with the analysis you did ?

[@CloudyML]

The purpose was to show you without dashboard here. You can create from your side and see what analysis does it give.

[@ravitanwar9537]

please do this in python/sql as well

[@CloudyML]

Hi Ravi, you can try this in python. See what else you can get out of analysis using python.

[@omkarbelpatre5]

Thank you so much sir

[@NiRaVUnplugged]

I want to download practice data file

[@CloudyML]

you can check uber data on kaggle or in description

[@omkarbelpatre5]

Thank you

[@omkarbelpatre5]

Sir data analyst ke Excel me kya kya topic ana chahiye sir

[@rohitwadhave]

formulas and functions, conditional formatting, drop down, solver, scenaario testings, sort and filter, VLOOKUP, H lookups, pivot tables, charts, VBA, macros and finally make Excel dashboard Projects

[@omkarbelpatre5]

@@rohitwadhave please please ek full video banaona Excel For Data analyst please sir

[@CloudyML]

@@omkarbelpatre5 We already have a crash course on excel, check it. You can enroll for our data analyst course here where we have covered topics for data analyst in detail - www.cloudyml.com/analytics-course-package/

[@omkarbelpatre5]

@@CloudyML thank You sir