PRACTICAL Data Analytics with SQL

SQL is the number 1 tool that you have to master as a Data Analyst (but also as a Data Scientist and Data Engineer)... In this video I'll show you the ONE SQL PROJECT YOU NEED in your data analytics portfolio. I will go through how to do exploratory data analysis and data cleaning using SQL, as well as how to find insights using different queries methods. This will help you to navigate data analytics in case you are a beginner, or sharpen your skills in case you are advanced and used SQL before. This is a simple project that you can present to recruiters during job interviews to land a job in data...

📁 DATASET

✨ GET ALL OF MY FREE RESOURCES (Resume Template, SQL Cheat Sheet, Data Portfolio Template and more!)

🚀 MY NEW ANALYTICS & AUTOMATION ACADEMY IS LIVE AND APPLICATIONS ARE OPEN!!

📸 SOCIAL

📩 Get in touch:

🔎 CONTENT
0:00 Intro
1:28 Project Context
2:13 Connect to the dataset
4:12 Identify the stakeholder
4:57 Exploratory data analysis
9:28 Finding the insights
15:36 Final recommendations

#datanalytics #sql #datascience

[hopeafang]

Lore, you are God’s gift to entry level data analysts like me. Thank you so much for all you do.

[medpire]

This is the most practical representation of data analytics I've come across. Well done man!

[mohammadsadique]

wao so much for a fresher in a single video thanks buddy !

[timianalytics]

Bro really responded to almost every comment in the comment section. You're such a gem

[allahjoseph]

Extremely comprehensive with great examples of how to manipulate the dataframe. My guy made this fun to do! Good stuff Lore!!!!

[HairyCactus-kb]

You're amazing Lore!! Thank you so much for this!

[DIGICOM]

Great Practice. Hope you continue doing more of these. Thanks!

[CharlesDeBarros]

I'm sorry if I missed something!

I've watched the video a few times and can't find where the 'rating_count_tot' (13:45) alias was defined. It is in the Top-rated app Window function query.

Cheers.

[Behappy-ftyc]

Hii brother, a sincere request from your subscriber, can you please post more sql based projects whicha re actually practical in nature. you style of teaching is quite impressive and ofcourse your ideas for project really makes us stand out

[tamarainwang]

Lore!! I can’t thank you enough for these projects! My portfolios looking good! 👍👍

[husseinhadliye]

Great video and simple explanation, we expect you more 👍

[brianbc]

Really neat video. Very interactive and educational. Keep it up.

[victorbegnini]

Well done, Lore! Thanks for sharing this idea/procedure with us - beginners trying to find our spot under the Sun 😄 God bless, man, and all the best!

[nukeee]

Bravissimo Lore, ottimo video! Chiarissimo e dritto al punto ;)

[eltoski]

This is great thanks. But how do I visualize this ? Do i export the result of each query as a csv then import into power bi and visualize OR is there another way to go about it ?

[aistudio]

Awesome😍 Lore, Please keep making videos on more real time projects for data analysis job

[esther-mordecai]

Next time please increase screen resolution or enlarge the font to ensure clear visibility on Mobile Smartphone. Great job. Thanks

[uhani]

Would you please make a step by step project in Power BI

[nabihanuzhat]

Thank you so much for the step by step approach for the project.
I’m new into analytics so that’s really helpful.
I have a question. Please reply. If I want to make a visualization using Tableau do I use the and appleStore or I have to export the each CSV file after the query run?

[-alvin]

Hello,

Could you possibly provide a link for SQlite? I'm not sure on how I can access it through browser, I only see a downloadable one.