AI-powered Data Analytics System for processing financial Excel/CSV files, generating insights, and visualizing results through an interactive dashboard.
AI Analytics Platform is a full-stack system designed to:
- Upload and process financial datasets (Excel / CSV)
- Parse and store structured financial records
- Generate analytics and KPIs
- Produce AI-generated summaries per dataset batch
- Visualize insights via an interactive dashboard
The system is built using Clean Architecture + CQRS + Background Processing.
Presentation Layer (ASP.NET Core API)
β
Application Layer (CQRS + Services + DTOs)
β
Domain Layer (Entities + Business Rules)
β
Infrastructure Layer (DB + External Services + File Processing)
AI_Analytics.sln
β
βββ Presentation
β βββ Controllers
β βββ Middleware
β βββ Program.cs
β
βββ Application
β βββ CQRS
β βββ DTOs
β βββ Contracts
β βββ AutoMapper
β
βββ Domain
β βββ Entities
β βββ Enums
β
βββ Infrastructure
β βββ Persistence (EF Core)
β βββ Services
β βββ Repositories
β βββ Migrations
β βββ Excel Parser
β
βββ Front (Angular)
β βββ Pages
β βββ Core
β βββ Shared
β βββ Services
β
βββ AnalyticsTestProject
βββ docker-compose.yml
Handles file upload and background processing of datasets.
DataBatchEntity β tracks uploaded file stateIDataBatchRepositoryUploadFileCommandProcessFileCommandExcelParserService- Background processing (Hangfire Job)
POST /api/uploads/upload
GET /api/uploads/status/{id}
Upload File β Create Batch β Background Parsing β Store Financial Records β Update Status
Transforms raw financial data into structured metrics and charts.
FinancialRecord
GetFinancialMetricsQueryGetTrendDataQueryGetCategoryDistributionQuery
MetricCardDtoChartDataDto
GET /api/analytics/metrics
GET /api/analytics/charts
- KPI Cards
- Line Chart (Trends)
- Pie Chart (Distribution)
Generates AI-powered summaries per uploaded dataset batch.
BatchSummary
GenerateAiSummaryCommandGetBatchSummaryQuery
OpenAIService(API Wrapper)
GET /api/analytics/ai-summary/{batchId}
- Natural language financial summary
- Batch-level insights
- Upload File Page
- Analytics Dashboard
- AI Summary Page
FileUploadComponentStatsCardComponentChartWrapperComponentAiSummaryCardComponent
Upload File β Receive BatchId β Polling Status β Load Dashboard β Render Charts β Fetch AI Summary
-
DataBatch- FileName
- Status
- UploadDate
-
FinancialRecord- Parsed dataset rows
-
BatchSummary- AI-generated summary text
BatchStatusEnumFinancialRecordsEnum
1. User uploads file (Excel/CSV)
2. API creates DataBatch
3. Background job parses file
4. FinancialRecords stored in DB
5. Analytics queries aggregate data
6. AI service generates summary
7. Frontend displays:
- KPIs
- Charts
- AI Insights
- ASP.NET Core API
- Angular Frontend
- Database (via Docker Compose)
docker-compose up --build- EF Core (Database Layer)
- Hangfire (Background Jobs)
- AutoMapper (DTO Mapping)
- OpenAI API Integration
- SQL Views (Analytics Optimization)
- AnalyticsTestProject included
- CQRS unit testing (Data ingestion flow)
- CQRS used for separation of reads/writes
- Background jobs for file processing
- Batch-based processing model
- Analytics optimized via SQL Views / aggregation layer
- Modular service contracts for scalability
- AI layer decoupled from analytics engine
- Real-time updates (SignalR)
- Advanced AI predictions
- Streaming ingestion pipeline
- Multi-tenant support
- Role-based authentication
- Export reports (PDF / Excel)
- Performance optimization with caching layer
MIT License
Omar Emad
Software Engineer | Full Stack Development
Online Resume


