This Power BI report provides a comprehensive analysis of the UEFA Champions League from 1992 to 2021. The data used in this report is sourced from sports-statistics.com and covers the performance of clubs, countries, players, and coaches.
The goal is to offer key insights into historical performances and identify key trends through interactive visualizations and performance indicators (KPIs).
Report Structure
The report is organized into 5 main pages, each with a specific objective:
📄 Page 1: 🏆 Executive Dashboard (KPIs & Navigation)
🎯 Objective: Provide a quick overview of key performance indicators (KPIs) and facilitate navigation between different report pages.
📊 Visualizations:
- Total goals scored: Based on PlayerGoalTotals.
- Total matches played: Based on PlayerAppearTotals.
- Top scorer (name and number of goals): Based on TopGoalScorer.
- Club with the most titles: Based on AllTimeRankingByClub.
- Country with the most wins: Based on AllTimeRankingByCountry.
- Navigation Buttons:
- "Historical Rankings" → Page 2.
- "Club and Country Performance" → Page 3.
- "Key Players and Coaches" → Page 4.
- "Records and Trends" → Page 5.
📄 Page 2: 📊 Historical Rankings (Clubs and Countries)
🎯 Objective: Visualize the evolution of performance over time.
📊 Visualizations:
- Bar Chart: Ranking of clubs by total Wins.
- Map: Ranking of countries by wins.
- Table: Detailed club rankings.
- Ribbon Chart: Evolution of club and country rankings over seasons.
- Slicers: Filter by country, and club.
📄 Page 3: ⚽ Performance by Club and Country
🎯 Objective: Analyze performance in terms of goals and match statistics.
📊 Visualizations:
- Clustered Bar Chart: Sum of Goals For and Goals Against by Club.
- Table: Detailed country statistics (Match played, wins, Titls, Points).
- Slicers: Filter by country, and club.
📄 Page 4: 👥 Key Players and Coaches
🎯 Objective: Highlight the performance of top players and coaches.
📊 Visualizations:
- Bar Chart: Top scorers (TopGoalScorer).
- Bar Chart: Appearances by coach (CoachesAppearTotals).
- Table: Player Performance by Year and Club
- Slicers: Filter by season, player, and coach.
📄 Page 5: 📈 Records and Trends
🎯 Objective: Identify historical records and key trends in the Champions League.
📊 Visualizations:
- Bar Chart: Average Goals Per Match (Top 10 Clubs)
- Line chart: Evolution of total goals scored over seasons.
- Bar Chart: Top 10 Clubs by Titles
- Slicers: Filter by club.
⚙️ Data Sources
The data used in this report is sourced from sports-statistics.com and includes:
- AllTimeRankingByClub: Historical rankings of clubs.
- AllTimeRankingByCountry: Historical rankings of countries.
- PlayerGoalTotals & PlayerGoalDetails: Detailed player statistics.
- CoachesAppearTotals: Coach appearance statistics.
- TopGoalScorer: Top goal scorer rankings.
🛠️ Technologies Used
- Power BI Desktop for report creation and publishing.
- DAX (Data Analysis Expressions) for custom measures and calculations.
- Filters and Slicers for interactive exploration and navigation.
🏅 Overall Objective
- Analyze and compare club and country performances in the UEFA Champions League.
- Identify historical trends and records.
- Provide an interactive tool to explore key statistics.
eyJrIjoiNGFmMDA4NjYtMzc0YS00ODAzLThhOTYtYTYyMzM0MzVhM2M5IiwidCI6IjY2NjE5MTlhLThmMTQtNGRjMi1iMjQ4LTdkMWY2YmUwNTkxNiIsImMiOjF9
