Bolt Bikes Retails Sales Performance Analysis

🟣 OVERVIEW

The dataset used in this project originates from a multi-store bike retail company and captures detailed sales transactions and operational data spanning from 2016 to 2018

It comprises several interrelated tables that provide a comprehensive view of the company's sales activities, customer base, workforce, and product performance. The database contained essentially of 7 key tables used in the analysis.

Time Scope: 2016-2018

This Project does not include:

Any region asides those stated (New York, Texas, California).

Any data older than 2016 and later than 2018.

🟣 PROBLEM STATEMENT

The business lacks a clear understanding of the key factors driving sales performance across its stores, staff, customers, and product lines. This project uses historical retail data to uncover insights into revenue distribution, top-performing products and staff, customer spending behavior, helping the business make more informed, data-driven operational and strategic decisions.

🟣 OBJECTIVES

• To assess sales results across brands, products, and locations to pinpoint high-revenue drivers and improve store and inventory management.
• To examine regional sales patterns and consumer spending patterns to improve customer engagement and target marketing.
• To evaluate employee performance in relation to income, promoting improved labour allocation, training, and recognition.