NULL Functions | ZN, IFNULL, ISNULL |
HTML-код
- Опубликовано: 11 сен 2024
- 🎬 Full Tableau Course: • Complete HR Tableau Pr...
⬇️ Free Materials (Downloads): datawithbaraa....
👉 Support & Subscribe to Channel: bit.ly/3GiCVUE
☕ Stay connected
► Subscribe: bit.ly/3GiCVUE
► Join: / @datawithbaraa
► Newsletter: bit.ly/BaraaNe...
► LinkedIn: / baraa-khatib-salkini
► Website: www.datawithba...
📚 Free Courses
✅ Tableau: • Complete HR Tableau Pr...
✅ Tableau Project: • Complete HR Tableau Pr...
✅ SQL Basics: • SQL Tutorial for Begin...
✅ SQL Advanced: • How I'd Learn Advanced...
✅ ChatGPT: • ChatGPT Tutorial for B...
🎓Other Platforms (Certifications)
► Udemy: bit.ly/BaraaUdemy
► Skillshare (1 Free Month): bit.ly/BaraaSk...
⭐ My favorite books: kit.co/DataWit...
💻 My gear: kit.co/DataWit...
#tableau #data #analytics #datascience
*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*
You've quickly become one of my fav Tableau channels, you explain clearly and provide excellent examples. Thank you so much for sharing your knowledge in a way that is understandable and relevant for real world/work applications.
@@toddpashak I am very honored to be able to help you ❤️❤️❤️ thanks for the kind words
To be honest and in my opinion, Baraa is the most underrated Tech Trainer on RUclips. He should have at least 10 million subscribers by now. And I'm going to do my part in ensuring that. And i urge us all to do the same, it's the least we can do to support this great man.
This is what I intend to do. As soon as I'm done with this series (playlist), I'll complete one project, and post on my LinkedIn and Twitter, tagging Baraa's LinkedIn and RUclips handles, this should drive engagement for him.
Thank you for going all out for your audience Baraa ❤❤
@@manlikeMrA omg this is very beautiful to read, your support means a lot and very generous of you. I can’t thank you enough, and only with this kind of support I can reach wonderful people like you ❤️❤️❤️
This is an excellent explanation and example.
Easily understood the concept
Happy to hear 🙂
You are always making Maria sad...😉
@@user-gq3rc4sb6x 😁
I have one question though:
I was considering a possibility where if the age for instance, is null, we replace it with the average age (based on use case) using a formula like IFNULL([customer age], AVG([customer age]) or something following similar logic., but it either threw error (cannot mix aggregate with non-aggregate arguments) or didn't return expected output.
I have tried different alternatives, but none worked.
Do you have any recommendation or workaround?