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