Excel - Liga Portugal

Immerse yourself in the exhilarating world of Liga Portugal 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 Liga Portugal.
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

  


Liga Portugal 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 Liga Portugal 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 Liga Portugal data.

Sections included :

Case Study #1 : Paços de Ferreira

In conclusion, Paços de Ferreira's 2022/23 season performance revealed potential areas for improvement, such as discipline on the field and consistency in offensive capabilities. 😕 However, they demonstrated effective possession control and passing ability in successful games. ⚽️👏 The team's performance did not significantly differ based on goals scored, suggesting that their strategies may benefit from a more goal-focused approach. 📈🎉

Case Study #2 : Performance statistics of Portimonense

Portimonense's performance in the 2022/23 Liga Portugal season exhibited some significant insights. The team often showed disciplined play with a limited number of red cards 🚫. They also demonstrated attacking prowess with an impressive number of successful passes and shots on target in several matches ⚽. However, there were more yellow cards 🟨 in games with a higher number of fouls, indicating a potential area for improvement. The team seemed to perform better offensively when they had good passing success and physical dominance, as seen in successful headers and duels won 💪. While higher ball possession was not directly associated with more goals, disciplined play did seem to correlate with better offensive outcomes 💡🎯👏.

Case Study #3 : Performance statistics of Chaves

Chaves' performance in the 2022/23 Liga Portugal was characterized by an aggressive play style 💪, evidenced by a high number of fouls 🚩 and yellow cards 🟨, especially in matches where they scored ⚽. Their best performances came when they balanced ball possession 🌐 with discipline 📏, had successful interceptions ✋ and maintained control over the game 🎮. While possession was not always indicative of scoring, successful passes 🔀 appeared pivotal in goal-scoring games 🥅. Moving forward, Chaves may need to focus on discipline 🚫 to minimize cards and refine their strategies in games where they dominate possession 📈 but fail to score ❌.

Case Study #4 : Performance statistics of Rio Ave

Rio Ave demonstrated a mixed performance during the 2022/23 Liga Portugal season. The team showed potential in terms of possession ⚽, passing 🎯, and creating opportunities 🌟, but struggled with consistent goal scoring ⚽, conversion efficiency 📈, and maintaining discipline 📏. By refining their strategy to balance offensive effectiveness 💥 and discipline 📏, the team could significantly enhance their future performance. ⚖️🚀

Case Study #5 : Performance statistics of Gil Vicente

Gil Vicente performance in the 2022/23 Liga Portugal season appears to be a function of controlled aggression, possession dominance, and passing proficiency. Key success factors seem to be maintaining possession 😤, creating numerous shots on target 🎯, successful passing 🔄, and minimizing fouls and cards 🚫. Additionally, the ability to win duels ⚔️, perform successful interceptions 🚷 and headers 🆙, particularly in high scoring matches, can also be vital for their performance. 🏆👏

Case Study #6 : Performance statistics of Famalicão

In conclusion, Famalicão's performance in the 2022/23 season shows they generally perform better in terms of ball possession ⚽, successful passes 🎯, duels won 💪, and successful headers 🆙 when they score goals, particularly 3 goals per match 🥅. However, a higher score line often comes with more fouls ⚠️ and yellow cards 🟨, indicating a possible need for improved discipline 📏 to maintain their positive performance without risking penalties 🚫.