SQL Portfolio Project - Shark Tank India | Analytics | Ashutosh Kumar
HTML-код
- Опубликовано: 21 май 2022
- 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 , i n this video i have analysis on shark tank india . I have gathered data from the wikipedia websites mentioned below or you can find the data set used into this video below-
Datasets -
github.com/ashutoshkr103/SQL-...
github.com/ashutoshkr103/SQL-...
Codes-
github.com/ashutoshkr103/SQL-...
----------------------------------------------------------------------------------------------------------------------
Check out some more relevant content here
👉 SQL Portfolio Project Indian Census- Part 1
• SQL Portfolio Project ...
👉 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 Indian Census- Part 1
ruclips.net/video/I3YvjFfn478/видео.html
really appriciated broo for making such quality content and datasets
Thank you so much 😀
Very helpful❤
thank you very much sir it is very informative and useful for me i easily understand all the quiries last one little complex one but by the time and practice i can easily understand it
Thanks a lot
U r so smart.. I m beginners.. But i want become like u.. I learned so much from u thank u so much...
So nice of you
Thankyou So much Sir for this Amazing Video
Most welcome
beautifully explained...!!!
Thank you
Sir i m using mysql ….And i m trying to import excel(csv) to mysql but only few file are importing … puri file import nhi ho rhi … what to do ???
Exalant
Thanks a lot
Why is the first SQL query not working in MySQL ??
data set not uploaded,pls give the solution of this error:- row 1 was truncated it contains more data
Can you help us with the union part in last query for making matrix ?
Yes tell me
For Pitches Converted can't we use just - Select count(amount_invested_lakhs) from Sharktank where amount_invested_lakhs >0.
Output is same 57.
Yes sure there are many ways to solve a particular problem in SQL similar to maths
please share the link of CSV file and also tell us how we can upload this on LinkedIn
for que. pitches which have converted into deal having atleast one woman
i think sum of women is wrong because in some of the brands there are 2 or 3 women but when you used case when function you take it as 1 it gives wrong answer when we sum it actual answer will be different and i think this query is correct, please correct me if i am wrong
select sum(a.Female)cnt_feamle from
(select * from sharktank_analysis
where deal !='no deal' and female>=1)a
Bro can you please provide the csv file for the above data. I tried changing it to csv but it is not working
Sure let me see I'll inform you
It's very informative 🥰 and awsm , can you plz help us with the total last joins to get metrics for all sharks cuz some syntax is not working for the vertical tabulardata.
With this joining syntax project will be 100 % complete 🤧
Please help with that syntax for joins.
Ok
please making the dashboard using power bi of this project
sure soon
bhai tableau me kaise kre isko ......
on 13.00 ,why cant we just do select count(amountinvestedinlakh)where amountinvestinlakh>0
instead of where we need to use having clause in case of you want to filter data from aggregates
sir in my case none of the excel version is running while importing how to solve
You can Try to copy the data from the excel sheet into a different sheet make sure that your file is not "read only" . Hope this helps.
@@AshutoshKumaryt ok sir i will try
Can you explain about dataset?I didn't get exact idea.like what type of data it is and all..
its a dataset about shark tank show
Make some more videos on projects sir
sure sir
bhai what are the final outcomes or we can say summary of this project so that we can add it in resume. aise kuch samjh ni aara kya kiya overall
Hi Vinnet this can be considered to be a data exploration project using SQL formulaes to formulate certain insights from the data
hello sir i am not able to import the data i tried every version of excel can you please tell me how to do it
what exact is the error , try once by keeping the file open
I tried all method to connect xlsx file but in some versions of excel it showing an error "external table is not in expected format"(Microsoft JET Database Engine). Could you pls help me out then how to import excel into DB?
keep the sheet open in background once and then try
I was facing the same issue and found solution by doing this ...do try.. ruclips.net/video/brGq2by7DvA/видео.html
@@rohitwadhave thanks a lot
Thank you for the content. I just have some suggestions. We can write simpler queries for the following parts;
at 22:00 for -- start-ups having at least women, we can write;
select
count(brand) as Brand
from project..data
where female > 0
also at 18:11 for -- avg equity taken,
select
avg(equitytakenp) as Avg_Equity
from project..data
where equitytakenp > 0
at 24:00 for pitches converted having at least one women,
select
count(amountinvestedlakhs) as Converted_Pitches_having_Female
from project..data
where female > 0
and amountinvestedlakhs > 0
thanks a lot for sharing your queries sure there are many ways to solve any problem
I have a question actually I m using mysql server and this query is not working... What to do?
Download microsoft SQL server management studio which i have used
make more projects good 😉
thanks a lot
data import nhi ho raha he excel me se..plz help
keep the sheet open in background and then try
can we do the same in postgresql?
Yes
@@AshutoshKumaryt so the different tables that was created. How ill I do that? should I create each table? Because in Pgadmin I could not find task-->import data option.Can you guide me how to do data importing?
--pitches converted
select cast(sum(a.converted_not_converted) as float) /cast(count(*) as float) from (
select amountinvestedlakhs , case when amountinvestedlakhs>0 then 1 else 0 end as converted_not_converted from project..data) a
In This Query have you used CTE? (meaning is this an eg of an CTE)
@Ashutosh Kumar
Yes i might have created temp table i guess
Sir how to add project in LinkedIn 😢?
Sir make one project on excel
Yes sure
Could you please Provide this Project's Summary so that we can add it in our Portfolio and Resume.
Hi Nikhil this can be considered as a data exploration task on the shark tank india data
Where is the excel sheet
No need of excel sheet find code in the description box
Pls attach Excel file also in discription so that we can also practise.
Link to file ,It is attached in description box
Hi Sir,
Very wonderful ,could you please tell
Pitches means?
I assume you meant what does pitches mean, pitches basically are the contestant they come and basically tell about their company
thank you@@AshutoshKumaryt
bhai kya analysis kr rhe vo to bta diya kro
Video mein btaya hai
We can add this also:
Male %
*select round(sum(male)/sum(male+female)*100, 2) from database..table*
=70.2
Female %
*select round(sum(female)/sum(male+female)*100, 2) from database..table*
sir! whenever i try to execute excel columns like "sex_ratio , Ep.No. , etc" by sql command ,it shows error like "Msg 207, Level 16, State 1, Line 5
Invalid column name 'epno'.
Completion time: 2022-07-20T11:29:54.9598796+05:30
" ......how to deal with it ?
please let me know sir
Ep.no. such column name is not present in the table that's why, write the correct column names
@@AshutoshKumaryt i am still struggling with amountinvestedlakhs column "Invalid column name 'amountinvestedlakhs'."
@@muskysingh1145 you can dm on Instagram @ashutosh.analytics