CASE STUDY
SalesLens
Real-Time Analytics Dashboard
PythonREST APIsMySQLAWSReactRBAC
The Problem
Sales teams needed real-time visibility into call analytics, agent performance, and pipeline metrics. Existing solutions were slow, lacked granular access control, and couldn't handle the complex SQL queries needed for multi-dimensional analytics across large datasets.
The challenge was building a backend that could serve real-time dashboards with sub-second query performance, while enforcing role-based access control (RBAC) so different team levels only saw their authorized data.
System Architecture
React Dashboard
REST API
RBAC Layer
MySQL
My Contributions
SQL & Data Engineering
- Optimized complex SQL queries for multi-dimensional analytics
- Reduced query execution time for real-time dashboard performance
- Designed database schema for scalable analytics storage
Security & Access Control
- Implemented role-based access control (RBAC) at API level
- Built secure authentication and authorization middleware
- Ensured data isolation between different organizational levels
Backend API Development
- Built RESTful API endpoints serving the React dashboard
- Designed pagination, filtering, and aggregation APIs
- Deployed on AWS with Docker and Nginx
Key Metrics
0
Data Points Validated
0
RBAC Coverage
0
Access Roles
Tech Stack Deep Dive
Python
Backend services and data processing pipelines
MySQL
Optimized queries for complex analytics aggregations
React
Frontend dashboard with interactive charts and real-time data
AWS
EC2 for compute, S3 for storage, RDS for managed database