Data Analysis Project For Beginner Part 2 || Use Earphone || Uber Drive Excel Data Analysis 💛

Important : Please Use earphone/headphone and adjust the video speed according to you. I will adjust the it in next videos.
Hey Everyone : In this Second Part of Data Analysis Project's video , I have done the remaining operations based on Excel. We can get answers of following questions.
Q11. Get the unique start destinations
Q12. What is the total number of unique start destinations?
Q13. Show the total number of unique stop destinations
Q14. Show all the Uber trips that has the starting point of San Francisco.
Q15. What is the most popular starting point for the Uber drivers?
Q16. What is the most popular dropping point for the Uber drivers?
Q17. List the most frequent route taken by Uber drivers.
Q18. Show all types of purposes for the trip in an array.
Q19. Plot a bar graph of Purposes vs Distance.
Q20. Generate a pivot table of Purposes and the distance travelled for that particular Purpose.
Q21. Plot number of trips vs Category of trips.
Q22. What is proportion of trips that is Business and what is the proportion of trips that is Personal?
This project is done by Sadhna Singh Ma'am but she has done it using Python libraries (Numpy, Pandas,Matplotlib,Seaborn etc). I have tried it doing the same but using Excel. So please Go and watch the original video if you are interested in doing the same project in Python. Link is given below
LINK : • Project | Data Analysi...
Subscribe to the channel: ‪@aiwithuday‬
Follow me on Instagram: / analyst_uday
Connect me on LinkedIn: / udaybhan

[@muradayyad]

Thanks for ur Effort . But Pie Charts are usually used for showing the Distribution of Percentages or Proportions , and Line Charts are used to compare Values of particular Variable over TIME , so Bar Charts were the proper Pick for Comparing categorical Variables . Number of Trips has nothing to do with Miles , number of Trips is number of Journeys or Takes . To calculate the Proportion of Business Purpose u should have divided 647 by sum of Business and Personal Trips (647+6) then multiply by 100 . Thanks alot for ur Effort , ur Video came to Use for me .

[@aiwithuday]

Thanks for pointing out 😊 I will definitely try to avoid this type of miscommunication in the future videos. 🙏 I am happy that this video was useful for you.

[@sandeeprao4654]

The best uday bhai👍👍👍