Excel Financial Control Dashboard
Nenhuma descrição informada
Personal project created with fictional data to demonstrate Excel and data analysis skills. The dashboard tracks income, expenses, net balance, savings margin and monthly performance. It uses structured tables, SUMIFS, data validation, conditional formatting and charts.
Inventory and Sales Management Dashboard
Nenhuma descrição informada
Personal project created with fictional data to demonstrate inventory and sales analysis in Excel. The solution tracks products, stock entries, sales, current stock, restock alerts, revenue and gross profit using SKU, SUMIFS, VLOOKUP, data validation and charts.
Fleet and Field Operations Performance Dashboard
Nenhuma descrição informada
Personal project created with fictional data to demonstrate operational analysis in Excel. The dashboard monitors vehicles, routes, schedules, distance, duration, delays, efficiency and incidents. A business rule classifies delays only when the start exceeds 60 minutes.