# aranjan97/ediscovery-sql-analytics architecture

> Architecture diagram of the GitHub repository aranjan97/ediscovery-sql-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-30). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/aranjan97/ediscovery-sql-analytics
- Repository: https://github.com/aranjan97/ediscovery-sql-analytics

## Overview

This repository is an eDiscovery analytics solution: seed data and a relational model support SQL reporting views, data-quality checks, and a Power BI dashboard. The documented user workflow is to explore case, reviewer, SLA, and processing metrics in the dashboard. The README documents these stages and the dashboard’s major capabilities; no source excerpts were provided, so relationships below rely on those documented statements rather than inspected SQL implementations.

Main entry points: [`schema/schema.sql`](https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/schema/schema.sql) (Relational Model), [`powerbi`](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/powerbi) (Power BI Model), [`migrations`](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations) (Case Hierarchy), [`powerbi/ediscovery_analytics_dashboard.pbix`](https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/powerbi/ediscovery_analytics_dashboard.pbix) (Interactive Dashboard)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data Foundation"]
  node_seed["Seed Data<br/>[seed_data.sql]"]
  node_model["Relational Model<br/>[schema.sql]"]
end

subgraph group_reporting["SQL Reporting"]
  node_case_hierarchy["Case Hierarchy"]
  node_case_summary["Case Summary"]
  node_reviewer_performance["Reviewer Performance"]
  node_sla_performance["SLA Performance"]
  node_processing_performance["Processing Performance"]
  node_practice_queries["Analytical Queries"]
end

subgraph group_quality["Data Quality"]
  node_validation["Quality Checks"]
end

subgraph group_bi["Power BI"]
  node_powerbi_model["Power BI Model"]
  node_dax["DAX Measures"]
  node_dashboard["Interactive Dashboard"]
end

node_analyst(("Analytics User"))

node_seed -->|"loads into"| node_model
node_model -->|"transforms into"| node_case_hierarchy
node_model -->|"aggregates into"| node_case_summary
node_model -->|"reports as"| node_reviewer_performance
node_model -->|"reports as"| node_sla_performance
node_model -->|"reports as"| node_processing_performance
node_model -->|"analyzed by"| node_practice_queries
node_model -->|"checks"| node_validation
node_case_hierarchy -->|"imported by"| node_powerbi_model
node_case_summary -->|"imported by"| node_powerbi_model
node_reviewer_performance -->|"imported by"| node_powerbi_model
node_sla_performance -->|"imported by"| node_powerbi_model
node_processing_performance -->|"imported by"| node_powerbi_model
node_powerbi_model -->|"measured by"| node_dax
node_dax -->|"powers"| node_dashboard
node_analyst -->|"explores"| node_dashboard

click node_seed "https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/data/seed_data.sql"
click node_model "https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/schema/schema.sql"
click node_case_hierarchy "https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations"
click node_case_summary "https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations"
click node_reviewer_performance "https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations"
click node_sla_performance "https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations"
click node_processing_performance "https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations"
click node_practice_queries "https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/queries"
click node_validation "https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/validation/001_data_quality_checks.sql"
click node_powerbi_model "https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/powerbi"
click node_dax "https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/powerbi"
click node_dashboard "https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/powerbi/ediscovery_analytics_dashboard.pbix"

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_seed,node_model,node_analyst toneBlue
class node_case_hierarchy,node_case_summary,node_reviewer_performance,node_sla_performance,node_processing_performance,node_practice_queries toneAmber
class node_validation toneMint
class node_powerbi_model,node_dax,node_dashboard toneRose
```

## Components

### Data Foundation

- [Seed Data](https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/data/seed_data.sql): `data/seed_data.sql`
- [Relational Model](https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/schema/schema.sql): `schema/schema.sql`

### SQL Reporting

- [Case Hierarchy](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations): `migrations`
- [Case Summary](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations): `migrations`
- [Reviewer Performance](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations): `migrations`
- [SLA Performance](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations): `migrations`
- [Processing Performance](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/migrations): `migrations`
- [Analytical Queries](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/queries): `queries`

### Data Quality

- [Quality Checks](https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/validation/001_data_quality_checks.sql): `validation/001_data_quality_checks.sql`

### Power BI

- [Power BI Model](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/powerbi): `powerbi`
- [DAX Measures](https://github.com/aranjan97/ediscovery-sql-analytics/tree/main/powerbi): `powerbi`
- [Interactive Dashboard](https://github.com/aranjan97/ediscovery-sql-analytics/blob/main/powerbi/ediscovery_analytics_dashboard.pbix): `powerbi/ediscovery_analytics_dashboard.pbix`

### Other components

- **Analytics User**

## Connections

- Seed Data → Relational Model: loads into (evidence: `README.md`)
- Relational Model → Case Hierarchy: transforms into (evidence: `README.md`)
- Relational Model → Case Summary: aggregates into (evidence: `README.md`)
- Relational Model → Reviewer Performance: reports as (evidence: `README.md`)
- Relational Model → SLA Performance: reports as (evidence: `README.md`)
- Relational Model → Processing Performance: reports as (evidence: `README.md`)
- Relational Model → Analytical Queries: analyzed by (evidence: `README.md`)
- Relational Model → Quality Checks: checks (evidence: `README.md`)
- Case Hierarchy → Power BI Model: imported by (evidence: `README.md`)
- Case Summary → Power BI Model: imported by (evidence: `README.md`)
- Reviewer Performance → Power BI Model: imported by (evidence: `README.md`)
- SLA Performance → Power BI Model: imported by (evidence: `README.md`)
- Processing Performance → Power BI Model: imported by (evidence: `README.md`)
- Power BI Model → DAX Measures: measured by (evidence: `README.md`)
- DAX Measures → Interactive Dashboard: powers (evidence: `README.md`)
- Analytics User → Interactive Dashboard: explores (evidence: `README.md`)