# lukebarousse/excel_data_analytics_course architecture

> Architecture diagram of the GitHub repository lukebarousse/excel_data_analytics_course, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-12). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/lukebarousse/excel_data_analytics_course
- Repository: https://github.com/lukebarousse/excel_data_analytics_course

## Overview

This repository is a downloadable Excel course, not an application: learners follow chapter workbooks, practice with problem workbooks, and use supplied datasets and project workbooks. The README documents the chapter topics and practice-problem collection; the tree shows datasets and two projects, but their contents and relationships were not sampled, so those are represented without inferred workflow edges.

Main entry points: [`1_Spreadsheets_Intro`](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/1_Spreadsheets_Intro) (Spreadsheet foundations), [`2_Formulas_Functions`](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/2_Formulas_Functions) (Formulas and functions), [`3_Charts_Graphs`](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/3_Charts_Graphs) (Charts and graphs), [`4_Spreadsheets_Advanced`](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/4_Spreadsheets_Advanced) (Advanced spreadsheets)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_learn["Course chapters"]
  node_foundations["Spreadsheet foundations"]
  node_formulas["Formulas and functions"]
  node_charts["Charts and graphs"]
  node_advanced["Advanced spreadsheets"]
end

subgraph group_analyze["Analysis workflows"]
  node_pivots["Pivot tables"]
  node_analysis["Advanced analysis"]
  node_query["Power Query"]
  node_powerpivot["Power Pivot and DAX"]
end

subgraph group_apply["Practice and projects"]
  node_problems["Course problem workbooks"]
  node_dashboard["Salary dashboard project"]
  node_projectanalysis["Analysis project"]
end

subgraph group_materials["Learning resources"]
  node_datasets[("Datasets")]
  node_shortcuts["Excel shortcuts"]
end

node_learner(("Learner"))

node_learner -->|"studies"| node_foundations
node_learner -->|"studies"| node_formulas
node_learner -->|"studies"| node_charts
node_learner -->|"studies"| node_advanced
node_learner -->|"studies"| node_pivots
node_learner -->|"studies"| node_analysis
node_learner -->|"studies"| node_query
node_learner -->|"studies"| node_powerpivot
node_learner -->|"practices with"| node_problems

click node_foundations "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/1_Spreadsheets_Intro"
click node_formulas "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/2_Formulas_Functions"
click node_charts "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/3_Charts_Graphs"
click node_advanced "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/4_Spreadsheets_Advanced"
click node_pivots "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/5_Pivot_Tables"
click node_analysis "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/6_Advanced_Data_Analysis"
click node_query "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/7_Power_Query"
click node_powerpivot "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/8_Power_Pivot"
click node_problems "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/0_Resources/Problems"
click node_dashboard "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/Project_1-Dashboard"
click node_projectanalysis "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/Project_2-Analysis"
click node_datasets "https://github.com/lukebarousse/excel_data_analytics_course/tree/main/0_Resources/Datasets"
click node_shortcuts "https://github.com/lukebarousse/excel_data_analytics_course/blob/main/0_Resources/Excel%20Shortcuts.xlsx"

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_foundations,node_formulas,node_charts,node_advanced toneBlue
class node_pivots,node_analysis,node_query,node_powerpivot toneAmber
class node_problems,node_dashboard,node_projectanalysis toneMint
class node_datasets,node_shortcuts toneRose
class node_learner toneIndigo
```

## Components

### Course chapters

- [Spreadsheet foundations](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/1_Spreadsheets_Intro): `1_Spreadsheets_Intro`
- [Formulas and functions](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/2_Formulas_Functions): `2_Formulas_Functions`
- [Charts and graphs](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/3_Charts_Graphs): `3_Charts_Graphs`
- [Advanced spreadsheets](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/4_Spreadsheets_Advanced): `4_Spreadsheets_Advanced`

### Analysis workflows

- [Pivot tables](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/5_Pivot_Tables): `5_Pivot_Tables`
- [Advanced analysis](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/6_Advanced_Data_Analysis): `6_Advanced_Data_Analysis`
- [Power Query](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/7_Power_Query): `7_Power_Query`
- [Power Pivot and DAX](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/8_Power_Pivot): `8_Power_Pivot`

### Practice and projects

- [Course problem workbooks](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/0_Resources/Problems): `0_Resources/Problems`
- [Salary dashboard project](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/Project_1-Dashboard): `Project_1-Dashboard`
- [Analysis project](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/Project_2-Analysis): `Project_2-Analysis`

### Learning resources

- [Datasets](https://github.com/lukebarousse/excel_data_analytics_course/tree/main/0_Resources/Datasets): `0_Resources/Datasets`
- [Excel shortcuts](https://github.com/lukebarousse/excel_data_analytics_course/blob/main/0_Resources/Excel%20Shortcuts.xlsx): `0_Resources/Excel Shortcuts.xlsx`

### Other components

- **Learner**

## Connections

- Learner → Spreadsheet foundations: studies (evidence: `README.md`)
- Learner → Formulas and functions: studies (evidence: `README.md`)
- Learner → Charts and graphs: studies (evidence: `README.md`)
- Learner → Advanced spreadsheets: studies (evidence: `README.md`)
- Learner → Pivot tables: studies (evidence: `README.md`)
- Learner → Advanced analysis: studies (evidence: `README.md`)
- Learner → Power Query: studies (evidence: `README.md`)
- Learner → Power Pivot and DAX: studies (evidence: `README.md`)
- Learner → Course problem workbooks: practices with (evidence: `README.md`)