Case Study • Embedded BI • AWS Native Analytics

AWS BI Reporting System

View Details on GitHub

Executive Summary

Key Metrics

30+
Interactive Reports
~3s
Avg Response Time
2,000+
Schools Supported
~90%
Session Cost Reduction

System Architecture

BI delivery pipeline with secure URL generation and cost-aware rendering.

Angular ASP.NET Core AWS Lambda QuickSight RDS / DynamoDB / S3
Angular Embedded Report UI .NET API Auth · Orchestration AWS Lambda Secure Embed API Snapshot Flow S3 · Headless Render Amazon QuickSight Embedded BI Engine Data Platform RDS · DynamoDB · SPICE Secure Embed + Snapshot-Oriented Delivery

System Scale

Data Volume
Usage & Traffic
User Scope

Report Categories

Attendance & Access Management

Health & Incident Monitoring

District & School-Level Summary

Data Platform & Modeling Strategy

Database-Centric Analytics Logic

Lightweight BI Layer

OLTP → Analytics Separation

Performance Optimization

District-Level Heavy Report Optimization

SPICE for Non-Realtime Reports

Database-Level Query Tuning

Embedded Reporting & Multi-Tenant Design

Cost Optimization Strategy

Technology Stack

Frontend
Angular
Backend
ASP.NET Core C# Lambda
Data & BI
QuickSight RDS MySQL DynamoDB SPICE
Pipeline & Ops
S3 SQS Step Functions EC2 Azure DevOps

Impact

Cost

Performance

Scale

Architecture