# krobin-aiml-agent/businessmodels-dashboards-and-projects architecture

> Architecture diagram of the GitHub repository krobin-aiml-agent/businessmodels-dashboards-and-projects, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-08-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/krobin-aiml-agent/businessmodels-dashboards-and-projects
- Repository: https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects

## Overview

#### Purpose and Operating Model
This is a portfolio repository of business decision-support artifacts rather than a deployable application. It groups spreadsheet models, BI workbooks, and written case studies that connect operational improvement, financial analysis, and reporting. The top-level entry point is `README.md`; domain-level navigation is provided by files such as `analytics-bi/README.md`, `ci-process-tools/README.md`, and `financial-modeling/README.md`.

#### BI and Dashboard Delivery
The BI area packages completed analytical dashboards for interactive consumption in vendor desktop tools. Tableau workbooks are the primary multi-dashboard format under `analytics-bi/Tableau/Dashboards/`, including `analytics-bi/Tableau/Dashboards/Customer & Sales Analytics.twbx` and `analytics-bi/Tableau/Dashboards/Order Analytics.twbx`. Power BI is represented by `analytics-bi/PowerBI/Employee Data BI Dashboard.pbix`, while Excel-based analysis is available in `analytics-bi/Excel/Call Center Data Analysis.xlsx`.

#### Tableau Storytelling Layer
Separate Tableau Story workbooks appear intended for narrative or guided analysis, distinct from standalone dashboards. This layer includes `analytics-bi/Tableau/Story/Sales Channel Mix.twbx` and `analytics-bi/Tableau/Story/SuperDrugs Prescription Analysis Tableau Dashboard.twbx`. A second Tableau artifact exists in the data-engineering project area: `Data Engineering Pipelne/Project Artifacts/Data Viz-Tableau/Sales by Market by Region (Tableau).twbx`.

#### Continuous-Improvement Toolkit
`ci-process-tools` provides operational diagnostics and improvement models, with Excel tools as the executable analysis boundary and Markdown case studies as interpretation/documentation. Core artifacts include `ci-process-tools/TOOLS/Business Process Modeling.xlsx`, `ci-process-tools/TOOLS/Statistical Tests.xlsx`, and `ci-process-tools/TOOLS/Theory of Constraints & Monte Carlo Simulation Probabilistic Modeling.xlsx`. Supporting business applications are described in `ci-process-tools/CASE STUDY/Business Process Modeling Toolkit.md` and related case-study files.

#### Financial Modeling Layer
Financial models are spreadsheet-centered and cover valuation, forecasting, ratios, scenario analysis, and operating finance. Principal models are located in `financial-modeling/Projects/Costco Forecasting & Valuation Project.xlsx`, `financial-modeling/Projects/Financial Modeling Toolkit.xlsx`, and `financial-modeling/Projects/Pro-Forma.xlsx`. Their intended methodologies and business framing are documented in matching materials under `financial-modeling/README/`.

#### Data Flow, Boundaries, and Runtime
The implied flow is source/business data → spreadsheet or model analysis → BI visualization/dashboard → executive or operational decision support. Files are self-contained desktop artifacts: `.xlsx` runs in Microsoft Excel, `.pbix` in Microsoft Power BI, and `.twbx` in Tableau. No application source code, orchestration runtime, database schema, SQL/ETL implementation, cloud infrastructure, API integration, or external service configuration is present in the supplied tree. Although `README.md` references supply-chain models and a data-engineering pipeline, the corresponding `scm-operations-models` directory and SQL/ETL artifacts are not present; the visible pipeline area contains project artifacts and Tableau output only.

Main entry points: [`README.md`](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/README.md) (Portfolio entry point), [`analytics-bi/README.md`](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/README.md) (BI navigation), [`analytics-bi/Tableau/Dashboards/Customer & Sales Analytics.twbx`](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Tableau/Dashboards/Customer%20%26%20Sales%20Analytics.twbx) (Tableau dashboards), [`ci-process-tools/TOOLS/Business Process Modeling.xlsx`](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/TOOLS/Business%20Process%20Modeling.xlsx) (Business process modeling)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_bi["BI Delivery"]
  node_bi_readme["BI navigation<br/>documentation<br/>[README.md]"]
  node_tableau_dashboards["Tableau dashboards<br/>Tableau workbooks"]
  node_order_dashboard["Order analytics<br/>Tableau workbook"]
  node_powerbi_dashboard["Employee BI dashboard<br/>Power BI workbook"]
  node_excel_call_center["Call center analysis<br/>Excel workbook"]
  node_tableau_stories["Tableau stories<br/>Tableau workbooks"]
  node_prescription_story["Prescription story<br/>Tableau workbook"]
  node_pipeline_tableau["Sales by market and region<br/>Tableau output"]
end

subgraph group_ci["Continuous Improvement"]
  node_ci_readme["CI toolkit navigation<br/>documentation<br/>[README.md]"]
  node_process_modeling["Business process modeling<br/>Excel tool"]
  node_statistical_tests["Statistical tests<br/>Excel tool"]
  node_constraints_simulation["Constraints and simulation<br/>Excel tool"]
  node_ci_case_study["Process modeling case study"]
