Hi, all. I needed a project to showcase my Excel skills for a potential job so I put this together. Thought I’d share for inspiration and to see if anyone has feedback. It’s my first dashboard of any kind, so any input would be appreciated. I’m not entirely thrilled with the data as there is little no information on where it comes from, it seems too consistent from month to month, and the profit % seems high to me. There’s also no actual sale amount, just list price, so I used that to calculate sales. Cleaning the dates was a pain since it was in dd-mm-yyyy format and some were converted to Excel serial and others weren’t, but I found a way to do it using Excel formulas. I could have done it in Python, but thought I’d try it in Excel for the challenge.
Data is from bicycle store dataset | Kaggle
I roughly followed this video for the dashboard. Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales - YouTube