# abdullahprobro/f1-formula-1-performance-dashboard- architecture

> Architecture diagram of the GitHub repository abdullahprobro/f1-formula-1-performance-dashboard-, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/abdullahprobro/f1-formula-1-performance-dashboard-
- Repository: https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-

## Overview

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`](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md) (Interactive dashboard)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_prep["Data Preparation"]
  node_power_query["Power Query ETL<br/>[README.md]"]
end

subgraph group_model["Data Model"]
  node_fact_results[("Race results fact<br/>[README.md]")]
  node_dim_drivers[("Driver dimension<br/>[README.md]")]
  node_dim_constructors[("Constructor dimension<br/>[README.md]")]
  node_dim_calendar[("Race calendar dimension<br/>[README.md]")]
  node_star_schema["Star schema<br/>[README.md]"]
end

subgraph group_metrics["Analytics"]
  node_dax_measures["DAX measures<br/>[README.md]"]
end

subgraph group_dashboard["Dashboard"]
  node_kpi_cards["Executive KPI cards<br/>[README.md]"]
  node_driver_wins["Driver wins chart<br/>[README.md]"]
  node_constructor_points["Constructor points chart<br/>[README.md]"]
  node_geography_map["Driver and circuit map<br/>[README.md]"]
  node_reliability["Reliability donut<br/>[README.md]"]
  node_season_slicers["Season slicers<br/>[README.md]"]
  node_dashboard_canvas["Interactive dashboard<br/>[README.md]"]
end

node_analyst(("Analyst or fan"))
node_race_data["Race data"]

node_race_data -->|"extracts data"| node_power_query
node_power_query -->|"transforms results"| node_fact_results
node_power_query -->|"prepares drivers"| node_dim_drivers
node_power_query -->|"prepares constructors"| node_dim_constructors
node_power_query -->|"prepares calendar"| node_dim_calendar
node_fact_results -->|"central fact"| node_star_schema
node_dim_drivers -->|"dimension relation"| node_star_schema
node_dim_constructors -->|"dimension relation"| node_star_schema
node_dim_calendar -->|"dimension relation"| node_star_schema
node_star_schema -->|"supplies model data"| node_dax_measures
node_dax_measures -->|"provides metrics"| node_kpi_cards
node_dax_measures -->|"provides metrics"| node_driver_wins
node_dax_measures -->|"provides metrics"| node_constructor_points
node_star_schema -->|"supplies locations"| node_geography_map
node_dax_measures -->|"provides DNF counts"| node_reliability
node_analyst -->|"selects seasons"| node_season_slicers
node_season_slicers -->|"filters model"| node_star_schema
node_season_slicers -->|"updates dashboard"| node_dashboard_canvas
node_dashboard_canvas -->|"displays"| node_kpi_cards
node_dashboard_canvas -->|"displays"| node_driver_wins
node_dashboard_canvas -->|"displays"| node_constructor_points
node_dashboard_canvas -->|"displays"| node_geography_map
node_dashboard_canvas -->|"displays"| node_reliability
node_analyst -->|"explores visuals"| node_dashboard_canvas

click node_power_query "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_fact_results "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_dim_drivers "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_dim_constructors "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_dim_calendar "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_star_schema "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_dax_measures "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_kpi_cards "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_driver_wins "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_constructor_points "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_geography_map "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_reliability "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_season_slicers "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"
click node_dashboard_canvas "https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_power_query toneBlue
class node_fact_results,node_dim_drivers,node_dim_constructors,node_dim_calendar,node_star_schema toneAmber
class node_dax_measures toneMint
class node_kpi_cards,node_driver_wins,node_constructor_points,node_geography_map,node_reliability,node_season_slicers,node_dashboard_canvas toneRose
class node_analyst,node_race_data toneIndigo
```

## Components

### Data Preparation

- [Power Query ETL](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`

### Data Model

- [Race results fact](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Driver dimension](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Constructor dimension](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Race calendar dimension](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Star schema](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`

### Analytics

- [DAX measures](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`

### Dashboard

- [Executive KPI cards](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Driver wins chart](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Constructor points chart](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Driver and circuit map](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Reliability donut](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Season slicers](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`
- [Interactive dashboard](https://github.com/abdullahprobro/f1-formula-1-performance-dashboard-/blob/main/README.md): `README.md`

### Other components

- **Analyst or fan**
- **Race data**

## Connections

- 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