← awmium/portfolio
portfolio/football-summer-transfers.mdread-only
---
tags: [power-bi, sports, enterprise-dna]
stack: [power-bi, dax]
read: 2 min
---

Football Summer Transfers

Built for an Enterprise DNA challenge on the 2022-23 summer transfer window: 2,000 transfers, 1,952 players, 82 countries, 60 leagues and 556 clubs. It is my most app-like report, with a landing page, a bottom navigation bar and a different question on every page.

Landing page
Landing page
Overview: market value, fees, loans and the busiest clubs
Overview: market value, fees, loans and the busiest clubs

The pages

  • Overview: market value, total fees, loans and the clubs with the most transfers.
  • Details: oldest and youngest players by club, league or country, and under-18 transfers by country.
  • Player: fees and market value by age and by position.
  • Comparison: transfers in and out, by league and by club.
  • Tree: a decomposition tree from total transfers down to a single player.
  • Team: a starting eleven by position, with market values and fees, laid out on a pitch.
Details: player ages and under-18 transfers
Details: player ages and under-18 transfers
Player: fees and market value by age and position
Player: fees and market value by age and position
Comparison: transfers in and out by league
Comparison: transfers in and out by league
Tree: from total transfers down to a player
Tree: from total transfers down to a player
Team: a starting eleven on the pitch
Team: a starting eleven on the pitch
read# Football Summer Transfers[ ] sections176 words · 2 min · utf-8 · LFTop