Custom SQL Query Tutorial For Beginners | Data Analyst Portfolio Project (Part 2/3)

Подписаться 97 тыс.

Просмотров 17 тыс.

50% 1

👉🏻 GET YOUR HANDS ON ALL OF THE PROJECT FILES
learnbi.online/pizzaproject.
(N.B. THIS IS A PAID DOWNLOAD. THANKS FOR YOUR SUPPORT!)
(WATCH THE FULL PROJECT HERE IN A SINGLE VIDEO: • Data Analyst Portfolio... )
🔵 OUR SPONSOR - LEARNSQL.COM
geni.us/learnsql
TIMESTAMPS
00:00 Intro
02:22 Tutorial start - Orders data query
06:37 LearnSQL.com ad
07:27 Stock/Inventory data - Query 1
14:22 Stock/Inventory data - Query 2
18:53 Staff data query
22:02 Outro
LINKS I REFERRED TO IN THIS VIDEO:
Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1
Part 1 of the Project - • SQL Database Design Tu...
How to Join SQL - • How To Join Data In SQ...
THE TOOL I USE IN THIS VIDEO - NAVICAT
navicat.com/en/
START YOUR BI JOURNEY! - learnbi.online
🎥 MORE RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid
BI For Beginners Playlist - geni.us/biforbeginners-play
🎓 RECOMMENDED COURSES
Power BI For Business Intelligence - geni.us/powerbi-udemy
Ultimate Guide to Google Data Studio - geni.us/vbi-edu
Google Data Analytics Course - geni.us/coursera_analytics
Learn SQL - geni.us/learnsql
SKILLSHARE - 30-day free trial! - geni.us/skillshare30day
UDEMY - geni.us/udemy_vb
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
🧰 BI TOOLS
Power BI - powerbi.microsoft.com/
Tableau - www.tableau.com/
Data Studio - datastudio.google.com/
📊 DATA HUBS & WEBSITES:
Power My Analytics: geni.us/YLc9Re
Supermetrics: geni.us/5SNn
Data Slayer: geni.us/dataslayer
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - data.world/
📕THE DATA VISUALISATION BIBLE - geni.us/iJTa8
🎥 MY RU-vid GEAR
My Camera - amzn.to/3J5lbeo
Most Used Lens - amzn.to/3hXoE2Q
Main Key Light - amzn.to/366KaPI
Softbox - amzn.to/35HrR46
LED Panel Kit - amzn.to/35K3Lpf
Teleprompter - amzn.to/3hWGT8p
Main Mic - amzn.to/3t1n1aK
Lavalier Mic - amzn.to/3vVUi8V
DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT!
BUSINESS INQUIRIES - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg
#sqltutorial #businessintelligence #dataanalyst

Наука

Опубликовано:

26 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 25

@equiwave80 Год назад

Hi Adam, I would like to buy the data but unfortunately I don't have a credit card. Is it possible to make the payment via PayPal?

@LearnBI Год назад

Hi Deepak, I've activated PayPal for checkout. Thanks

@ibejibenson6065 8 месяцев назад

The "timestampdiff" function is a little simpler, it returns the difference in your specified unit -> (timestampdiff(minute, sh.start_time, sh.end_time))/60 : for the number of hours (timestampdiff(minute, sh.start_time, sh.end_time))/60 * s.Hourly_rate : for the pay

@CatalinPaval 8 месяцев назад

Nice explanations. For staff_cost I would go with transforming hourly_rate into minute_rate and multiply it by timediff. If there is no need to show hours _in_shift.

@o7mach Год назад

🔜

@pauliuspariokas3156 Год назад

That's an excellent project. Thank you for sharing it. I have a question though. In your opinion, what would be the best practice - to do the calculations on the database side or select the necessary data using SQL, send it to your preferred BI tool and then create calculated measures? Or as an option, use the BI tool to connect to the database directly and skip the SQL altogether?

@LearnBI Год назад

That is a great question and the answer really deserves its own video. There are lots of different variables and factors to consider when deciding what work (if any) needs to be done in the SQL DB before connecting it to the BI tool. You could theoretically create a separate SQL query that gives the exact data you need for each of the required charts/tables in the project brief. But then you would have to deal with loads of different data sources in your BI tool that would impact a dashboard's interactivity capabilities. You always need to consider that reporting needs may evolve and change over time so you also don't want to paint yourself into a corner with the data. And sometimes, just connecting the database as it is to a BI tool will not mean you won't have to write custom queries to get the results you need. It really is one of those "it depends" answers where you learn with experience to evaluate the best approach from the project brief. Hope this helps!

@singhsaab1229 Год назад

Hi , Adam. Where can I access the 3 part of this tutorial series?

@LearnBI Год назад

I’ve not made it yet ☺️ but it's coming fairly soon. Don't forget to subscribe and turn on notifications so you don't miss it!

@meditatesleepandtravel8795 Год назад

Hi Adam, where, how do u get the ing, i, o, S1, etc? Do you make them up or memorize from the SQL software?

@LearnBI Год назад

Great question, aliases can be almost anything that isn't already used in SQL syntax. I just made them up to suit the table name. Lots of people just use 't1', 't2' etc to alias table 1, table 2 etc.

@paintwithtihani9926 Год назад

@@LearnBII’m a bit curious about this alias concept. In the video for example, you input o.order_id. Does SQL understand this as alias or did you input other command before that like AS for example

@kawtharbh1223 Год назад

@@paintwithtihani9926 if you notice on the code where he wrote " FROM orders o " that's where he specified that the "o" is an alias for the table "orders" and that's how SQL will recognize the "o" from "o.order_id".

@paintwithtihani9926 Год назад

@@kawtharbh1223 i see. thank you Kawthar! That clears things up for me :)

@equiwave80 Год назад

Hi Adam, Where can I access the part 3 of this series?

@LearnBI Год назад

I’m working on it at the moment and it should be posted tomorrow or Monday 👍🏻

@equiwave80 Год назад

@@LearnBI Superb thanks for the prompt reply. I really appreciate your content. Can't thank you enough