This outlines the codebase of our submission for Goldmans Sachs Engineering Engage 2021 Hackathon
Table of Contents
To design a system that streamlines the report generation process by having a highly customizable, scalable, intuitive and automated report rendering solution.
Setting up a project
File and sheets naming
Drag and drop capabilities for organising tables on a sheet
Selecting columns for each respective table
Output Excel Report
Measured on a t2-medium AWS EC2 instance (4gb RAM, 30gb Memory)
| Small Report (10 Rows x 1 Column) | Medium Report (5 Rows x 5 Columns) | Large Report (10 Rows x 10 Columns) | |
|---|---|---|---|
| 10 Concurrent Reports | 0.85s | 38.72s | 137s |
| 1000 Concurrent Reports | 14.03s | 173s | 13mins |
- Concurrent load scales well with small-sized, single sheet reports
- Considerable load scalability with medium-sized reports