Summary
Keywords
Full Transcript
Save up to 50% off Maven Pro Plans! ➡️ https://bit.ly/4cXXTHo Try the Data Drill yourself and let us know how you do! https://bit.ly/4cbnIoj Four experts. Four tools. One winner… 🏆 In this video, Maven Analytics instructors Aaron Parry, Enrique Ruiz, 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 #9: "The Price is Right", we’re testing our experts' ability to handle complex historical data. We have a pizza restaurant dataset with three tables: transactions, products, and a price history log. The task at hand is to accurately look up the price for every transaction based on when it occurred. This isn’t a simple lookup. The experts must navigate price changes over time to ensure the revenue reflects the exact price on the day of the order. NOTE: If the effective date of a price change is equal to the order date for a transaction, then that is the price that should be reflected. 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 point-in-time lookups and slowly changing dimensions using some of the most popular data and AI tools! 👉 Try Data Drill #9 yourself: https://bit.ly/48zp4qF 🎉 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: 👉 Build job-ready data skills: Excel Learning Path: https://bit.ly/4mrCFpE Power BI Learning Path: https://bit.ly/4mveDu8 SQL Learning Path: https://bit.ly/4mrCXge Python Learning Path: https://bit.ly/41zeHiL 👉 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 #9: “The Price is Right” 01:22 - Meet the experts 01:50 - Power BI solution (Aaron) 06:27 - Python solution (Chris B.) 9:25 - SQL solution (John) 16:07 - Excel solution (Enrique) 19:34 - 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/4cbnIoj
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
