The purpose of this work was to understand how profitable it would be for a retail company to open a new store.
There were two Excel spreadsheets provided to analyze the data. The first table included historical cost data for the opening of existing stores. The second table had data on the likely costs of opening a new location.
The client asked to compare all data both numerically and in percentage terms. He also asked to analyze and compare the costs of opening stores and provide them in an interactive Excel dashboard.
I decided to make this analysis as visual as possible. For this purpose I used heat maps in tables, as well as a bar chart with a percentage distribution.