Data Analyst Portfolio Project - SQL exploration
Вставка
- Опубліковано 5 тра 2023
- In this video tutorial, I'm going to show you how to do a SQL data exploration for your porfolio as a Data Analyst. We are going to be doing this exploration on Google's Big Query and showing our results on Looker Studio.
Google's Big Query: cloud.google.com/bigquery?hl=es
Currently looking for a position full time/part time as a data analyst/business analyst. Contact me: / juan-carlos-martinez-p...
Resume: drive.google.com/file/d/14Q9E...
Portfolio: jc-martinez95.github.io/portf...
#sql #dataanalytics #sqlqueries #sqlforbeginners
Excellent work Juan. Really amazing project.
I'm new to the world of Data Analystics, working on improving my SQL proficiency and this video helped a lot.
I enjoyed every bit of it. Really appreciate your effort.
This channel deserves more subs. Keep grinding
Thank you
I enjoyed the project, learned a lot. I suggest you to keep the audio a bit high in your future videos. Your channel subscriber count will soon be in 100k!!!
Amazing work Juan, thank you for your great efforts.
hello, i just came across your channel. I will connect with you on linkedin. love the project. I just started my journey. Am currently building my portfolio.
Thanks man!
I really like your videos they are very informative. Keep up the good work!
Your video will be very helpful as I just started with my Capstone project on the Cyclystic bike project.
Loved the project! I was looking deeper into the dataset, and I had a question that I noticed when in Looker. I see that there were a few years when Captain Morgan and other liquors were listed at zero. Given that Captain Morgan is one of the more popular liquors, can you explain why this value was found at zero?
This was great!! It really helped me, to learn what to do for a project. Can you please turn up the volume in future videos? You sound a bit low.
Awesome tutorial.
Select category_col, count(*)
From table
Groupby category
It is equivalent to df.category_col.value_counts() in Pandas.
Itwould be interesting to display the final results as percentagens for better readibility and comparison.
Could you kind shed some lights on how to get a percentage column along the count values??
Thank u