Excel vs Power BI vs SQL vs Python | UTC Time Zone Conversion Drill
Try the Data Drill yourself and let us know how you do! 👉 https://bit.ly/46XnsWv 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 #16: "Time Shift", we're testing our experts' ability to work with time zones and aggregate datetime data across a global dataset. The dataset contains 22,000 support tickets from 700 users spread across 20 countries, each timestamped in UTC. To make sense of when tickets are actually being submitted, the data needs to be translated into each user's local time. The task is to convert every ticket's UTC timestamp to the corresponding user's local time, then calculate ticket volume by local hour of day (0 through 23) across the full dataset. This requires accurately mapping each user to their time zone and applying the correct offset before any aggregation can happen. 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 time zone conversion and datetime aggregation using some of the most popular data and AI tools! 👉 Try Data Drill #16 yourself: https://bit.ly/46XnsWv 🔗 Helpful links: 👉 Build job-ready data skills: Excel Learning Path: https://bit.ly/4hsL0Zl Power BI Learning Path: https://bit.ly/3UXPFd6 SQL Learning Path: https://bit.ly/3UU99zj Python Learning Path: https://bit.ly/4743GZm 👉 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 #16: “Time Shift” 01:25 - Meet the experts 01:52 - Python solution (Chris B) 06:44 - Power BI solution (Aaron) 12:21 - SQL solution (John) 18:14 - Excel solution (Enrique) 22:24 - 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/4cMUM64