PRACTICAL Data Analytics with SQL
Рет қаралды 30,100
Күн бұрын🎵 Try GetSound.AI and get 50% discount using this link app.getsound.ai/vtraiz9dbsfc4f1b
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
loresowhat.com/sql-app-store-...
🚨 GET MY DATA ANALYTICS COURSE AND BECOME JOB-READY IN 60 DAYS 🚨
loresowhat.com/data-analyst-m...
👨💻 LET ME BE YOUR MENTOR
topmate.io/loresowhat
📸 SOCIAL
/ loresowhat
/ loresowhat
📩 Get in touch:
loresowhat@gmail.com
🔎 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
@loresowhat 10 ай бұрын
🚀GetSound.AI 50% discount using this link app.getsound.ai/vtraiz9dbsfc4f1b
@tamarainwang6362 10 ай бұрын
Lore!! I can’t thank you enough for these projects! My portfolios looking good! 👍👍
@loresowhat 10 ай бұрын
Thank you a lot Tamara 🙏 I’m curious now, share it with me on instagram 😉
@allahjoseph 7 ай бұрын
Extremely comprehensive with great examples of how to manipulate the dataframe. My guy made this fun to do! Good stuff Lore!!!!
@loresowhat 7 ай бұрын
Glad you enjoyed it, really appreciate your comment 😉
@hopeafang9871 10 ай бұрын
Lore, you are God’s gift to entry level data analysts like me. Thank you so much for all you do.
@loresowhat 10 ай бұрын
these are the comments that make my day, thank you so much!!!!!
@allahjoseph 8 ай бұрын
Bro
@victorbegnini5754 7 ай бұрын
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!
@loresowhat 7 ай бұрын
Glad it was helpful and welcome to the channel Victor 😉
@DIGI3COM 9 ай бұрын
Great Practice. Hope you continue doing more of these. Thanks!
@loresowhat 9 ай бұрын
More to come 🙂
@69nukeee 10 ай бұрын
Bravissimo Lore, ottimo video! Chiarissimo e dritto al punto ;)
@loresowhat 10 ай бұрын
Grazie mille del commento 😉
@newenglandnomad9405 9 ай бұрын
I love this video. I'll tell you why. I've never understood wtaf anyone does with a query result without making a dashboard. I finally understand the break down of how to use documentation in the query, and the purpose of the query without the dashboard. I've never under the practical purpose of finding the avg salary or missing orders sandbox queries, why would my boss ask for that... I like how you did NOT bounce around the csv files. You left that to the viewer to review and study outside the video in our own time. I'll have to review this video quite a few times and I'll practice the queries on my own until i understand every line. Thank you for keeping the video short and on point, i'll be watching it multiple times. Thank you for sharing the files. Thank you soooo much for making this video. I've never been so happy to hit the subscription button as a new hopeful data analyst. I just started a few projects like throwing spaghetti at a wall but I need to clean them up. I understand why my portfolio looks like kids crayon now. I've been using Bard to pose a question and csv file when I can't figure out why my query has mistakes. A million thank you's for making this video. I'm assuming the final list of question and the answers are something you'd present to the stakeholder as an email or Word doc or something.
@loresowhat 9 ай бұрын
this comment made my day and I will also share it on my instagram page. thank you so much for taking the time to write such nice words 🙂
@medpire113 4 ай бұрын
This is the most practical representation of data analytics I've come across. Well done man!
@loresowhat Ай бұрын
oh wowwww thanks a lot for the comment🙂
@husseinhadliye2992 9 ай бұрын
Great video and simple explanation, we expect you more 👍
@loresowhat 9 ай бұрын
So glad it was helpful and good to see you in the channel 🙂
@user-cr9gw2nb3p 5 ай бұрын
You're amazing Lore!! Thank you so much for this!
@loresowhat Ай бұрын
glad it helps and thank you so much for the kind comment 🙂
@brianbc19 8 ай бұрын
Really neat video. Very interactive and educational. Keep it up.
@loresowhat 8 ай бұрын
Thank you very much brian and welcome to the channel 🙂
@Chadwill05 5 ай бұрын
Great video. Learned a lot thanks!
@loresowhat Ай бұрын
Glad you enjoyed it!
@timianalytics7150 9 ай бұрын
Bro really responded to almost every comment in the comment section. You're such a gem
@loresowhat 9 ай бұрын
Ahah trying my best 🙂
@mohammadsadique1131 6 ай бұрын
wao so much for a fresher in a single video thanks buddy !
@loresowhat 6 ай бұрын
Happy to help!
@mohammadsadique1131 5 ай бұрын
@@loresowhat please make analysis on health care data set if possible
@muhamadaslankazhim2806 9 ай бұрын
Hello, i download your file but chinese language turn into symbol after i download it. I've searched for solution but haven't found it. Do you know how to fix this?
@amishskincare12 7 ай бұрын
Awesome😍 Lore, Please keep making videos on more real time projects for data analysis job
@loresowhat 6 ай бұрын
More to come for sure!! I know that you guys like those a lot!!!
@eltoski01 9 ай бұрын
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 ?
@aarshghotra475 25 күн бұрын
were you able to visualize it?
@nopfilms249 10 ай бұрын
Hey Lore, love your videos! When I try to find an overview of the apps ratings, it come up with a syntax error for min, max, and avg. Do you know a way around this?
@loresowhat 10 ай бұрын
are you using different tools to run the code? you can show me on instagram in case
@genlyai6918 10 ай бұрын
Hi Lore. Can you make a video comparing which is better to learn first, in terms of dashboard: Tableau or Power BI, ...
@loresowhat 10 ай бұрын
Great suggestion! added to my list!
@genlyai6918 10 ай бұрын
Another video I could use is about tips for data storytelling. Sometimes I have to present my results for people with little to no interest on how I get there, but in a way that would still make sense. Any tips?
@loresowhat 10 ай бұрын
another good suggestion too. try using gamification when you tell the story or create a plot that reasonates with your audience and their backgorund more! will try to cover that soon
@CharlesDeBarros 6 ай бұрын
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.
@loresowhat Ай бұрын
hey I would need to revisit this. isnt that in the appstore table?
@-alvin8561 10 ай бұрын
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.
@loresowhat 10 ай бұрын
Here it is, let me know if it works sqliteonline.com
@alecmckay2111 9 ай бұрын
Had the same problem. Link worked, thanks!
@RoseShalom-ni6kt 2 ай бұрын
Please Lore,what can cause my query to take a long execution time... especially when i am doing joins,i am using SMSS 2019
@loresowhat Ай бұрын
hey it really depends on the query, feel free to text me on instagram to get more details
@Behappy-ft5yc 4 ай бұрын
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
@loresowhat Ай бұрын
this is definitely something that I will do more about, thanks for the tip and the support!!
@adityaraina7727 7 ай бұрын
thanks!
@loresowhat 6 ай бұрын
thanks for the comment 😉
@sundusmohsinkhan5498 10 ай бұрын
Hi Lore, Firstly thanks for the tutorial. I am using SQL Server Management Studio to follow along but I am facing one problem. While importing data from csv files with comma delimiter, the commas used in track_name also get parsed along and the text splits into multiple columns. Can you please help me in this regard. Thanks in advance
@loresowhat 10 ай бұрын
Hi good question, This is a common issue when importing CSV files where the data itself contains commas. You can address this by ensuring your data is encapsulated with a text qualifier (like double quotes) during the import process. Here are the steps to handle this in SQL Server Management Studio: Start the import wizard. Select your CSV file as the data source. In the "Choose a Data Source" dialog, click on "Advanced" button. In the "Column Properties" section, find the "Text Qualifier" field and put double quotes (") in it. let me know if this helps otherwise please use sqllite cause that would work for sure
@asopok 9 ай бұрын
I am also facing similar challenge using MYSQL workbench.
@asrarahmad1691 8 ай бұрын
You can convert csv file into excel and then upload the data
@technicalsuranii 7 ай бұрын
@@asrarahmad1691 This worked for me. Thanks
@HorbachenkoVlad 5 ай бұрын
@@loresowhat Hi. I imported CSV files to SQL Server, and I noticed that some values were displayed as question marks. For example, in the track_name column, there is a value of "Shanghai Mahjong". But in my table, it is displayed as "???-??????". For the track_name data type, I chose varchar(MAX). Do you have any idea what might be the issue? Thank you!
@Mohamed-qt4vc 9 ай бұрын
Great Work! But aren't those insight might be misleading? As the groups that we are grouping by aren't equal in the count so the average is misleading in this point so the proportion would be more accurate?
@loresowhat 9 ай бұрын
Good point! this was a simplified approach but using proportions or percentages can often be a better approach when comparing groups of different sizes. It provides a normalized view of the data, ensuring each group has equal representation in the analysis.
@timianalytics7150 9 ай бұрын
I don't think proportion would work still cos the 'ratings' column is a numeric variable. You might have to drop columns with insufficient amount of ratings to avoid bias. But I tell, you, average (mean or median) is your best bet in this scenario
@___________mrivan___________ 10 ай бұрын
Hi! Could you please provide a link to the Kaggle datasets? I want to know the origin of the data
@loresowhat 10 ай бұрын
www.kaggle.com/datasets/ramamet4/app-store-apple-data-set-10k-apps
@cgadison 2 ай бұрын
I am actually using MySQL to attempt this, but when I import the data I keep getting an Unhandled Exception error. 'charmap' codec can't decode byte 0x9d in position 7122: character maps to
@loresowhat Ай бұрын
can you please try with sqliteonline.com/
@darialuchko8873 4 ай бұрын
thank you thank you thank you
@loresowhat Ай бұрын
You are very welcome🙂
@aydeeeleje5620 8 ай бұрын
I am not able to download the dataset via Google drive. Anyone know how to get this done because the link doesn't let me
@loresowhat 8 ай бұрын
can you text me on ig? I know others are able to download it
@youtobe12127 7 ай бұрын
Great video Lore! Is there anyway I can upload this project into my Github account? Straight from SQLlite there? Thanks!
@loresowhat 6 ай бұрын
mm I dont think so but it's easy to just copy paste the code there right?
@shawaiz10 10 ай бұрын
What ediigng software do you use. Really love your animations
@loresowhat 10 ай бұрын
mainly adobe👍
@esther-mordecai 8 ай бұрын
Next time please increase screen resolution or enlarge the font to ensure clear visibility on Mobile Smartphone. Great job. Thanks
@loresowhat 8 ай бұрын
will do thanks for the feedback!
@akiemcameron5303 6 ай бұрын
So, I have found out the hard way that checking for null values will sometimes bring an empty result so it might be safer to check " ".
@loresowhat 5 ай бұрын
good point you raised there thanks!!
@SujjuOmJadhav-ub9cc 2 ай бұрын
Can you please share the link to SQLite you are using? Thank you!
@loresowhat Ай бұрын
here you go sqliteonline.com/
@AlbouryNdiaye-ro8qz 8 ай бұрын
Hi Lore. Thank you so much for this project. When I execute the following query in Microsoft SQL Server, it generates an error. I believe it works only in SQLite. Do you know what is the syntax to create the appleStore_description_combined in Microsoft SQL Server? CREATE TABLE appleStore_description_combined AS SELECT * FROM appleStore_description1 UNION ALL SELECT * FROM appleStore_description2 UNION ALL SELECT * FROM appleStore_description3 UNION ALL SELECT * FROM appleStore_description4;
@loresowhat 8 ай бұрын
try this SELECT * INTO appleStore_description_combined FROM appleStore_description1 -- Append data from other tables INSERT INTO appleStore_description_combined SELECT * FROM appleStore_description2 INSERT INTO appleStore_description_combined SELECT * FROM appleStore_description3 INSERT INTO appleStore_description_combined SELECT * FROM appleStore_description4;
@AlbouryNdiaye-ro8qz 8 ай бұрын
Hi Lore - Your query works in SQL Server. Thank you so much for sharing your knowledge with us. All the best!@@loresowhat
@loresowhat 8 ай бұрын
@@AlbouryNdiaye-ro8qz amazing 🤩
@lucadelli9308 10 ай бұрын
Ciao lore! Che ne pensi di creare un server discord riguardo data science? Io sono al secondo anno di economia e big data e troverei molto utile un server discord riguardo ds e penso che magari ci siano anche altre persone interessate.
@loresowhat 10 ай бұрын
ciao Luca grazie del messaggio! ci avevo pensato e in realta' lo avrei gia pronto per il lancio... ci ho ripensato all'ultimo perche' non so se ho il tempo di gestire anche quello. scrivimi su instagram se sei interessato ad aiutarmi magari...
@user-dh4bq9hj1d 8 ай бұрын
Should we install the sqlite. So so please provide the platform link
@loresowhat 7 ай бұрын
no need to install anythig, you can access it online for free
@pratikkarande6824 10 ай бұрын
Does certificate matter or experience and skill set ?
@loresowhat 10 ай бұрын
the more the better but experience is definitely number 1
@shobhitagnihotri416 10 ай бұрын
PLEASE MAKE A VIDIO ABOUT USE OF GENRATIVE AI IN DATA ANALYST
@margaret9247 10 ай бұрын
This is interesting
@loresowhat 10 ай бұрын
absolutely!! just uploaded one on the code interpreter! check it out!
@loresowhat 10 ай бұрын
absolutely!! just uploaded one on the code interpreter! check it out!
@asuzordavid2962 9 ай бұрын
How do we link the SQL to our portfolio
@loresowhat 9 ай бұрын
you can create a text document where you summarise the purpose and results of your code and then add the whole code at the end 🙂
@akiemcameron5303 8 ай бұрын
how should you address data quality issues?
@loresowhat 8 ай бұрын
I just uploaded a new video talking about that and data cleaning, that should help 🙂
@akiemcameron5303 6 ай бұрын
Thank you I saw it, you are the best @@loresowhat
@yogeshindulkar320 5 ай бұрын
WHERE THIS RATING_COUNT_TOT COMES ? PLEASE EXPLAIN
@loresowhat Ай бұрын
can you expand on what is not clear please?
@vangough11 6 ай бұрын
Brother, please advise how to learn SQL? I need to really master it
@loresowhat 5 ай бұрын
my course is coming soon and will cover that in detail!!!
@abhidipsen3674 8 ай бұрын
unable to load the data in mysql . Please help
@loresowhat 8 ай бұрын
could you use the same tool I use in the video and see if that works?
@abhidipsen3674 8 ай бұрын
@@loresowhat Bit of cleaning and modifications made in query and imported the data through cmd prompt
@Srv_Sngh 7 ай бұрын
@@loresowhatwhat’s the name of this tool.
@sureshr1273 10 ай бұрын
How to document this project to upload it in portfolio?? Make a video of documentation of our project...
@loresowhat 10 ай бұрын
hey did you check my video on the portfolio that actaully works? I speak exaclty about how to present project
@sureshr1273 10 ай бұрын
@@loresowhat yeahh i did...
@vishwasmaliwal1500 8 ай бұрын
hey did you documanted this project?
@loresowhat 8 ай бұрын
@@sureshr1273 curious to see if you manage to document it ?
@TheGladiator123 10 ай бұрын
Connect SQL with power bi
@loresowhat 10 ай бұрын
yep that's a good way to go!
@TheGladiator123 10 ай бұрын
@@loresowhat Thanx 😊
@gozieprince9530 6 ай бұрын
Thank you for this video, currently learning to becoming a data analyst. I would like you to mentor me, I also live in London
@loresowhat 6 ай бұрын
Thanks for the comment! Please text me on instagram 😉
@dhinakarans8602 5 ай бұрын
can i get the whole data in one file
@loresowhat Ай бұрын
I dont have that but should be an easy task if you have the separate ones
@puloii7800 25 күн бұрын
What IDE is this?
@loresowhat 2 күн бұрын
Check video description and intro of the video, I explain all the setups and info there 🙂
@k2ops376 10 ай бұрын
3rd
@loresowhat 10 ай бұрын
and you got a bronze medal here 😉
@Learn_lane 5 ай бұрын
11.23
@loresowhat 5 ай бұрын
what's up?
@syedfahad4503 10 ай бұрын
Not first but second😅
@loresowhat 10 ай бұрын
silver medal for you 💪
@dolayesoul 10 ай бұрын
First
@loresowhat 10 ай бұрын
Ahahaha love that you guys are making this a real challenge 😂✨
@Maison1990 10 ай бұрын
EZPZ
@loresowhat 10 ай бұрын
that was the goal ahah
@martingarcia3999 10 ай бұрын
more more more moree... plz fix it. thank you
@loresowhat 10 ай бұрын
what else you would like to see? still with SQL?
@HorbachenkoVlad 5 ай бұрын
I don't really understand this "distribution of app prices" calculation. And there is no explanation in the video. And on top of that, there is not a single comment about this:)
@loresowhat Ай бұрын
can you expand on this? what is it that is not clear?
techTFQ
Рет қаралды 105 М.