Predicting lost business due to unavailable stock

Predicting lost business due to unavailable stock

Key Achievements: saving 250,000 GBP in yearly lost business and 46,000 A3 paper sheets while freeing up 1200 man hours per year that can be dedicated to analysis instead of reporting. Challenges The client is a wholesaler turning...

Building a beautiful Dashboard using Excel (part 1)

Building a beautiful Dashboard using Excel (part 1)

When dealing with a client that has Excel 2010, 2013 or 2016, the Sensdat team builds and formats the cockpit using a very familiar program, Excel, using Pivot Tables, slicers, hyperlinks and conditional formatting. The following process will...