Skip to content

About

An AI-powered financial analytics platform built with ASP.NET Core and Angular that transforms uploaded datasets into interactive dashboards and AI-generated insights.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Repository files navigation

Unit Tests .NET Angular PostgreSQL Docker Git Hooks Nginx Clean Architecture GitHub Actions Groq AI License

πŸ“Š AI Analytics Platform

AI-powered Data Analytics System for processing financial Excel/CSV files, generating insights, and visualizing results through an interactive dashboard.


πŸš€ Overview

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.


🧱 System Architecture

Presentation Layer (ASP.NET Core API)
        β”‚
Application Layer (CQRS + Services + DTOs)
        β”‚
Domain Layer (Entities + Business Rules)
        β”‚
Infrastructure Layer (DB + External Services + File Processing)

πŸ“ Project Structure

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

πŸ–ΌοΈ Screenshots

Upload Excel file

Dashboard


Dashboard

Dashboard


Ainsights

Dashboard


πŸŽ₯ Demo

Coming Soon...

βš™οΈ Core Modules

πŸ“₯ 1. Data Ingestion Module

Purpose

Handles file upload and background processing of datasets.

Backend Components

  • DataBatch Entity β†’ tracks uploaded file state
  • IDataBatchRepository
  • UploadFileCommand
  • ProcessFileCommand
  • ExcelParserService
  • Background processing (Hangfire Job)

API Endpoints

POST /api/uploads/upload
GET  /api/uploads/status/{id}

Flow

Upload File β†’ Create Batch β†’ Background Parsing β†’ Store Financial Records β†’ Update Status

πŸ“Š 2. Analytics Module

Purpose

Transforms raw financial data into structured metrics and charts.

Domain

  • FinancialRecord

Application Layer

  • GetFinancialMetricsQuery
  • GetTrendDataQuery
  • GetCategoryDistributionQuery

DTOs

  • MetricCardDto
  • ChartDataDto

API Endpoints

GET /api/analytics/metrics
GET /api/analytics/charts

Output Types

  • KPI Cards
  • Line Chart (Trends)
  • Pie Chart (Distribution)

πŸ€– 3. AI Insights Module

Purpose

Generates AI-powered summaries per uploaded dataset batch.

Domain

  • BatchSummary

Application Layer

  • GenerateAiSummaryCommand
  • GetBatchSummaryQuery

Infrastructure

  • OpenAIService (API Wrapper)

API Endpoint

GET /api/analytics/ai-summary/{batchId}

Output

  • Natural language financial summary
  • Batch-level insights

πŸ–₯️ Frontend (Angular)

Pages

  • Upload File Page
  • Analytics Dashboard
  • AI Summary Page

Components

  • FileUploadComponent
  • StatsCardComponent
  • ChartWrapperComponent
  • AiSummaryCardComponent

Behavior Flow

Upload File β†’ Receive BatchId β†’ Polling Status β†’ Load Dashboard β†’ Render Charts β†’ Fetch AI Summary

🧠 Domain Model

Entities

  • DataBatch

    • FileName
    • Status
    • UploadDate
  • FinancialRecord

    • Parsed dataset rows
  • BatchSummary

    • AI-generated summary text

Enums

  • BatchStatusEnum
  • FinancialRecordsEnum

πŸ”„ Data Flow

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

🐳 Deployment

Docker Setup

  • ASP.NET Core API
  • Angular Frontend
  • Database (via Docker Compose)
docker-compose up --build

βš™οΈ Infrastructure

  • EF Core (Database Layer)
  • Hangfire (Background Jobs)
  • AutoMapper (DTO Mapping)
  • OpenAI API Integration
  • SQL Views (Analytics Optimization)

πŸ§ͺ Testing

  • AnalyticsTestProject included
  • CQRS unit testing (Data ingestion flow)

πŸš€ Key Design Decisions

  • 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

πŸ“Œ Future Improvements

  • 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

πŸ“„ License

MIT License


πŸ‘¨β€πŸ’» Author

Omar Emad

Software Engineer | Full Stack Development

LinkedIn

Online Resume

(https://omar-emad.vercel.app

About

An AI-powered financial analytics platform built with ASP.NET Core and Angular that transforms uploaded datasets into interactive dashboards and AI-generated insights.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Used by

Contributors

Languages