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

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 🔗 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