# jbotes/powerbitutorials architecture

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

- Interactive diagram: https://gitdiagram.com/jbotes/powerbitutorials
- Repository: https://github.com/jbotes/powerbitutorials

## Overview

This repository is a collection of analytics learning and example artifacts, not an evidenced runtime application. Its files cover Power Query transformations, Power BI reports, and notebook-based analysis, alongside example datasets. The file tree provides names but no README or source excerpts, so it does not establish which files consume which datasets or how any workflow runs. The graph therefore groups representative artifacts by format and topic without asserting data flows or execution relationships.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_notebooks["Notebook analyses"]
  node_portfolio_notebook["Portfolio analysis"]
  node_cleaning_notebook["Data cleaning"]
  node_sentiment_notebook["Sentiment analysis"]
  node_bitcoin_notebook["Bitcoin scraping"]
end

subgraph group_powerquery["Power Query examples"]
  node_grouping_example["Advanced grouping"]
  node_portfolio_example["Portfolio comparison"]
end

subgraph group_reports["Power BI reports"]
  node_sentiment_report["Sentiment report"]
  node_customer_report["Customer events"]
  node_moving_average_report["Moving average"]
end

subgraph group_data["Example datasets"]
  node_sales_data["US stock sales"]
  node_feedback_data["Customer feedback"]
  node_portfolio_data["Portfolio sources"]
end

click node_portfolio_notebook "https://github.com/jbotes/powerbitutorials/blob/main/01_PQ_YT_Notebook.ipynb"
click node_cleaning_notebook "https://github.com/jbotes/powerbitutorials/blob/main/02_DataCleaning_Video.ipynb"
click node_sentiment_notebook "https://github.com/jbotes/powerbitutorials/blob/main/666-SentimentAnalysis.ipynb"
click node_bitcoin_notebook "https://github.com/jbotes/powerbitutorials/blob/main/BaSensei_webscrape_Bitcoin_YTVideo.ipynb"
click node_grouping_example "https://github.com/jbotes/powerbitutorials/blob/main/PQ_AdvancedGrouping-Video.xlsx"
click node_portfolio_example "https://github.com/jbotes/powerbitutorials/blob/main/PQ_Portfolio_Comparer_Video.xlsx"
click node_sentiment_report "https://github.com/jbotes/powerbitutorials/blob/main/PQ_SentimentAnalysis_Video.pbix"
click node_customer_report "https://github.com/jbotes/powerbitutorials/blob/main/28_New_Customers_NW_video.pbix"
click node_moving_average_report "https://github.com/jbotes/powerbitutorials/blob/main/PBI_Simple_Moving_Average_Video.pbix"
click node_sales_data "https://github.com/jbotes/powerbitutorials/blob/main/us_stock_sales_2024.csv"
click node_feedback_data "https://github.com/jbotes/powerbitutorials/blob/main/customer_feedback.csv"
click node_portfolio_data "https://github.com/jbotes/powerbitutorials/blob/main/PQ_SourceData_Portfolios.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_portfolio_notebook,node_cleaning_notebook,node_sentiment_notebook,node_bitcoin_notebook toneBlue
class node_grouping_example,node_portfolio_example toneAmber
class node_sentiment_report,node_customer_report,node_moving_average_report toneMint
class node_sales_data,node_feedback_data,node_portfolio_data toneRose
```

## Components

### Notebook analyses

- [Portfolio analysis](https://github.com/jbotes/powerbitutorials/blob/main/01_PQ_YT_Notebook.ipynb): `01_PQ_YT_Notebook.ipynb`
- [Data cleaning](https://github.com/jbotes/powerbitutorials/blob/main/02_DataCleaning_Video.ipynb): `02_DataCleaning_Video.ipynb`
- [Sentiment analysis](https://github.com/jbotes/powerbitutorials/blob/main/666-SentimentAnalysis.ipynb): `666-SentimentAnalysis.ipynb`
- [Bitcoin scraping](https://github.com/jbotes/powerbitutorials/blob/main/BaSensei_webscrape_Bitcoin_YTVideo.ipynb): `BaSensei_webscrape_Bitcoin_YTVideo.ipynb`

### Power Query examples

- [Advanced grouping](https://github.com/jbotes/powerbitutorials/blob/main/PQ_AdvancedGrouping-Video.xlsx): `PQ_AdvancedGrouping-Video.xlsx`
- [Portfolio comparison](https://github.com/jbotes/powerbitutorials/blob/main/PQ_Portfolio_Comparer_Video.xlsx): `PQ_Portfolio_Comparer_Video.xlsx`

### Power BI reports

- [Sentiment report](https://github.com/jbotes/powerbitutorials/blob/main/PQ_SentimentAnalysis_Video.pbix): `PQ_SentimentAnalysis_Video.pbix`
- [Customer events](https://github.com/jbotes/powerbitutorials/blob/main/28_New_Customers_NW_video.pbix): `28_New_Customers_NW_video.pbix`
- [Moving average](https://github.com/jbotes/powerbitutorials/blob/main/PBI_Simple_Moving_Average_Video.pbix): `PBI_Simple_Moving_Average_Video.pbix`

### Example datasets

- [US stock sales](https://github.com/jbotes/powerbitutorials/blob/main/us_stock_sales_2024.csv): `us_stock_sales_2024.csv`
- [Customer feedback](https://github.com/jbotes/powerbitutorials/blob/main/customer_feedback.csv): `customer_feedback.csv`
- [Portfolio sources](https://github.com/jbotes/powerbitutorials/blob/main/PQ_SourceData_Portfolios.xlsx): `PQ_SourceData_Portfolios.xlsx`