SQL Portfolio Project - Part 3 - Faaso's | Analytics | Ashutosh Kumar
HTML-код
- Опубликовано: 25 июл 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 Faaso's dataset . You can find the code attached below -
DATASET CODE LINK - github.com/ashutoshkr103/Micr...
----------------------------------------------------------------------------------------------------------------------
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
SQL Portfolio Project - Part 1 - Faaso's - ruclips.net/video/X_pIuN4zVYc/видео.html
Hi Ashutosh, Can share your correct linkedIn Id
eagerly waiting for upcoming videos of this project.
thanks.......................till infinite
You are truly great, your dedication towards helping us understand is admirable. The way you have skillfully demonstrated small functions like trim, replace, cast, etc., as we've seen in this video is impressive. Please continue with this dedication.
Dil Se Bro"
Apart from this, I would suggest making similar videos for Power BI's DAX and demonstrating how to write the equivalent SQL queries.
Thank you very much
Wow sir you're just amazing
Great video sir
Great
Very Informative series. Please make more food delivery projects.
Very informative series you started ..please don't stop uploading and helping ..it means a lot to us ..shree ram blessings be with you🚩😊
Thanks
Please upload next part...!!! Thanks in advance
Sir is back ❤️❤️
Hey, to show the pyhon project we use github, so for sql project also we need to use github?
Hey can you tell me what topics of statistics very important for entry level data analysis.
Please sir
Need more queries on this project....waiting for Part 4, 5..... nicely explained
dada this is last of this series
Bhaiya, this is similar to 2nd case study of 8wksqlchallenge, where there are more queries to solve
Bro waiting for more projects
waiting for next series data is available on 8 weeksqlchalleng
43:58 my doubt is the average speed for a delivery person is right but why the question also included the average speed for each order id
Because anyways the average speed for the driver is calculated by every order taken by the driver, how can the average speed for each order is that means the
From pick the order and and delivered order what speed he goes by???? Clarifymy doubt❤
For Q5., average speed cannot have any relation with the number of rolls because speed is a relation between distance and rime. Number of rolls will not come into the picture. So if at all any relation has to be found, then that should be between distance and speed.
Can u plz explai what u write that a or b as alias ?? any article where we can read abt it? Is this same for even mysql?
that a or b is nothing but you can think like i am giving variable name to the subquery
didnot understand how sum(can_per) gives successfull delivery at "50:30 "
---what is the successful delivered percentage for each driver(my answer)
select driver_id, sum(can_per)*100/count(driver_id) as successful_orders from
(select *,case when lower(cancellation) like '%cancel%' then 0 else 1 end as can_per
from driver_order) a
group by driver_id
have you calculated speed in km/min unit?
Yes distance in km time in minutes
Code editor?
SQL server management studio
Select order_id, count(roll_id) as cnt , sum(DIFF)/count(roll_id) as Tym_Diff_per_order from
(Select * ,datediff(minute,a.order_date,b.pickup_time) DIFF
from customer_orders a join driver_order b
on a.order_id=b.order_id
where b.pickup_time IS NOT NULL) as c
group by order_id
Why am I getting the error "The column 'order_id' was specified multiple times for 'c'."? Please explain.
+1?
you cannot do Select * at the second select. You must specify each column with the name.
where is the data?
@@NailGlow-fv1dy check description box