Skip to content

Building one dashboard every week to sharpen my skills and share what I learn.

Notifications You must be signed in to change notification settings

Sushma-66/Dashboards-using-Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 

Repository files navigation

I recently built an interactive Sales & Profit Dashboard using Excel. The goal was to analyze business performance and provide clear insights into: ✅ Revenue trends over time ✅ Top-performing regions & products ✅ Customer contribution to total sales ✅ Profitability analysis 🔧 Tools & Features Used:

  1. Excel PivotTables & PivotCharts
  2. Slicers for interactivity
  3. Conditional formatting for quick KPIs
  4. Data cleaning & structuring for analysis 💡 Key Takeaway: A well-designed dashboard transforms raw data into a story that decision-makers can act on. This project reinforced my skills in data cleaning, analysis, and visualization—core aspects of a Business Analyst role.

https://github.com/Sushma-66/Dashboards-using-Excel/blob/main/Sales%20Performance%20Dashboard.jpg

About

Building one dashboard every week to sharpen my skills and share what I learn.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages