Войти
  • 370440Просмотров
  • 2 месяца назадОпубликованоMaven Analytics

Excel vs Power BI vs SQL vs Python | Stock Market Showdown

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 #7: “Turning Bullish”, we’ve provided a dataset containing daily closing prices for the SPDR S&P 500 ETF Trust (SPY) over the last 5 years. The task at hand is to calculate the 50-day and 200-day moving averages of the closing price and identify every “Golden Cross” — when the short-term average (50-day) crosses from below to above the long-term average (200-day), signaling a potential bull market. 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! 👉 Try Data Drill #7 yourself: Want to dig deeper into stock market analytics? 👉 Stock Market Tracker Guided Project: 🔗 Helpful links: 👉 Build job-ready data skills: Excel Learning Path: Power BI Learning Path: SQL Learning Path: Python Learning Path: 👉 Follow us on LinkedIn: Maven Analytics: Chris D: Aaron: John: Chris B: Enrique: ⏱️ Timestamps: 00:00 - Intro to Data Drill #7: “Turning Bullish” 01:08 - Meet the experts 01:41 - Python solution (Chris B.) 05:38 - Power BI solution (Aaron) 10:21 - SQL solution (John) 18:25 - Excel solution (Enrique) 21:51 - 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.