SQL Portfolio Project - Part 2 - | OLA | UBER | Namma Yatri | Analytics | Ashutosh Kumar
HTML-код
- Опубликовано: 15 сен 2023
- The best technique of learning a skill is completing a project which is based on real life scenario and when it comes to analytics , SQL is the one of the most asked skillset in all the interviews, so friends in this video i have created an end to end project on data analysis using SQL, thi will be relevant to all those people who want to make a career into data analytics, business analytics ,data science , in this video i have analysis on namma dataset .
Part 1 - • SQL Portfolio Project ...
You can find the code attached below -
CODES
drive.google.com/file/d/1neUL...
EXCEL
docs.google.com/spreadsheets/...
----------------------------------------------------------------------------------------------------------------------
Check out some more relevant content here
👉 SQL Portfolio Project Indian Census- Part 2
• SQL Portfolio Project ...
👉 SQL Portfolio Project - Shark Tank India
• SQL Portfolio Project ...
👉 How to Learn SQL
• How to learn sql for b...
👉 Complete playlist on Sql Interview questions and answers
• HackerRank SQL problem...
👉 Top free and best resources to learn analytics -
• Free and Best resource...
👉 How to become a data analyst complete roadmap-
• Data Analyst Complete ...
👉 Data analytics internships and job stipend-
• 70,000 + per month dat...
👉 Top 3 you tube channels to learn sql for free for beginners
• Video
👉 How to get data analytics internships-
• How to apply for data ...
👉Check out the roadmap to become a business analyst - • Business Analyst Compl...
👉All about analytics playlist-
• All about analytics
👉 Top 3 you tube channels to learn excel for free for beginners
• Top 3 you tube channel...
____________________________________________________________________
Fill the form below to subscribe yourself to the analytics jobs mailing list to receive regular job opening updates - docs.google.com/forms/d/e/1FA...
Why you should definitely fill the analytics job updates google form - • Job Openings into busi...
_______________________________________________________________________
Connect with me
📸Instagram - / ashutoszh
💻Linkedin- / ashutosh.analytics
_____________________________________________________________________
Comment down if you have any doubts
Please leave a LIKE 👍 and SUBSCRIBE ❤️ to my channel to receive more amazing content in data analytics and data science.
_____________________________________________________________________
🏷️ Tags
sql,
sql for analytics,
sql tutorials for beginners,
portfolio project sql,
sql portfolio project,
portfolio project on sql for resume,
sql interview portfolio project,
sql interview questions and answers,
sql for data analytics,
sql data science,
interview questions on sql,
sql hard questions,
sql problem solving,
ashutosh,
ashutosh kumar,
ashutosh kumar analytics
🏷️ HashTags
#sql #portfolio #project
Nicely understand
thankyou sir
Part 1 - ruclips.net/video/nsSIe1GB_84/видео.html
Part 3 ruclips.net/video/iVdNKGXsWDU/видео.html
Nice !! I’ll rather do this on Jupyter notebook using SQL kernel
hi i love yourvlog but the problem is thta your datset you gave to follow along is incomplete this is because their is no
trips_details;) in it only trips_details1,2,3,4; so my datset my output is not like yours cause we are getting something different .please what do i do and can you update it and send it to me thinks please check and see what i am saying
For the no. of trips cancelled by drivers, can we write this query: SELECT SUM(NOT driver_not_cancelled) AS trips_cancelled_by_driver
FROM trips_details;
bro how are you getting that tripdetails coloumn
Hi Ashutosh. Thank you for this insightful video. I have a question regarding query: Highest payment was made through which instrument. You took the first approach to find the maximum fare of that day and then found the payment method of it. But there are two records having maximum fare which is 1500 rupees. Can you please clarify this. Thanks again
Hi Ashutosh I have one question if the interviewer asks me about the end goal of this project, the problem statement and what I found then how should I tackle this question for this particular project
Hello @Ashutosh Kumar i found a mistake in code file which was provided. you enterd data of loc_from column but you are not written loc_from name in insert statement and create table statement . please check it
Hey thx for informing fixed it
@@AshutoshKumaryt ok but project is really good thank you for providing us
select top 1* from trips order by fare desc ; when i used this syntax it is showing error for me in mysql that - 1 is not valid at this position expecting EOF. PLEASE TELL
use the limit function it didnt work fro me as well use this
select*from trips;
select faremethod,count(distinct tripid) from trips
group by faremethod
order by count (distinct tripid)desc
LIMIT 1;
NOTEl MAKE YOUR NECCESSARY CHANGES ON THE DATASET YOU USE PLEASE
SELECT p.method
FROM (
SELECT faremethod, COUNT(DISTINCT tripid)
FROM trips
GROUP BY faremethod
ORDER BY COUNT(DISTINCT tripid) DESC
LIMIT 1
) AS t
inner JOIN payment AS p ON t.faremethod = p.id;
when can we expect part-3 ?
by the way great project bro👍
Part 3 ruclips.net/video/iVdNKGXsWDU/видео.html
also for those using postgre you can use the limit function instead of the top function to get top (5,2) of any position you want i noticed it and i decided to share
also mentor please help with the updated file cause the file you share doesn't have the (trips_details) please check and help me make correctiuons and send yop me i am very much intered in this data\set
Check the description box of this video for file link
ruclips.net/video/nsSIe1GB_84/видео.html
Sir I have started the vlog and the tutorial I just need the file to be updated and sent to me if you can not the vlog
@@kardiiobi321 check this
docs.google.com/spreadsheets/u/0/d/1CyKysHxqhGxdL7OqDm4o6IafJjYrpeO0/htmlview
@@kardiiobi321 sorry for the miscommunication
Hi Ashutosh
I am getting same sum of searches got estimate as sum (searches) 2161
Can you please help me out!!
This is bit vague , you can reach on insta will try - @ashutosh.analytics
Okay 👍
And thank you for this project
Learning so much from it