📌 Project Goal:
To create a real-time interactive dashboard for monitoring total sales, revenue, expenses, and net profit trends over the course of one year, enabling data-driven decisions across business units.
🛠Tools & Technologies:
Power BI (DAX, Power Query), Excel (data source), filters (year, weekdays, category), bar charts, line graphs, pie charts, and waterfall visualizations.
📈 Impact & Achievements:
- Automated the reporting of 6+ key KPIs: Total Sales, Transactions, Revenue, Profit, Expenses, and Previous Year Comparison
- Built time-based filters for dynamic drill-down analysis
- Visualized performance trends by month and department (e.g., Sales vs. Management)
- Created a clear overview of profit evolution via waterfall chart
- Saved significant time on manual reporting (estimated 60% improvement)
- Used by leadership to align marketing, sales, and finance strategies
File link(https://drive.google.com/file/d/1bPfo6GnLYnx0aeKsnNDk2jI8TciJ75TN/view?usp=drive_link)