<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="/icons/arrow-northeast_blue.svg" alt="/icons/arrow-northeast_blue.svg" width="40px" /> Click here to download the original dashboard.
</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
The project intent is to build an interactive Excel dashboard to allow the users to quickly identify sales trends and loyal customers across product categories.
Process
This project involves end to end data analysis in Excel, from data gathering, to data cleaning and transformation, all the way to creating actionable insights in the form of a dashboard.
Highlights
The end result is an interactive, dynamic dashboard with
<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-8jlncsd3qchtng9dz9r9tq-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpolygon class='cls-8jlncsd3qchtng9dz9r9tq-1' points='18.68 7.23 18.09 12 17.49 16.77 16.77 22.5 7.23 22.5 6.51 16.77 5.92 12 5.32 7.23 18.68 7.23'/%3e%3cline class='cls-8jlncsd3qchtng9dz9r9tq-1' x1='3.41' y1='7.23' x2='20.59' y2='7.23'/%3e%3cpolygon class='cls-8jlncsd3qchtng9dz9r9tq-1' points='15.82 1.5 8.18 1.5 5.32 4.36 5.32 7.23 18.68 7.23 18.68 4.36 15.82 1.5'/%3e%3cpath class='cls-8jlncsd3qchtng9dz9r9tq-1' d='M14.39 14.39a2.41 2.41 0 1 1-.73-1.71 2.36 2.36 0 0 1 .73 1.71Z'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-8jlncsd3qchtng9dz9r9tq-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpolygon class='cls-8jlncsd3qchtng9dz9r9tq-1' points='18.68 7.23 18.09 12 17.49 16.77 16.77 22.5 7.23 22.5 6.51 16.77 5.92 12 5.32 7.23 18.68 7.23'/%3e%3cline class='cls-8jlncsd3qchtng9dz9r9tq-1' x1='3.41' y1='7.23' x2='20.59' y2='7.23'/%3e%3cpolygon class='cls-8jlncsd3qchtng9dz9r9tq-1' points='15.82 1.5 8.18 1.5 5.32 4.36 5.32 7.23 18.68 7.23 18.68 4.36 15.82 1.5'/%3e%3cpath class='cls-8jlncsd3qchtng9dz9r9tq-1' d='M14.39 14.39a2.41 2.41 0 1 1-.73-1.71 2.36 2.36 0 0 1 .73 1.71Z'/%3e%3c/svg%3e" width="40px" /> Track total boutique sales over time for 2016.
</aside>
<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-ajdgn9sa51uhea80c56dx7-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpath class='cls-ajdgn9sa51uhea80c56dx7-1' d='M1.48 8.18H15.8v7.24a7.08 7.08 0 0 1-7.08 7.08h-.16a7.08 7.08 0 0 1-7.08-7.08V8.18Z'/%3e%3cellipse class='cls-ajdgn9sa51uhea80c56dx7-1' cx='19.14' cy='12.88' rx='3.34' ry='3.42'/%3e%3cline class='cls-ajdgn9sa51uhea80c56dx7-1' x1='0.52' y1='22.5' x2='16.75' y2='22.5'/%3e%3cpath class='cls-ajdgn9sa51uhea80c56dx7-1' d='M3.39 1.5c1.65 1.91-.7 2.86.95 4.77'/%3e%3cpath class='cls-ajdgn9sa51uhea80c56dx7-1' d='M8.16 1.5c1.65 1.91-.7 2.86.95 4.77'/%3e%3cpath class='cls-ajdgn9sa51uhea80c56dx7-1' d='M12.93 1.5c1.66 1.91-.7 2.86 1 4.77'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-ajdgn9sa51uhea80c56dx7-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpath class='cls-ajdgn9sa51uhea80c56dx7-1' d='M1.48 8.18H15.8v7.24a7.08 7.08 0 0 1-7.08 7.08h-.16a7.08 7.08 0 0 1-7.08-7.08V8.18Z'/%3e%3cellipse class='cls-ajdgn9sa51uhea80c56dx7-1' cx='19.14' cy='12.88' rx='3.34' ry='3.42'/%3e%3cline class='cls-ajdgn9sa51uhea80c56dx7-1' x1='0.52' y1='22.5' x2='16.75' y2='22.5'/%3e%3cpath class='cls-ajdgn9sa51uhea80c56dx7-1' d='M3.39 1.5c1.65 1.91-.7 2.86.95 4.77'/%3e%3cpath class='cls-ajdgn9sa51uhea80c56dx7-1' d='M8.16 1.5c1.65 1.91-.7 2.86.95 4.77'/%3e%3cpath class='cls-ajdgn9sa51uhea80c56dx7-1' d='M12.93 1.5c1.66 1.91-.7 2.86 1 4.77'/%3e%3c/svg%3e" width="40px" /> Analyze 2016 sales by product type.
</aside>
<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-lfzn4c011hlne8kigt61m-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpath class='cls-lfzn4c011hlne8kigt61m-1' d='M14.86 1.5H5.32A3.82 3.82 0 0 0 1.5 5.32v1.91h13.36v11.45H1.5v3.82h21V5.32a3.82 3.82 0 0 0-3.82-3.82Z'/%3e%3cpath class='cls-lfzn4c011hlne8kigt61m-1' d='M3.41 12H11v3.38a3.31 3.31 0 0 1-3.31 3.31h-1a3.31 3.31 0 0 1-3.31-3.31V12h.03Z'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='7.23' y1='9.14' x2='7.23' y2='7.23'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='18.68' x2='19.64' y2='18.68'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='14.86' x2='19.64' y2='14.86'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='11.05' x2='19.64' y2='11.05'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-lfzn4c011hlne8kigt61m-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpath class='cls-lfzn4c011hlne8kigt61m-1' d='M14.86 1.5H5.32A3.82 3.82 0 0 0 1.5 5.32v1.91h13.36v11.45H1.5v3.82h21V5.32a3.82 3.82 0 0 0-3.82-3.82Z'/%3e%3cpath class='cls-lfzn4c011hlne8kigt61m-1' d='M3.41 12H11v3.38a3.31 3.31 0 0 1-3.31 3.31h-1a3.31 3.31 0 0 1-3.31-3.31V12h.03Z'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='7.23' y1='9.14' x2='7.23' y2='7.23'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='18.68' x2='19.64' y2='18.68'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='14.86' x2='19.64' y2='14.86'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='11.05' x2='19.64' y2='11.05'/%3e%3c/svg%3e" width="40px" /> Identify the most loyal customers overall.
</aside>
<aside> <img src="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-lfzn4c011hlne8kigt61m-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpath class='cls-lfzn4c011hlne8kigt61m-1' d='M14.86 1.5H5.32A3.82 3.82 0 0 0 1.5 5.32v1.91h13.36v11.45H1.5v3.82h21V5.32a3.82 3.82 0 0 0-3.82-3.82Z'/%3e%3cpath class='cls-lfzn4c011hlne8kigt61m-1' d='M3.41 12H11v3.38a3.31 3.31 0 0 1-3.31 3.31h-1a3.31 3.31 0 0 1-3.31-3.31V12h.03Z'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='7.23' y1='9.14' x2='7.23' y2='7.23'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='18.68' x2='19.64' y2='18.68'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='14.86' x2='19.64' y2='14.86'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='11.05' x2='19.64' y2='11.05'/%3e%3c/svg%3e" alt="data:image/svg+xml,%3csvg stroke-width='1.5' id='Layer_1' data-name='Layer 1' xmlns='http://www.w3.org/2000/svg' viewBox='0 0 24 24'%3e%3cdefs%3e%3cstyle%3e.cls-lfzn4c011hlne8kigt61m-1%7bfill:none%3bstroke:%23337EA9%3bstroke-miterlimit:10%3b%3b%7d%3c/style%3e%3c/defs%3e%3cpath class='cls-lfzn4c011hlne8kigt61m-1' d='M14.86 1.5H5.32A3.82 3.82 0 0 0 1.5 5.32v1.91h13.36v11.45H1.5v3.82h21V5.32a3.82 3.82 0 0 0-3.82-3.82Z'/%3e%3cpath class='cls-lfzn4c011hlne8kigt61m-1' d='M3.41 12H11v3.38a3.31 3.31 0 0 1-3.31 3.31h-1a3.31 3.31 0 0 1-3.31-3.31V12h.03Z'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='7.23' y1='9.14' x2='7.23' y2='7.23'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='18.68' x2='19.64' y2='18.68'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='14.86' x2='19.64' y2='14.86'/%3e%3cline class='cls-lfzn4c011hlne8kigt61m-1' x1='17.73' y1='11.05' x2='19.64' y2='11.05'/%3e%3c/svg%3e" width="40px" /> Find top-spending customers in vintage clothing for 2016.
</aside>