New Excel Data Analytics Dashboard



New Excel Data Analytics Dashboard bike_sales_2021.xlsx, best to be opened with Microsoft 365 or WPS as it may lose some features when opened with google drive.

this .xlsx file was mainly received during Cisco Network Academy online training for data analytics

1- First worksheet is for the raw data


2- Second Worksheet for the data after being cleaned


3- the rest of worksheets are simply dashboard tabs show and visualize sales by revenue, order quantity, bike model and customer age groups through 1st to 4th 2021 quarters 


The worksheet consists of Pivot Table, Pivot Chart and Slicer to assist filtering the data