SpreadSheet Projects
1. SuperStore Sales Dashboard
Overview: Multipage Sales Dashboard presentation of a store sales report for three (3) product collections in various states in USA.
Excel Skills:
- Data Transformation and Cleaning
- Pivot Tables
- Excel Functions
- VBA Automations and Codes
Links:
- Excel File: SuperStore Sales Dashboard
- Github Repository: SuperStore Sales Project
References:
- Image by storyset on Freepik
- Kaggle Dataset
2. Supermarket Sales Dashboard
Overview: Sample Dashboard presentation of a supermarket sales report for three (3) city branches and six (6) product collections. Distribution of customer gender, payment, membership were also visualized.
Excel Skills:
- Data Transformation and Cleaning
- Pivot Tables
- Excel Functions
Links:
- Excel File: Supermarket Sales Dashboard
- Github Repository: Supermarket Sales Project
- Tableau Version: Supermarket Sales Project
References:
- Image by storyset on Freepik
- Kaggle Dataset