How aranjan97/ediscovery-sql-analytics works
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.sql Relational Model · powerbi Power BI Model · migrations Case Hierarchy · ediscovery_analytics_dashboard.pbix Interactive Dashboard
Components 13
Data Foundation
- Seed Data
data/seed_data.sql - Relational Model
schema/schema.sql
SQL Reporting
- Case Hierarchy
migrations - Case Summary
migrations - Reviewer Performance
migrations - SLA Performance
migrations - Processing Performance
migrations - Analytical Queries
queries
Data Quality
- Quality Checks
validation/001_data_quality_checks.sql
Power BI
- Power BI Model
powerbi - DAX Measures
powerbi - Interactive Dashboard
powerbi/ediscovery_analytics_dashboard.pbix
Other components
- Analytics User
Connections 16
- Seed Data → Relational Model: loads into
README.md - Relational Model → Case Hierarchy: transforms into
README.md - Relational Model → Case Summary: aggregates into
README.md - Relational Model → Reviewer Performance: reports as
README.md - Relational Model → SLA Performance: reports as
README.md - Relational Model → Processing Performance: reports as
README.md - Relational Model → Analytical Queries: analyzed by
README.md - Relational Model → Quality Checks: checks
README.md - Case Hierarchy → Power BI Model: imported by
README.md - Case Summary → Power BI Model: imported by
README.md - Reviewer Performance → Power BI Model: imported by
README.md - SLA Performance → Power BI Model: imported by
README.md - Processing Performance → Power BI Model: imported by
README.md - Power BI Model → DAX Measures: measured by
README.md - DAX Measures → Interactive Dashboard: powers
README.md - Analytics User → Interactive Dashboard: explores
README.md