Which Tool Handles a Multi-Level Bill of Materials Best? | Excel vs Power BI vs SQL vs Python

🎉 Early Black Friday Savings! 🎉 Save $160 on a full year of Maven Pro 👉 https://bit.ly/4C13VCQ Try the Data Drill yourself and let us know how you do! 👉 https://bit.ly/4zdOXrt Four experts. Four tools. One winner… 🏆 In this video, Maven Analytics instructors Enrique Ruiz, Aaron Parry, John Pauler, and Chris Bruehl battle it out with their favorite tools to earn the title of Data Drill Champion. Excel. Power BI. SQL. Python. Who will come out on top? For Data Drill #18: "Full Assembly", we're testing our experts' ability to break down complex product hierarchies into their most basic parts. We have a bicycle manufacturing dataset with order records for six bike models, along with a bill of materials. The bill of materials shows how each model breaks down into subassemblies, and how those subassemblies break down even further. The task at hand is to calculate the total quantity of each individual part needed to fulfill every order in the dataset. This isn't a simple lookup. The experts must work through every level of the structure, count only the parts at the very bottom (not the intermediate subassemblies), and make sure every occurrence is counted when a part shows up in more than one place. Each expert will be on the clock as they solve the drill, and the best solution takes the crown. Follow along to sharpen your skills and learn how to master recursive hierarchies and bill of materials explosions using some of the most popular data and AI tools! 👉 Try Data Drill #18 yourself: https://bit.ly/4zdOXrt 🔗 Helpful links: 👉 Build job-ready data skills: Excel Learning Path: https://bit.ly/4yLHrTK Power BI Learning Path: https://bit.ly/4yPuOqC SQL Learning Path: https://bit.ly/4Bx3sYY Python Learning Path: https://bit.ly/4is1Dnz 👉 Follow us on LinkedIn: Maven Analytics: https://www.linkedin.com/company/maven-analytics Chris D: https://www.linkedin.com/in/csdutton/ Aaron: https://www.linkedin.com/in/amp28/ John: https://www.linkedin.com/in/johnpauler/ Chris B: https://www.linkedin.com/in/chrisbruehl/ Enrique: https://www.linkedin.com/in/enrique-ruiz-tapia/ ⏱️ Timestamps: 00:00 - Intro to Data Drill #18: “Full Assembly” 01:36 - Meet the experts 02:02 - Excel solution (Enrique) 10:43 - Python solution (Chris B) 19:56 - SQL solution (John) 31:34 - Power BI solution (Aaron) 38:29 - Results & winner selection Maven Analytics is an award-winning learning platform where individuals and teams build new skills, showcase work, and connect with experts around the world. We've helped 2M+ people build job-ready data literacy & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundation for successful careers. Start building life-changing skills for FREE 👉 https://bit.ly/4BrKYcp