end

subgraph group_finance["Financial Modeling"]
  node_finance_readme["Finance methodology<br/>documentation"]
  node_costco_valuation["Costco forecasting and valuation<br/>Excel model"]
  node_financial_toolkit["Financial modeling toolkit<br/>Excel model"]
  node_pro_forma["Pro forma model<br/>Excel model<br/>[Pro-Forma.xlsx]"]
end

node_root_readme["Portfolio entry point<br/>navigation<br/>[README.md]"]
node_business_data["Source business data<br/>input boundary"]
node_decision_support(("Decision support<br/>outcome"))

node_root_readme -->|"links to"| node_bi_readme
node_root_readme -->|"links to"| node_ci_readme
node_root_readme -->|"links to"| node_finance_readme
node_business_data -->|"analyzed in"| node_excel_call_center
node_business_data -->|"modeled in"| node_process_modeling
node_business_data -->|"forecast in"| node_costco_valuation
node_business_data -.->|"visualized in"| node_tableau_dashboards
node_bi_readme -->|"indexes"| node_tableau_dashboards
node_bi_readme -->|"indexes"| node_tableau_stories
node_tableau_dashboards -->|"informs"| node_decision_support
node_order_dashboard -->|"informs"| node_decision_support
node_powerbi_dashboard -->|"informs"| node_decision_support
node_excel_call_center -->|"informs"| node_decision_support
node_tableau_stories -->|"guides"| node_decision_support
node_prescription_story -->|"guides"| node_decision_support
node_pipeline_tableau -->|"visualizes"| node_decision_support
node_ci_readme -->|"indexes"| node_process_modeling
node_process_modeling -->|"documented by"| node_ci_case_study
node_statistical_tests -->|"informs"| node_decision_support
node_constraints_simulation -->|"informs"| node_decision_support
node_finance_readme -->|"documents"| node_costco_valuation
node_finance_readme -->|"documents"| node_financial_toolkit
node_finance_readme -->|"documents"| node_pro_forma
node_costco_valuation -->|"supports"| node_decision_support
node_financial_toolkit -->|"supports"| node_decision_support
node_pro_forma -->|"supports"| node_decision_support

