How abdullahprobro/f1-formula-1-performance-dashboard- works
This repository documents a Power BI dashboard that turns four seasons of Formula 1 race data into interactive performance and reliability analysis. The workflow runs from data extraction and Power Query transformations, through a star-schema model and DAX measures, to dashboard visuals that users explore with season slicers and cross-filtering. The README describes the capabilities and relationships, but the supplied tree contains no implementation files; component paths therefore point to the README, and the diagram reflects documented architecture rather than verified source-level wiring.
Main entry points: README.md Interactive dashboard
Components 16
Data Preparation
- Power Query ETL
README.md
Data Model
- Race results fact
README.md - Driver dimension
README.md - Constructor dimension
README.md - Race calendar dimension
README.md - Star schema
README.md
Analytics
- DAX measures
README.md
Dashboard
- Executive KPI cards
README.md - Driver wins chart
README.md - Constructor points chart
README.md - Driver and circuit map
README.md - Reliability donut
README.md - Season slicers
README.md - Interactive dashboard
README.md
Other components
- Analyst or fan
- Race data
Connections 24
- Race data → Power Query ETL: extracts data
- Power Query ETL → Race results fact: transforms results
- Power Query ETL → Driver dimension: prepares drivers
- Power Query ETL → Constructor dimension: prepares constructors
- Power Query ETL → Race calendar dimension: prepares calendar
- Race results fact → Star schema: central fact
- Driver dimension → Star schema: dimension relation
- Constructor dimension → Star schema: dimension relation
- Race calendar dimension → Star schema: dimension relation
- Star schema → DAX measures: supplies model data
- DAX measures → Executive KPI cards: provides metrics
- DAX measures → Driver wins chart: provides metrics
- DAX measures → Constructor points chart: provides metrics
- Star schema → Driver and circuit map: supplies locations
- DAX measures → Reliability donut: provides DNF counts
- Analyst or fan → Season slicers: selects seasons
- Season slicers → Star schema: filters model
- Season slicers → Interactive dashboard: updates dashboard
- Interactive dashboard → Executive KPI cards: displays
- Interactive dashboard → Driver wins chart: displays
- Interactive dashboard → Constructor points chart: displays
- Interactive dashboard → Driver and circuit map: displays
- Interactive dashboard → Reliability donut: displays
- Analyst or fan → Interactive dashboard: explores visuals