Financial Account Analysis & Dashboard Design

Designed and analyzed a financial dashboard for a seafood restaurant account using Excel.

The work included:

Analyzing total income and expenses during a specific period

Creating interactive charts and visual reports for deposits and withdrawals

Tracking ATM cash withdrawals, transfer fees, and POS transactions

Comparing total inflows vs outflows with clear financial insights

Building a professional dashboard for easier financial monitoring and decision-making

Using Pivot Tables, Charts, and Excel data analysis tools to organize and visualize financial data

Tools Used:

Microsoft Excel

Pivot Tables

Financial Reporting & Data Analysis

Dashboard Design & Data Visualization