click node_root_readme "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/README.md"
click node_bi_readme "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/README.md"
click node_tableau_dashboards "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Tableau/Dashboards/Customer%20%26%20Sales%20Analytics.twbx"
click node_order_dashboard "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Tableau/Dashboards/Order%20Analytics.twbx"
click node_powerbi_dashboard "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/PowerBI/Employee%20Data%20BI%20Dashboard.pbix"
click node_excel_call_center "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Excel/Call%20Center%20Data%20Analysis.xlsx"
click node_tableau_stories "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Tableau/Story/Sales%20Channel%20Mix.twbx"
click node_prescription_story "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Tableau/Story/SuperDrugs%20Prescription%20Analysis%20Tableau%20Dashboard.twbx"
click node_pipeline_tableau "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/Data%20Engineering%20Pipelne/Project%20Artifacts/Data%20Viz-Tableau/Sales%20by%20Market%20by%20Region%20(Tableau).twbx"
click node_ci_readme "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/README.md"
click node_process_modeling "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/TOOLS/Business%20Process%20Modeling.xlsx"
click node_statistical_tests "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/TOOLS/Statistical%20Tests.xlsx"
click node_constraints_simulation "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/TOOLS/Theory%20of%20Constraints%20%26%20Monte%20Carlo%20Simulation%20Probabilistic%20Modeling.xlsx"
click node_ci_case_study "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/CASE%20STUDY/Business%20Process%20Modeling%20Toolkit.md"
click node_costco_valuation "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/financial-modeling/Projects/Costco%20Forecasting%20%26%20Valuation%20Project.xlsx"
click node_financial_toolkit "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/financial-modeling/Projects/Financial%20Modeling%20Toolkit.xlsx"
click node_pro_forma "https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/financial-modeling/Projects/Pro-Forma.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_bi_readme,node_tableau_dashboards,node_order_dashboard,node_powerbi_dashboard,node_excel_call_center,node_tableau_stories,node_prescription_story,node_pipeline_tableau toneBlue
class node_ci_readme,node_process_modeling,node_statistical_tests,node_constraints_simulation,node_ci_case_study toneAmber
class node_finance_readme,node_costco_valuation,node_financial_toolkit,node_pro_forma toneMint
class node_root_readme,node_business_data,node_decision_support toneNeutral
```

## Components

### BI Delivery

Desktop dashboard and storytelling artifacts.

- [BI navigation](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/README.md): documentation · `analytics-bi/README.md`
- [Tableau dashboards](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Tableau/Dashboards/Customer%20%26%20Sales%20Analytics.twbx): Tableau workbooks · Interactive multi-dashboard analysis. · `analytics-bi/Tableau/Dashboards/Customer & Sales Analytics.twbx`
- [Order analytics](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Tableau/Dashboards/Order%20Analytics.twbx): Tableau workbook · `analytics-bi/Tableau/Dashboards/Order Analytics.twbx`
- [Employee BI dashboard](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/PowerBI/Employee%20Data%20BI%20Dashboard.pbix): Power BI workbook · `analytics-bi/PowerBI/Employee Data BI Dashboard.pbix`
- [Call center analysis](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Excel/Call%20Center%20Data%20Analysis.xlsx): Excel workbook · `analytics-bi/Excel/Call Center Data Analysis.xlsx`
- [Tableau stories](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Tableau/Story/Sales%20Channel%20Mix.twbx): Tableau workbooks · Guided narrative analysis. · `analytics-bi/Tableau/Story/Sales Channel Mix.twbx`
- [Prescription story](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/analytics-bi/Tableau/Story/SuperDrugs%20Prescription%20Analysis%20Tableau%20Dashboard.twbx): Tableau workbook · `analytics-bi/Tableau/Story/SuperDrugs Prescription Analysis Tableau Dashboard.twbx`
- [Sales by market and region](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/Data%20Engineering%20Pipelne/Project%20Artifacts/Data%20Viz-Tableau/Sales%20by%20Market%20by%20Region%20(Tableau).twbx): Tableau output · Visible data-engineering project artifact. · `Data Engineering Pipelne/Project Artifacts/Data Viz-Tableau/Sales by Market by Region (Tableau).twbx`

### Continuous Improvement

Operational diagnostic and simulation tools.

- [CI toolkit navigation](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/README.md): documentation · `ci-process-tools/README.md`
- [Business process modeling](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/TOOLS/Business%20Process%20Modeling.xlsx): Excel tool · `ci-process-tools/TOOLS/Business Process Modeling.xlsx`
- [Statistical tests](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/TOOLS/Statistical%20Tests.xlsx): Excel tool · `ci-process-tools/TOOLS/Statistical Tests.xlsx`
- [Constraints and simulation](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/TOOLS/Theory%20of%20Constraints%20%26%20Monte%20Carlo%20Simulation%20Probabilistic%20Modeling.xlsx): Excel tool · `ci-process-tools/TOOLS/Theory of Constraints & Monte Carlo Simulation Probabilistic Modeling.xlsx`
- [Process modeling case study](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/ci-process-tools/CASE%20STUDY/Business%20Process%20Modeling%20Toolkit.md): case study · Interprets toolkit application. · `ci-process-tools/CASE STUDY/Business Process Modeling Toolkit.md`

### Financial Modeling

Forecasting, valuation, and planning models.

- **Finance methodology**: documentation · Business framing and model methodologies.
- [Costco forecasting and valuation](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/financial-modeling/Projects/Costco%20Forecasting%20%26%20Valuation%20Project.xlsx): Excel model · `financial-modeling/Projects/Costco Forecasting & Valuation Project.xlsx`
- [Financial modeling toolkit](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/financial-modeling/Projects/Financial%20Modeling%20Toolkit.xlsx): Excel model · `financial-modeling/Projects/Financial Modeling Toolkit.xlsx`
- [Pro forma model](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/financial-modeling/Projects/Pro-Forma.xlsx): Excel model · `financial-modeling/Projects/Pro-Forma.xlsx`

### Other components

- [Portfolio entry point](https://github.com/krobin-aiml-agent/businessmodels-dashboards-and-projects/blob/main/README.md): navigation · Top-level repository guide. · `README.md`
- **Source business data**: input boundary · Implied operational and financial inputs.
- **Decision support**: outcome · Executive and operational decisions informed by the artifacts.

## Connections

- Portfolio entry point → BI navigation: links to
- Portfolio entry point → CI toolkit navigation: links to
- Portfolio entry point → Finance methodology: links to
- Source business data → Call center analysis: analyzed in
- Source business data → Business process modeling: modeled in
- Source business data → Costco forecasting and valuation: forecast in
- Source business data → Tableau dashboards: visualized in
- BI navigation → Tableau dashboards: indexes
- BI navigation → Tableau stories: indexes
- Tableau dashboards → Decision support: informs
- Order analytics → Decision support: informs
- Employee BI dashboard → Decision support: informs
- Call center analysis → Decision support: informs
- Tableau stories → Decision support: guides
- Prescription story → Decision support: guides
- Sales by market and region → Decision support: visualizes
- CI toolkit navigation → Business process modeling: indexes
- Business process modeling → Process modeling case study: documented by
- Statistical tests → Decision support: informs
- Constraints and simulation → Decision support: informs
- Finance methodology → Costco forecasting and valuation: documents
- Finance methodology → Financial modeling toolkit: documents
- Finance methodology → Pro forma model: documents
- Costco forecasting and valuation → Decision support: supports
- Financial modeling toolkit → Decision support: supports
- Pro forma model → Decision support: supports