SQL Portfolio Project - Part 1 - | OLA | UBER | Namma Yatri | Analytics | Ashutosh Kumar
HTML-код
- Опубликовано: 6 сен 2024
- 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 yatri dataset . You can find the code attached below -
CODES
drive.google.c...
EXCEL
docs.google.co...
----------------------------------------------------------------------------------------------------------------------
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.co...
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
sql portfolio projects playlist - ruclips.net/p/PLbTF1OfX62c1wb8fsf_n1kQGOi2YEM3no
codes - ruclips.net/user/redirect?event=video_description&redir_token=QUFFLUhqbk51TUJ2SkNudmVGWmVzUWhlU2lRNnlUUWhKZ3xBQ3Jtc0ttRGg4bUd6YkFtSWNwS3JjYVEyNjZObjFiRWtwS19FNzcyNkttcUk0SHNEMWt0S1JPMjB1cG5mWDZtakZhVHlZRnVfUzcwZFNpdkNBbzlEa2otUTJKQUlCNmNueEViSUNXdXl5V1dBWjNLVXZXUUVLYw&q=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F1neULQCoX1RKrx2NjK17K-UlaVShy7iP3%2Fview%3Fusp%3Dsharing&v=nsSIe1GB_84
That's a fascinating approach for a project! You've also inspired me with an idea for my own personal project. Thank you, Ashutosh, for sharing this. I always learn new things from your channel.
Thanks a lot
its very helpful tutorial sir thanks a lot
😀
Would you please share the dataset? In the description you have the links of code .
Thank you so much sir
for all the knowledge
Thx
Hi Ashutosh,
Why have not you used the table trips in your very first query since we only need to calculate the total trips that has happened and is completed? Why you have used trip_details table which consists of both the case-end_ride=1 and end_ride=0?
really excited ashutosh
can you please get some point how I will be beneficial after completing this project because its too long project and I have only 1 week to add or to do projects so can I be beneficial or not just I want to know what I get in kep points after doing this
Hi Ashutosh, I use Mac book, please tell me how to use Power BI on Mac?
where to get the excel file used in the video,please help urgent
trip_details table not present in the database.There are trip_details1,2,3,4 are present?
Actually you can not insert more than 1000 rows in ssms at once in a temp table , so to make the trip details table which consisted of ~3000 rows I made 4 temp tables and then did union of all of them . At last you can see I have done union and made the final trip details table
@@AshutoshKumaryt ok ..got it ... thank you!
@@AshutoshKumaryt THe code for trip_details table is not present only the union of the 1 2 3 into 4 is present
pls help
i cant find the code for create table trips_details it still shows doesnt exist all i can see is the union for 1 2 3 into 4
In part 2 in the comments section u have mentioned part 1 link not part 3
Yes part 3 will release on Thursday
Thanks for the confirmation
Thanks 🙏🙏
can this code run in mysql ???
Yes
Can you share that data in the form of database which we can easily import
You can find the same code in the description box
where is the link of the sql file code
Sir do real world projects end to end
Yeah this is one of them
from where I can download this Dataset
Please find the link in the description box
hi @AshutoshKumaryt there are some problems in the Code file that you missed "loc_from" all the trips_details code and it is giving error I fixed but just want to inform you
fixed , thx !