DASHBOARD WITH LIVE UPDATES

Databases & SQL
Payment Issue Dashboard

The project involved analyzing and working with customer data in a telecommunications system. The dashboard allows for filtering and monitoring payment statuses, identifying issues, and analyzing user data.

Scope of work:
- analysis of customer data (payment statuses, tariffs, operators)
- working with large datasets (Excel / SQL)
- data validation
- identification of errors and inconsistencies
- system functionality testing (manual QA)
- collaboration with the IT team

Tools used:
- Excel
- SQL
- internal systems (dashboards)

Outcome:
- improved analysis of payment issues
- better control over customer statuses
- faster detection of data errors