SQL Tips - Excel vs SQL vs Power BI vs Python | Org Chart Overhaul

Save up to 50% off Maven Pro Plans! ➡️ https://bit.ly/4cXXTHo Maven instructors Enrique Ruiz, Alice Zhao, Aaron Parry, and Chris Bruehl explain how to tackle parent-child hierarchies in Excel, SQL, Power BI, and Python, respectively. Starting with a list of employees and their managers, their task is to create 3 new columns: 🔘 Reporting Hierarchy: The chain of command from the highest-ranking manager down to you 🔘 Direct Reports: The number of employees that report to you as their manager 🔘 Total Reports: The total number of employees beneath you in the reporting hierarchy (your direct reports, plus their direct reports, etc.) Try this Data Drill out yourself! 👉 https://bit.ly/4hViH3H 🎉 UP TO 50% OFF SPRING SAVINGS 🎉 The LOWEST PRICING of the season starts NOW! AI is reshaping every industry, and the professionals who will thrive aren’t waiting to figure it out. They’re building real skills right now. You can, too! For Spring Savings, you can choose from 3 great offers through May 6th: 👉 Monthly plan: 25% off your first 3 months ($36.75/mo) 👉 Annual plan: 50% off your first year ($199.50/yr) 👉 Lifetime access: 50% off, forever ($849.50) All Maven Pro memberships include: ✓ Unlimited access to ALL courses & learning paths ✓ Customized learning plans ✓ Guided projects ✓ Skills assessments ✓ Showcase portfolio builder ✓ Free practice data sets ✓ Private student dashboard ✓ Live instructor chat support Plus something brand NEW, launching soon...👀 Build job-ready AI + data skills, all in one membership. SAVE NOW 👉 https://bit.ly/4cXXTHo 🔗 Helpful Resources 👉 Build Data Skills with Maven Analytics: https://bit.ly/4krUtzS 👉 Follow us on LinkedIn: Maven Analytics: https://www.linkedin.com/company/maven-analytics Enrique: https://www.linkedin.com/in/enrique-ruiz-tapia/ Alice: https://www.linkedin.com/in/alicexzhao/ Aaron: https://www.linkedin.com/in/amp28/ Chris: https://www.linkedin.com/in/chrisbruehl/ ⏱️ Timestamps: 00:00 - Intro 00:13 - Data Drill Objective 01:08 - Excel Solution Walkthrough 10:26 - SQL Solution Walkthrough 20:35 - Power BI Solution Walkthrough 28:08 - Python Solution Walkthrough 40:13 - Validation Question 40:28 - Outro/Resources Maven Analytics is an award-winning online platform for data professionals to learn new skills, showcase their work, and connect with peers around the world. We've helped more than 1,000,000 students build job-ready data & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundations for successful careers. Start learning and build your FREE portfolio at www.MavenAnalytics.io