Case Study 1 - Invoice Calculations: From complex to simple

Challenge

Though this study only involved a small amount of data, my client was manually calculating invoices from three different sections of a spreadsheet. Costs differed depending on the product itself, the location of the product and the location of the customer.

Solution

I created a simple invoice sheet where all my client has to do is click from a drop down menu for the three main variables which would produce his quote, with the invoice sheet sourcing the data directly meaning no manual intervention and therefore no room for error.

Case Study 2 - Clarifying data to find profitability

Challenge

My clients brand involves a vast amount of products and several different sales channels.  I sliced the data up to look at it in different ways and from there, my client was able to see that just one of his products was actually responsible for 56% of net profit while 20% of his products were making a loss.  

Solution

This enabled my client to focus his time and effort on the profitable end and streamline the amount of products he was selling.