SQL Tips - Data Drill Showdown #6: Streak Leaderboard | Excel vs. Power BI vs. SQL vs. Python

Save up to 50% off Maven Pro Plans! ➡️ https://bit.ly/4cXXTHo Four experts. Four tools. One winner 🏆 Watch as Maven Analytics instructors Aaron Parry, John Pauler, Chris Bruehl, and special guest Giles Male 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 #6: “Streak Leaderboard”, the task is to calculate the active streak for each user, then create a leaderboard of the top 10 users with the longest active streaks. 🔘 The streak length is the number of consecutive days with at least one lesson completion 🔘 For the purpose of this drill, consider the current date to be 2025-09-29 🔘 For a streak to be considered “active”, the user must have completed a lesson on 2025-09-28 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 tackle real-world data problems using some of the most popular data & AI tools! 🎉 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 links: 👉 Free Data Drills: https://bit.ly/4qOt3aB 👉 Build job-ready data skills: Excel Learning Path: https://bit.ly/48a1Mb8 Power BI Learning Path: https://bit.ly/49gVS9g SQL Learning Path: https://bit.ly/4nSeBvo Python Learning Path: https://bit.ly/3JZEPhB 👉 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/ Giles: https://www.linkedin.com/in/giles-male-30643b15/ ⏱️ Timestamps: 00:00 - Intro to Data Drill #6: “Streak Leaderboard” 01:19 - Meet the experts 02:04 - Power BI solution (Aaron) 08:41 - SQL solution (John) 15:45 - Python solution (Chris B.) 20:06 - Excel solution (Giles) 31:32 - 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 at Maven Analytics.