Skip to content

Awande07/Excel-Sales-Performance-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 

Repository files navigation

Excel-Sales-Performance-Dashboard

Project Objectives

To analyze a company's sales data and create an interactive dashboard that provides insights into sales trends, top-performing products, and regional performance.

Steps Performed

  1. Data Import and Cleaning
  2. Data Analysis with PivotTables
  3. Created Summary using Formulas (SUMIFS, COUNTIFS)
  4. Built an Interactive Dashboard with Charts

How to Use

The dashboard is interactive. Open the Raw Data sheet and use Data > Filter > Standard Filter to view data for specific regions, categories, or dates. The charts on the Dashboard sheet will update automatically.

Screenshots

Screenshot (63) Screenshot (62)Screenshot (64) Screenshot (65) Screenshot (66) [SuperStoreOrders.csv](https://github.com/user-attachments/files/23885409/SuperStoreOrders.csv) Screenshot (59) Screenshot (58) Screenshot (60) Screenshot (61) [SuperStoreOrders.ods](https://github.com/user-attachments/files/23885452/SuperStoreOrders.ods)

About

To analyze a company's sales data and create an interactive dashboard that provides insights into sales trends, top-performing, and regional performance.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors