BIKE SALES

Interactive dashboard to pinpoint trends

PROJECT URL

GitHub

SKILL

Data Modeling

TOOL

Excel

YEAR

2023

Project description

Project description

Project description

The goal of the project is to analyze raw bike sales data and provide insights into purchasing trends, customer preferences, and sales opportunities. The dashboard aimed to help stakeholders make data-driven decisions for targeted sales strategies.

Process

Process

Process

The project consists of gathering, cleaning and transforming raw sales data with advanced formulas to create meaningful insights through interactive Excel dashboard including key metrics such as customer demographics, purchase patterns, and commute distance.

Highlights

Highlights

Highlights

The product is an interactive user – friendly dashboard identifying data trends, customer demographics for more targeted sales, improved sales strategies and better target customer segments with;

·Advanced formulas and functions

·Slicers

·Timeline filters