151:: Higher Productivity, Deeper Insights

Problem: Lack of productivity & transparency
Task at hand: 150 spreadsheets to be automated
Facts: 150 spreadsheets were monthly created and updated.
Containing data about product distribution by
– state
– channel
– product category
Issues: 3 days of update work
lack of transparency
lack of comparability
lack of usability
What I did: Condensed the 150 spreadsheet into 1 and enabled the user to analyse the data in any way she wanted.
Outcome: timesaving
better decisions
higher productivity
deeper insights

Watch the story here:

Download the case-study from this link.