Excel - La Liga

Immerse yourself in the exhilarating world of La Liga  analytics using Microsoft Excel.

This micro course is tailored for enthusiasts who want to master data manipulation and visualization with real-time datasets from the La Liga.
Learn to clean, analyze, and visualize player statistics, team performance, and match trends.
Gain the skills to create dynamic dashboards that offer valuable insights.


Excel Bootcamp

  


La Liga Data Lab  

The Intro course is free

  • Video Introduction
  • Paid Section Preview
  • Theory
  • Case Study Preview
  • Practice

#1 Excel Bootcamp

Sections included :

  • Working with tables
  • CountA() Function
  • CountIFS() Function
  • Exploring Excel
  • CountIF() Function
  • SumIF() Function
  • IF() Function
  • Data Validation & CountIF()
  • SumIFS() Function
  • Average() Function
  • AverageIF() Function
  • AverageIFS() Function
  • Pivot Tables

#2 Advanced Excel 

Sections included :

  • VLOOKUP() Function
  • MATCH() Function
  • LEFT() Function
  • HLOOKUP() Function
  • TRIM() Function
  • RIGHT() Function
  • INDEX() Function
  • CLEAN() Function
  • MID() Function
  • SUBSTITUTE() Function
  • Data Cleaning

#3 Playground

Sections included :

  • Case Study 1: The Home Ground Advantage
  • Case Study 2: Clash of the Titans
  • Case Study 3: Win - Loss Ration
  • Case Study 4: Analyzing Data based on Performance Ranking

#4 Practice Section

Sections included :

  • IF() Function Exercises
  • COUNTA(), COUNTIF() & COUNTIFS()
  • SUM(), SUMIF() & SUMIFS() Functions
  • AVERAGE(), AVERAGEIF() & IFS()

Data Labs

#5 Case Studies

A Data Lab is essentially a dynamic learning environment where we put into practice the latest skills we've acquired in Excel through the League of your choosing.

In this section, our focus shifts to the realm of La Liga data.

Data Lab serves as a practical course where we immerse ourselves in hands-on Case Studies, applying our knowledge to gain insights and make data-driven decisions.

With each Case Study, we explore new dimensions of data analysis, allowing us to delve into the latest trends and uncover hidden patterns within the world of La Liga data.

Sections included :

Case Study #1 : Performance statistics of Almería

Almeria shows considerable offensive prowess, but there are areas that need improvement, mainly in team discipline and player health. Adopting a balanced strategy that accounts for both aggressive gameplay and long-term player well-being could be beneficial. ⚽🔥

Case Study #2 : Performance statistics of Espanyol

Espanyol displays a balanced performance but has room for improvement in both offensive and defensive strategies. The focus should be on discipline to reduce the number of yellow and red cards. Offensively, the team needs to convert more of their scoring opportunities into goals. Defensively, adjustments are needed to excel in specific matchups. This analysis provides valuable insights for upcoming matches and seasons. ⚽🔥

Case Study #3 : Performance statistics of Getafe

Getafe shows a fairly balanced performance but has room for improvement in several areas. Their strengths lie in resilience and some degree of control over the game. However, they must focus on disciplinary aspects, as shown by the high frequency of yellow cards. The pivot tables further underline their offensive variation and defensive capabilities, but also highlight areas that need fine-tuning for better performance. 🏆⚽

Case Study #4 : Performance statistics of Mallorca

Mallorca exhibits a balanced but somewhat conservative approach in their matches. While they maintain a relatively disciplined defense, as evidenced by the number of yellow and red cards, there's room for improvement in their offensive strategies and pass quality. The team could benefit from focusing on more effective shots on target and reducing the number of fouls. 📊⚽

Case Study #5 : Performance statistics of Osasuna

Osasuna shows strengths in individual skills, particularly in duels won. However, there are areas needing improvement, particularly in discipline and offensive efficiency. Addressing these could elevate Osasuna's overall performance in future matches. ⚽🏆

Case Study #6 : Performance statistics of Valencia

Based on the analysis, Valencia shows a well-rounded performance in various metrics. The team excels in successful passes and has strong physical attributes, as seen in the number of duels won. They also show promise in their offensive capabilities, with a decent number of matches having more than 10 shots. However, the data suggests a need for improvement in discipline, as indicated by the number of yellow cards, and in generating assists. 📊⚽