Bike Sales Analysis

This repository contains the files for creating the Bike Sales Dashboard using Excel.
In this project, we will complete the following tasks:

1. Clean the raw data in Excel (remove duplicates, standardize data using nested IF(), etc.).
2. Explore the dataset using Pivot Tables.
3. Create a data analytics dashboard with slicers.

About the Dataset

The dataset BikeSales_Raw.xlsx contains 1000 records about bike buyers. Each record represents a customer (customer ID, gender, marital status, income, commute distance, etc).

Source: Excel Project Dataset.xlsx published by Alex the Analyst

Technologies

File Contents

• Access the raw data: BikeSales_Raw.xlsx

• Access the Excel Workbook: BikeSales_Analysis.xlsx

  • View the raw dataset under the tab bike_buyers
  • View the cleaned dataset under the tab Working Sheet
  • View the dashboard under the tab Dashboard

• View my static dashboard: BikeSalesDashboard.png

• View my interactive dashboard on Google Sheets: Here