Hey guys I hope you enjoyed the video! If you did please subscribe to the channel! Join our Data Science Discord Here: discord.com/invite/F7dxbvHUhg If you want to watch a full course on SQL check out Datacamp: datacamp.pxf.io/XYD7Qg Want to solve SQL data interview questions: stratascratch.com/?via=ryan I'm also open to freelance data projects. Hit me up at ryannolandata@gmail.com *Both Datacamp and Stratascratch are affiliate links.
Ryan I am fairly new data analyst, and I started watching your videos one by one - these are top notch. Keep up the good work, your channel will hopefully be found out by many like me. Appreciate all your effort!
That's fantastic work since you started the analysis data until you started to make the SQL queries, so I hope you will make a lot of videos with the whole process like this, Im from Bogota Colombia south America. Thank you for sharing your knowledge and spending your time with us, best regards bro
Hey Ryan, for Question no 4A, You can also try this method using CTE with t1 as( Select player_name,round(AVG(release_speed),3) as Avg_Release_speed ,AVG(release_spin_rate) as Avg_spin_rate, sum(Case when [events]='strikeout' then 1 else 0 end) as strikeout from [dbo].[LastPitchRays] where player_name='McClanahan, Shane' group by player_name ),t2 as( Select player_name,[zone],COUNT([zone]) as popular_zone from [dbo].[LastPitchRays] where player_name='McClanahan, Shane' group by player_name,[zone] )select top(5)t1.*, t2.[zone],t2.popular_zone from t1 right join t2 on t1.player_name=t2.player_name order by 6 desc
Hey Amari, I really appreciate it. Going to be uploading almost daily as long as possible! Might take a look at making Excel videos down the line, but SQL/Python are the priority for me atm
"R" must stand for "Regular Season" since you original filtered data using the dates of the first to the last regular season game, hence why there is only one value across the "game_type" column.
Thanks for doing this. I just started and chose a different team. Hopefully that doesn't trip me up later. I noticed when I filtered for 2 for hit location, and also filtered out the pop ups, etc., I actually had a few other events besides strikeouts. There was some catcher interference, another player caught stealing, etc. So I had to be a bit more careful marking as a strikeout. Again, I hope this doesn't lead to problems later on.
Thanks for the video! I have a personal project that I worked on using SQL and Excel. However, I do have the project on Excel so how can I showcase my work to employers?
@@RyanAndMattDataScience i tried using GitHub to upload my work but I wasn’t able to find a way. My Excel file has quite a few of sheets and visual interactive dashboards
although this has nothing to do with this video i do have a question in order to get a job as a data analysis do you need any certificates or do you think with a good enough portfolio is enough? for example the tableau, power bi, and oracle database certificates.
Kinda depends on your background. Do you have a degree in a technical field? Any prior experience in a data related field? Any networking opportunities? A portfolio allows you to talk about projects in an interview + stand out a bit on resume. Which in an interview you really have to sell yourself as both knowledgeable and hard working/drive to learn more. If I were to start DA from scratch today, I would really focus on Networking and Freelance jobs as well as portfolio projects over certificates. Networking gets you in the door, portfolio + freelance work shows you know what you are doing (unless you have a technical background). Hope this helps
So I have no experience in the tech field, don't even know people in this field. I've been practicing this for the past 2-3 months thru RU-vid tutorials and some courses on Udemy but that's about it. Was about to start doing projects to show what ik but Idk if needed the certificates to get a job or just with having good projects would be enough.
halloo, teacher ryan... can i ask something? is there any other tools (software/ application/ website) that can be used for using SQL? im so soorry for the question,, please dont laugh for me,, hehehehe... im very new beginner learning for data analyst... i have a dream to become business analyst... do u have some suggestion for me please?