# UMDAC---Datathon
[LiveDemo](https://youtu.be/c-x8oy6jw2Q)

## Overview 
This project addresses a cash flow forecasting and monitoring challenge for a multi-entity, multi-currency business operating across regions. 

Due to varying billing cycles, customer payment behavior, and routine vendor payments, cash inflows and outflows fluctuate over time. This makes short-term liquidity visibility critical for finance teams.

Thus, the objective is to provide reliable short-term cash flow forecasts, ending cash balance visibility, and early detection of irregular transactions through data analysis, forecasting models, by using an interactive dashboard.

## Objective
- Analyze historical cash inflows and outflows across legal entities and categories
- Visualize weekly net cash flow and ending cash balances
- Forecast weekly net cash flow and cash balance up to 6 months ahead
- Compare forecasted vs actual cash flows and evaluate model accuracy
- Detect anomalous cash flow activities that may require business review
- Translate analytical results into actionable insights for finance stakeholders

## Key Analysis Components
- Data Preparation
  - Data cleaning, currency standardization, and weekly aggregation
- Exploratory Analysis
  - Cash inflow vs outflow trends
  - Category-level cash flow patterns
- Forecasting
  - Weekly cash flow forecasting (short-term and 6-month horizon)
  - Model comparison and performance evaluation
- Anomaly Detection
  - Identification of unusual spikes, drops, or duplicate transactions
- Dashboard & Storytelling
  - Interactive visuals to support monitoring, investigation, and decision-making
 
## Tools
- Power BI (data cleaning, transforming, and dashboard)

## Sample Dashboard
<img width="2000" height="1156" alt="image" src="https://github.com/user-attachments/assets/b4271a64-7949-4926-adde-791234a2bb3b" />
<img width="2000" height="1156" alt="image" src="https://github.com/user-attachments/assets/f3176dd3-aed8-412b-a8a5-208d0d94de23" />
<img width="2000" height="1156" alt="image" src="https://github.com/user-attachments/assets/2eb6aae9-3974-497e-aab7-379ae86e12ab" />
<img width="2000" height="1156" alt="image" src="https://github.com/user-attachments/assets/00bb4773-bd38-4760-b285-d981d7a792eb" />

## Pitch Deck
PitchDeck - [PitchDeck](https://drive.google.com/file/d/1wtgwvdg__GBlYYSswjjAo7hHVhucwQGF/view?usp=sharing)

## Recources
Dataset   - [Dataset](https://docs.google.com/spreadsheets/d/1-P_QiYc6XGUexUKSDOcAQIWLWEOIfrJD/edit?usp=sharing&ouid=105983344459134937328&rtpof=true&sd=true)