Тёмный

IPL Data Exploration SQL Portfolio Project - Part 1 | Analytics | Ashutosh Kumar 

Ashutosh Kumar
Подписаться 19 тыс.
Просмотров 8 тыс.
50% 1

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, this will be relevant to all those people who want to make a career into data analytics, business analytics ,data science , i n this video i have analysis on IPL Dataset . I have gathered data from the websites mentioned below or you can find the two data sets used into this video below-
Datasets -
github.com/ashutoshkr103/Micr...
github.com/ashutoshkr103/Micr...
github.com/ashutoshkr103/Micr...
github.com/ashutoshkr103/Micr...
github.com/ashutoshkr103/Micr...
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

Опубликовано:

 

23 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 28   
@manvendraprasad1848
@manvendraprasad1848 Год назад
since we have multiple tables first we can make a folder of it and in excel only we can go to data and then go to get data to choose the folder option click load and transform your entire tables will be combined ( why this step followed cz all the columns were same ). after I imported it into SSIS it worked for me.
@ajaypratap9505
@ajaypratap9505 Год назад
please share the second part
@vaidiksirsate6776
@vaidiksirsate6776 Год назад
Hi Ashutosh, Could you please help, I am trying to download dataset from github, but when clicking on download, it is showing site can't be reached. What should I do?
@AshutoshKumaryt
@AshutoshKumaryt Год назад
Let me see, this should not happen
@ChiragSharma-nw9dv
@ChiragSharma-nw9dv 20 дней назад
bhai pls share second part
@ayushsahu632
@ayushsahu632 Год назад
SIR ,2 files are not downloading.These are :-IPL Matches 2008-2020,IPL Ball-by-Ball 2008-2020.because they are so large( I THINK).
@ErMondeep
@ErMondeep Год назад
Sir please make a video on how do we showcase our Excel & SQL projects?
@AshutoshKumaryt
@AshutoshKumaryt Год назад
Sure i will make it soon
@naguls1176
@naguls1176 2 месяца назад
Part 2 video ???
@playwithvihaan7601
@playwithvihaan7601 Год назад
My question is where do we use SQL in data analysis? We generally use Python to perform EDA. Please help
@panther_.gaming
@panther_.gaming Год назад
We cant use python for very large data set
@playwithvihaan7601
@playwithvihaan7601 Год назад
@@panther_.gaming Thank you. and,How do you define a large data set? Who takes the decision of doing an EDA in either Python or SQL?
@Sasidhar_Reddy_BIAnalyst
@Sasidhar_Reddy_BIAnalyst Год назад
How to create an SQL portfolio?
@asifaslam5545
@asifaslam5545 6 месяцев назад
how did you break large dataset into diffrent diffrent dataset
@AshutoshKumaryt
@AshutoshKumaryt 6 месяцев назад
Simply i distributed in different excel sheets
@aman26693
@aman26693 Год назад
bhai you did wrong for 'most run by any player in IPL' instead of Sum you count runs...
@AshutoshKumaryt
@AshutoshKumaryt Год назад
Oh ok thanks for noticing
@RudrakshKawadkar
@RudrakshKawadkar Год назад
when will you upload IPL Data Exploration SQL Portfolio Project - Part 2?
@AshutoshKumaryt
@AshutoshKumaryt Год назад
Soon
@niteshgautam4195
@niteshgautam4195 Год назад
Bro you did wrong In 3rd soln all player get rank 1 ( because you again use partiton by in rank ) which is no use simply we use rank() over ( order by mom desc) then we get ch gayel as rank 1 ..
@user-cr3sk7vp4l
@user-cr3sk7vp4l 10 месяцев назад
please, upload the 2nd part.
@AshutoshKumaryt
@AshutoshKumaryt 10 месяцев назад
Sure
@110priyankakumari3
@110priyankakumari3 6 месяцев назад
Can you help me in my sql project. It was very important project for me.
@AshutoshKumaryt
@AshutoshKumaryt 6 месяцев назад
You may reach out on ashutoshkr103@gmail.com
@ajaypratap9505
@ajaypratap9505 Год назад
second part is missing?
@AshutoshKumaryt
@AshutoshKumaryt Год назад
will release soon
@sunnygupta956
@sunnygupta956 Год назад
next question session when come
@AshutoshKumaryt
@AshutoshKumaryt Год назад
coming soon
Далее
Копия iPhone с WildBerries
01:00
Просмотров 3,8 млн
ПОЛЕЗНЫЕ ЛАЙФХАКИ В PLANTS VS ZOMBIES!
00:45
SQL - Offeset and Fetch Clause
9:08
Просмотров 26