<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' stroke='%23337EA9' fill='none' stroke-linecap='round' stroke-linejoin='round'%3e%3cpath stroke='none' d='M0 0h24v24H0z' fill='none'/%3e%3ccircle cx='12' cy='11' r='3'/%3e%3cpath d='M17.657 16.657 13.414 20.9a2 2 0 0 1-2.827 0l-4.244-4.243a8 8 0 1 1 11.314 0z'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24' stroke='%23337EA9' fill='none' stroke-linecap='round' stroke-linejoin='round'%3e%3cpath stroke='none' d='M0 0h24v24H0z' fill='none'/%3e%3ccircle cx='12' cy='11' r='3'/%3e%3cpath d='M17.657 16.657 13.414 20.9a2 2 0 0 1-2.827 0l-4.244-4.243a8 8 0 1 1 11.314 0z'/%3e%3c/svg%3e" width="40px" /> Navigation bar
</aside>
<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1.5' viewBox='0 0 24 24' fill='none' xmlns='http://www.w3.org/2000/svg'%3e%3cpath d='M5.13 3.008A2 2 0 0 1 6.866 2h10.268a2 2 0 0 1 1.736 1.008l1.143 2c.648 1.134.049 2.503-1.09 2.887.005.082.004.164-.002.247l-.857 12A2 2 0 0 1 16.069 22H7.93a2 2 0 0 1-1.995-1.858l-.857-12a2.023 2.023 0 0 1-.003-.247c-1.138-.384-1.737-1.753-1.09-2.887l1.144-2ZM7.074 8l.214 3h9.424l.214-3H7.074Zm.643 9 .214 3h8.138l.214-3H7.717Zm10.56-11-1.143-2H6.866L5.723 6h12.554Z' fill='%23337EA9'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1.5' viewBox='0 0 24 24' fill='none' xmlns='http://www.w3.org/2000/svg'%3e%3cpath d='M5.13 3.008A2 2 0 0 1 6.866 2h10.268a2 2 0 0 1 1.736 1.008l1.143 2c.648 1.134.049 2.503-1.09 2.887.005.082.004.164-.002.247l-.857 12A2 2 0 0 1 16.069 22H7.93a2 2 0 0 1-1.995-1.858l-.857-12a2.023 2.023 0 0 1-.003-.247c-1.138-.384-1.737-1.753-1.09-2.887l1.144-2ZM7.074 8l.214 3h9.424l.214-3H7.074Zm.643 9 .214 3h8.138l.214-3H7.717Zm10.56-11-1.143-2H6.866L5.723 6h12.554Z' fill='%23337EA9'/%3e%3c/svg%3e" width="40px" /> Summary
Goal
Build an interactive Microsoft Excel dashboard allowing users to monitor sales performance for 5 products in 2 years across 100 stores in 10 Western European countries.
Process
This project involves end to end data analysis in Excel, from mock data creation, to data cleaning and transformation, all the way to creating actionable insights in the form of visualizations and dashboarding.
Highlights
The end result is an interactive dashboard with
<aside> <img src="/icons/computer-chip_blue.svg" alt="/icons/computer-chip_blue.svg" width="40px" /> Track GPU sales over time
</aside>
<aside> <img src="/icons/trophy_blue.svg" alt="/icons/trophy_blue.svg" width="40px" /> Track sales by store location and identify best- and worst-performing stores
</aside>
<aside> <img src="/icons/computer_blue.svg" alt="/icons/computer_blue.svg" width="40px" /> The customized slicers give you more control on the country and product details you want to see
</aside>