Which Tool Calculates Weighted CTR Fastest? | Excel vs Power BI vs SQL vs Python

Try the Data Drill yourself and let us know how you do! 👉 https://bit.ly/4z2ELBo 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 #17: "Common Denominator", we're testing our experts' ability to correctly aggregate rate metrics across groups using weighted calculations. The dataset is a campaign performance summary for an outdoor gear brand, covering 50 campaigns across 5 marketing channels. Each campaign includes its impression volume and click-through rate. The task is to calculate the click-through rate for each marketing channel and for the account as a whole. The challenge: CTR can't simply be averaged across campaigns. Since impression volumes vary, the experts must work back to the underlying click counts and aggregate them correctly before computing the final rates. 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 weighted aggregation and rate metric rollups using some of the most popular data and AI tools! 👉 Try Data Drill #17 yourself: https://bit.ly/4z2ELBo 🔗 Helpful links: 👉 Build job-ready data skills: Excel Learning Path: https://bit.ly/4ymwpoh Power BI Learning Path: https://bit.ly/4dLsARn SQL Learning Path: https://bit.ly/4hwQz8a Python Learning Path: https://bit.ly/4xNDu09 👉 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 #17: “Common Denominator” 01:10 - Meet the experts 01:33 - Excel solution (Enrique) 03:22 - SQL solution (John) 06:23 - Python solution (Chris B) 11:14 - Power BI solution (Aaron) 13:35 - 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/4xWXOw1