💸 Automating Cash Flow Reports for Exporting Companies
I’m currently developing an automated cash flow reporting system connected to a PostgreSQL database. It automatically pulls and analyzes financial data to provide real-time insights into income, expenses, payments, and debts.
Project: Sales Overview Dashboard
Description:
Designed an interactive Power BI dashboard to track sales, profit, and performance by product and region.
✅ Built KPIs to summarize key metrics
✅ Created trend and product insights with visual storytelling
Tools: Power BI | Data Modeling | DAX | Data Visualization
📊 Staffing Spend Analysis by Business Unit
Developed an Excel model to analyze staffing expenses across business units.
✅ Broke down total spend by department and category
✅ Identified cost trends and optimization opportunities
Tools: Excel | Data Modeling | Cost Analysis
Project Title:
Sales data analysis
Built an Excel dashboard to compare product performance across 2013–2014.
✅ Identified top and low performers using profit data
✅ Highlighted trends in sales, COGS, and profitability
Tools: Excel | Pivot Tables | Data Analysis
💼 Project Title:
Quick Excel Analysis for Fast Business Insight
🧾 Description:
Completed a fast-turnaround Excel data analysis to have a quick understand key trends in operational data.
🔍 Key Features:
Data cleaning and validation
Summary tables
Pivot tables with filters for...
