Simple Excel Project on Data Cleaning and Dashboard Creation

By Gino Freud D. Hobayan

Bike Sales Dashboard

Excel Project Dataset from Alex the Analyst Youtube Channel

1. Data Cleaning

• Made a new sheet called "Working Sheet" so I can always come back to the original raw data

  (Just like creating a BACKUP Database on SQL)

• Checked and removed duplicates

• Find and replace some confusing data to make it clearer

• Created a new column called the 'Age Brackets' column (for easier visualization and to categorize the ages)

• Created Nested IF Statements on the 'Age Brackets' column

2. Pivot tables

To help build our data visualizations and dashboard.

Static Data Visualizations:

I also made a few static data visualizations so that we can derive more insights from our bike data.

3. Dashboard Creation (Using a Slicer)

I compiled all of the data visualizations and used a Slicer to make it interactive/dynamic and turned it into a Dashboard.

FINAL OUTPUT: