This is an Interactive
Sales Performance Dashboard in Excel. The client
needed to analyze sales information such as overall
sales, sales per product line, gross margins, net
profits, sales mix, etc. This excel tool allows the
client to view information from a different
perspectives such as sales per month, gross margins
during a year, or product sales per quarter. The user
can easily switch from one view to another with a
click of a button and it is very easy to analyze and
understand information regarding sales and profits.
Before, it took the client a lot of time and multiple
reports to monitor, understand, and communicate
information. Now it takes only a minute and one tool.