![Data with Baraa](/img/default-banner.jpg)
- 222
- 878 665
Data with Baraa
Germany
เข้าร่วมเมื่อ 24 ธ.ค. 2022
I am Baraa and I am here to teach everything I know about data. My journey with data started a long, long time ago.
I have a Master's degree in Data Engineering and for more than a decade I worked in several Data Warehouse and Big Data projects in Germany.
In 2020 I decided to share everything I know on youtube and on my website datawithbaraa.com, so I can help more people :)
Follow along if you want to make a career or learn the skills you need to become a data analyst, data scientist, or any other data profession. 🡺 bit.ly/3GiCVUE
😍 JOIN 😍
----------------------------------
Subscribe: bit.ly/3GiCVUE
Website: www.datawithbaraa.com
Substack: datawithbaraa.substack.com/subscribe
LinkedIn: www.linkedin.com/in/baraa-khatib-salkini-845b1b55/
#tableau #tableaututorial # tableaucourse #tableautraining #sql #sqltutorial # sqlcourse #sqltraining #bigdata #datascience #dataanalytics
I have a Master's degree in Data Engineering and for more than a decade I worked in several Data Warehouse and Big Data projects in Germany.
In 2020 I decided to share everything I know on youtube and on my website datawithbaraa.com, so I can help more people :)
Follow along if you want to make a career or learn the skills you need to become a data analyst, data scientist, or any other data profession. 🡺 bit.ly/3GiCVUE
😍 JOIN 😍
----------------------------------
Subscribe: bit.ly/3GiCVUE
Website: www.datawithbaraa.com
Substack: datawithbaraa.substack.com/subscribe
LinkedIn: www.linkedin.com/in/baraa-khatib-salkini-845b1b55/
#tableau #tableaututorial # tableaucourse #tableautraining #sql #sqltutorial # sqlcourse #sqltraining #bigdata #datascience #dataanalytics
SQL NULL Functions | COALESCE, ISNULL, NULLIF, IS (NOT) NULL | #SQL Course #9
🎬 Full Advanced Course: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html
⬇️ Free Materials (Downloads): datawithbaraa.substack.com
👉 Support & Subscribe to Channel: bit.ly/3GiCVUE
☕ Stay connected
► Subscribe: bit.ly/3GiCVUE
► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin
► Newsletter: bit.ly/BaraaNewsletter
► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/
► Website: www.datawithbaraa.com
📚 Free Courses
✅ Tableau: th-cam.com/video/UcGF09Awm4Y/w-d-xo.html
✅ Tableau Project: th-cam.com/video/UcGF09Awm4Y/w-d-xo.html
✅ SQL Basics: th-cam.com/video/NTgejLheGeU/w-d-xo.htmlsi=2-m6dgYPRvoFUSgS
✅ SQL Advanced: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html
✅ ChatGPT: th-cam.com/video/LJLNfei4i-c/w-d-xo.htmlsi=EhUNYN38dkswAvZH
🎓Other Platforms (Certifications)
► Udemy: bit.ly/BaraaUdemy
► Skillshare (1 Free Month): bit.ly/BaraaSkillshare
⭐ My favorite books: kit.co/DataWithBaraa/my-favorite-books
💻 My gear: kit.co/DataWithBaraa/my-desktop-gear
⏱️ Timestamp
00:00 Intro
00:25 What is NULL?
01:23 What are NULL Functions?
03:23 ISNULL
07:35 COALESCE
12:59 COALESCE vs ISNULL
14:33 Handle NULL - Data Aggregation
18:12 Handle NULL - Mathematical Operators
24:23 Handle NULL - Joining Tables
31:28 Handle NULL - Sorting Data
37:01 NULLIF
40:53 NULLIF - Division by Zero
42:58 IS NULL - IS NOT NULL
46:44 Left Anti Join - Right Anti Join
#sql #sqlserver #data #analytics
**Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!**
**All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for**
⬇️ Free Materials (Downloads): datawithbaraa.substack.com
👉 Support & Subscribe to Channel: bit.ly/3GiCVUE
☕ Stay connected
► Subscribe: bit.ly/3GiCVUE
► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin
► Newsletter: bit.ly/BaraaNewsletter
► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/
► Website: www.datawithbaraa.com
📚 Free Courses
✅ Tableau: th-cam.com/video/UcGF09Awm4Y/w-d-xo.html
✅ Tableau Project: th-cam.com/video/UcGF09Awm4Y/w-d-xo.html
✅ SQL Basics: th-cam.com/video/NTgejLheGeU/w-d-xo.htmlsi=2-m6dgYPRvoFUSgS
✅ SQL Advanced: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html
✅ ChatGPT: th-cam.com/video/LJLNfei4i-c/w-d-xo.htmlsi=EhUNYN38dkswAvZH
🎓Other Platforms (Certifications)
► Udemy: bit.ly/BaraaUdemy
► Skillshare (1 Free Month): bit.ly/BaraaSkillshare
⭐ My favorite books: kit.co/DataWithBaraa/my-favorite-books
💻 My gear: kit.co/DataWithBaraa/my-desktop-gear
⏱️ Timestamp
00:00 Intro
00:25 What is NULL?
01:23 What are NULL Functions?
03:23 ISNULL
07:35 COALESCE
12:59 COALESCE vs ISNULL
14:33 Handle NULL - Data Aggregation
18:12 Handle NULL - Mathematical Operators
24:23 Handle NULL - Joining Tables
31:28 Handle NULL - Sorting Data
37:01 NULLIF
40:53 NULLIF - Division by Zero
42:58 IS NULL - IS NOT NULL
46:44 Left Anti Join - Right Anti Join
#sql #sqlserver #data #analytics
**Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!**
**All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for**
มุมมอง: 813
วีดีโอ
SQL Case When Statement | Use Cases | #SQL Course #8
มุมมอง 1.5Kหลายเดือนก่อน
🎬 Full Advanced Course: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html ⬇️ Free Materials (Downloads): datawithbaraa.substack.com 👉 Support & Subscribe to Channel: bit.ly/3GiCVUE ☕ Stay connected ► Subscribe: bit.ly/3GiCVUE ► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin ► Newsletter: bit.ly/BaraaNewsletter ► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/ ► Website: www.datawithbaraa....
Complete HR Tableau Project End-to-End | Like I Do in My Real Projects
มุมมอง 28Kหลายเดือนก่อน
Come and build this Tableau dashboard project with me step by step, just like I do in real-projects! 🎬 Full Tableau Course: th-cam.com/video/UcGF09Awm4Y/w-d-xo.html ⬇️ Free Materials (Downloads): datawithbaraa.substack.com 👉 Support & Subscribe to Channel: bit.ly/3GiCVUE ☕ Stay connected ► Subscribe: bit.ly/3GiCVUE ► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin ► Newsletter: bit.ly...
SQL Union, Union All, Except (Minus), Except | Set Operators | #SQL Course #7
มุมมอง 1.4Kหลายเดือนก่อน
🎬 Full Advanced Course: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html ⬇️ Free Materials (Downloads): datawithbaraa.substack.com 👉 Support & Subscribe to Channel: bit.ly/3GiCVUE ☕ Stay connected ► Subscribe: bit.ly/3GiCVUE ► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin ► Newsletter: bit.ly/BaraaNewsletter ► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/ ► Website: www.datawithbaraa....
SQL Value Window Functions | LEAD, LAG, FIRST_VALUE, LAST_VALUE | #SQL Course #6
มุมมอง 1.9K2 หลายเดือนก่อน
🎬 Full Advanced Course: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html ⬇️ Free Materials (Downloads): datawithbaraa.substack.com 👉 Support & Subscribe to Channel: bit.ly/3GiCVUE ☕ Stay connected ► Subscribe: bit.ly/3GiCVUE ► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin ► Newsletter: bit.ly/BaraaNewsletter ► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/ ► Website: www.datawithbaraa....
Tableau Concepts: 150 Animated Sketchnotes & Visuals
มุมมอง 2.8K2 หลายเดือนก่อน
I have sketched over 150 animated visuals for the 21 Hours Tableau Course, so I've compiled all these animated visuals into one video just for you 😉 Recently, I have received many questions about how I created these animated visuals. I created them using my tablet and the app Procreate. I was inspired by Tim Tableau. Check the Tableau Full Course (21 Hours) th-cam.com/video/K3pXnbniUcM/w-d-xo.h...
Top 4 Analytical Use Cases for ROW_NUMBER SQL Window Function
มุมมอง 6042 หลายเดือนก่อน
In this video, you'll learn all uses cases of ROW_NUMBER in SQL 🔔 If you enjoyed this video and found it helpful, please support the channel by Subscribing, liking and commenting. bit.ly/3GiCVUE ⏬ FREE DOWNLOAD LINKS ⏬ Access all course materials: bit.ly/advancedsqlcourse You can find list to all courses & materials in my substack page datawithbaraa.substack.com/subscribe 🎓 Free Courses On TH-c...
SQL Ranking Window Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE, CUME_DIST, PERCENT_RANK
มุมมอง 2.7K2 หลายเดือนก่อน
🎬 Full Advanced Course: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html ⬇️ Free Materials (Downloads): datawithbaraa.substack.com 👉 Support & Subscribe to Channel: bit.ly/3GiCVUE ☕ Stay connected ► Subscribe: bit.ly/3GiCVUE ► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin ► Newsletter: bit.ly/BaraaNewsletter ► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/ ► Website: www.datawithbaraa....
Running & Rolling Total | Moving & Rolling Average | SQL Key Data Analysis Concepts
มุมมอง 1K2 หลายเดือนก่อน
In this video, you'll understand SQL Running Total, Rolling Total, Moving Average, and Rolling Average. They are essential SQL concepts for data analysis and reporting. They enable us to track current trends and historical patterns, essential for insightful business decisions. These use cases highlight the importance of aggregate window functions in SQL for performing advanced data analytics. 🔔...
SQL Aggregate Window Functions | COUNT, AVG, SUM, MAX, MIN | #SQL Course #4
มุมมอง 3.2K3 หลายเดือนก่อน
🎬 Full Advanced Course: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html ⬇️ Free Materials (Downloads): datawithbaraa.substack.com 👉 Support & Subscribe to Channel: bit.ly/3GiCVUE ☕ Stay connected ► Subscribe: bit.ly/3GiCVUE ► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin ► Newsletter: bit.ly/BaraaNewsletter ► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/ ► Website: www.datawithbaraa....
SQL Window Functions Basics | Partition By, Order By, Frame | #SQL Course #3
มุมมอง 7K3 หลายเดือนก่อน
🎬 Full Advanced Course: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html ⬇️ Free Materials (Downloads): datawithbaraa.substack.com 👉 Support & Subscribe to Channel: bit.ly/3GiCVUE ☕ Stay connected ► Subscribe: bit.ly/3GiCVUE ► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin ► Newsletter: bit.ly/BaraaNewsletter ► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/ ► Website: www.datawithbaraa....
How to Download & Install (FREE) Microsoft SQL Server, SSMS and 3 AdventureWorks Databases
มุมมอง 2.9K3 หลายเดือนก่อน
🎬 Full Advanced Course: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html ⬇️ Free Materials (Downloads): datawithbaraa.substack.com 👉 Support & Subscribe to Channel: bit.ly/3GiCVUE ☕ Stay connected ► Subscribe: bit.ly/3GiCVUE ► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin ► Newsletter: bit.ly/BaraaNewsletter ► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/ ► Website: www.datawithbaraa....
How I'd Learn Advanced SQL and Why (If I Had to Start Over) | #SQL Course #1
มุมมอง 6K3 หลายเดือนก่อน
🎬 Full Advanced Course: th-cam.com/video/ELdz0dXzWGM/w-d-xo.html ⬇️ Free Materials (Downloads): datawithbaraa.substack.com 👉 Support & Subscribe to Channel: bit.ly/3GiCVUE ☕ Stay connected ► Subscribe: bit.ly/3GiCVUE ► Join: th-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin ► Newsletter: bit.ly/BaraaNewsletter ► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/ ► Website: www.datawithbaraa....
Tableau Ultimate Full Course (21 Hours) for Beginners - From Zero to HERO
มุมมอง 160K4 หลายเดือนก่อน
Tableau Ultimate Full Course (21 Hours) for Beginners - From Zero to HERO
Master 61 Tableau Charts from Basic to Advanced
มุมมอง 9K4 หลายเดือนก่อน
Master 61 Tableau Charts from Basic to Advanced
Tableau Complete Project End-to-End | Like I Do in My Real Projects
มุมมอง 86K5 หลายเดือนก่อน
Tableau Complete Project End-to-End | Like I Do in My Real Projects
Mastering Tableau Dashboards: Layout Containers Explained | #Tableau Course #137
มุมมอง 10K5 หลายเดือนก่อน
Mastering Tableau Dashboards: Layout Containers Explained | #Tableau Course #137
How to Choose the Right Chart for Your Data | #Tableau Course #136
มุมมอง 1.6K5 หลายเดือนก่อน
How to Choose the Right Chart for Your Data | #Tableau Course #136
Tableau Charts: Progress Bar | #Tableau Course #135
มุมมอง 8625 หลายเดือนก่อน
Tableau Charts: Progress Bar | #Tableau Course #135
Tableau Charts: Funnel Chart | #Tableau Course #134
มุมมอง 1.2K5 หลายเดือนก่อน
Tableau Charts: Funnel Chart | #Tableau Course #134
Tableau Charts: BANS | #Tableau Course #133
มุมมอง 8425 หลายเดือนก่อน
Tableau Charts: BANS | #Tableau Course #133
Tableau Charts: KPI & Bar Chart | #Tableau Course #132
มุมมอง 6596 หลายเดือนก่อน
Tableau Charts: KPI & Bar Chart | #Tableau Course #132
Tableau Charts: KPI | #Tableau Course #131
มุมมอง 6196 หลายเดือนก่อน
Tableau Charts: KPI | #Tableau Course #131
Tableau Charts: Box Plot | #Tableau Course #130
มุมมอง 1.3K6 หลายเดือนก่อน
Tableau Charts: Box Plot | #Tableau Course #130
How to Create a Dynamic Quadrant Chart in Tableau | #Tableau Course #129
มุมมอง 9036 หลายเดือนก่อน
How to Create a Dynamic Quadrant Chart in Tableau | #Tableau Course #129
Tableau Charts: Butterfly (Tornado) Charts (2 Methods) | #Tableau Course #128
มุมมอง 7166 หลายเดือนก่อน
Tableau Charts: Butterfly (Tornado) Charts (2 Methods) | #Tableau Course #128
Tableau Charts: Pareto Charts (2 Methods) | #Tableau Course #127
มุมมอง 7046 หลายเดือนก่อน
Tableau Charts: Pareto Charts (2 Methods) | #Tableau Course #127
Tableau Charts: Waterfall Chart | #Tableau Course #126
มุมมอง 1.1K6 หลายเดือนก่อน
Tableau Charts: Waterfall Chart | #Tableau Course #126
Tableau Charts: Calendar | #Tableau Course #125
มุมมอง 4706 หลายเดือนก่อน
Tableau Charts: Calendar | #Tableau Course #125
Tableau Charts: Histograms | #Tableau Course #124
มุมมอง 4596 หลายเดือนก่อน
Tableau Charts: Histograms | #Tableau Course #124
if anybodys facing a problem while ssms installation and you got a fatal error.. go to this path in your registry editor : Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager and delete the file called 'pendingfilerenameoperations'. try installing again by running as an admin..it will work.. Good Luck
Just WOWwwwwwww!!! Baraa. I am crystal clear about SQL concept watching your youtube videos. keep posting more videos. I am waiting!!!!!!
You have a course on udemy.. please is it more comprehensive than this?
Valuable and save time . thanks @data with baraa
Hello Baraa, If we hide the header (Axis) and later want to display it again, how can we do that?
Thank you so much for this tutorial. It helped me alot 😍
Nice Explanation
This video is incredibly insightful, packed with so much knowledge and presented with exceptional clarity. The way you explain complex concepts in such an easy-to-understand manner is truly impressive. Thank you for dedicating your time and effort to create these videos. Your content stands out as some of the best I’ve come across. Keep up the fantastic work!
let me say this baraa!! my friends and I are becoming data engineers and are currently studying computer science in London and all of us agree that there is no one better out there who teaches SQL like you do. I would also love to hear from you what are your thoughts on data engineering, what technologies you would recommend and whether are you planning on any content related to DE.
That's one of the best! Can't thank you enough!
Can you please share the data set which you have used in this video. Or just tell me where can I download it from.
Thank you for putting this course up. It's awesome.
Baraa, I'm at a loss for words-this video is absolutely fantastic. I thoroughly enjoyed every moment of the training. It’s truly incredible and has significantly enhanced my Tableau skills. Thank you so much for creating this!
Great work sharing awesome content. Looking forward to more. Can we expect an end-to-end project data analysis video in the future? From SQL to Tableau? 🤞
Thank you Baraa. If you can please make a professional dashboard for mobile view and default.
I don't know how to appreciate you. You are the best among all
where i can get the dataset
Thank you for the tutorial, I learned a lot following all the steps :)!
hello Mr. baraa and thank you sooo much for this hands-on project I am learning Tableau now in a course without any assignments and I was desperately looking for something like that and this video just saved my life please do more of them. Secondly, for the trends of average sales and profit still did not get why did we do another calculated field , like even after doing that we still have some orange faded color above the avg. refrince line !
Great!! Baraa. Like always you have made my concepts crystal clear. Awaiting for next video, Thank You so much and lots of love and respect!
Thanks for this "Baraa", a very clear explanation.
Well explained.thnx
Thank you 1000 times. god bless you Bara !
I can saw without any doubt this is the best Tableau course in the world, Man covered every square inch of Tableau. God replenish you.
make a "python for data learners" course too , this sql course is top notch
what is the letter t after the query
Not able to find out from where to download Data
After 2 mins of watching,, I subscribed 😍😍😍
Hi Baraa, How to find out the relationship between the dimensions? you said there was a relationship between department and job title but no relationship between education level. how did you get this relationships?
I want to control the parameter I have with my buttons I have created. But when I use the "Change Parameter" option from Actions in Dashboard section, I have "None" in the Source field. What should I do to have my parameter options there so I can control the options in my drop down using buttons on my dashboard ?
You are the besttt teacher on the entire TH-cam!!
Thanks 🙏
This is one of the best tutorial I have ever seen.. Well articulated and easy to follow
Wow, thanks!
Thank you…. What you are doing is amazing. People like you who share excellent knowledge definitely make world a better place. ❤
So nice of you
You videos are really helping a lot to me. Tq u 😀
My pleasure 😊
Thanks for putting so much efforts!! Never saw any course material with this much details and information. Thank you so much💖
Glad it was helpful!
Watching from Indonesia. you'r like a hero for me sir, you helped me a lot understanding all this, something i could't found in another channel. thankyou so much, god bless you
I am your hero ?? Wow ❤️❤️❤️ this is amazing !!
Cant thank enough❤
You are so welcome
such high quality lectures with less views dont know why. I have shared your playlist in my college placement group. Thanks for such amazing quality lectures
Wow amazing thanks for your support. With your help I might reach others like you.
Wonderful explanation.thanks
Glad it was helpful!
@@DataWithBaraa I have a problem.plz help me solve it.workbench of MySQL is not supported by os of my Macoas ventura.password is not accepted.although it's correct one.
@@DataWithBaraaI have learnt Excel tableau n SQL .I want remote job.i don't have tech background.what step should I take next.i need guidance
THANK YOU SO MUCH FOR THIS CONTANT
WELCOME
Engineer Baraa you are accused, and I demand that all forces in all countries arrest you immediately on charges of simplifying information and the depth of information that you are doing. The charge against you is that you are doing all this for free.😅 I am from Egypt. When I meet you, I will force you to take a picture with you and then I will hand you over to Federal Security.
Ahhahahahah I was planning to visit Egypt on September but I think I have to cancel it and hide 🙈
@@DataWithBaraa Don't worry, our police don't arrest people with beautiful hairstyles😬😅
I can't see the link to copy the circle KPI if CY sales is less than PY sales...could u help here pls. thanks
love your content! will you cover indexing in the future?
@@WahyuRamadhan-i7h noted
@@DataWithBaraa thank you so much!
Awesome explanation , you are too good.
Thanks a ton
Very brilliant ❤❤❤
Thanks !
@DataWithBaraa, Hi, the dataset provided in the description has several numerical fields in string type. I tried to convert them to numeric, but most turned into null. Could you please help with the issue?
"Data doesn't lie; it guides."
"Create with confidence, and the audience will follow."
Amazing!! Thanks a lot, you're efforts are truly appreciated.
Well Done, Another Awesome Tutorial Crystal Clear and Concise. Like you stressed right away from the beginning, Null is unknow or missing value, different from zero, I cant see any circumstances null should be replaced by zero except in the division in order to secure the operation validity and return Null. Fair enough. In other operations like aggregation if not replaced with the mean, mode, or some other imputation means, Nulls values are often ignored, I mean dropped at the time of calculations or simply all the records kicked out. Again, it was an amazing tutorial, thank you a lot for the hard work. I hope to see you sooner on subqueries