Making sense of mixed data

What was wrong

The client’s data source was a jumble of Excel spreadsheets, sourced from several disparate platforms. Manual downloads and analysis fraught with risk of human error made for untimely and unreliable reporting.

What we did

By cleansing data, building sustainable dynamic table joins, and educating the client towards better data governance, we produced a cohesive and highly interactive series of Power BI dashboards.

Why it mattered

Account manager activity is monitored much closer to real time, with a multitude of cuts accessible with a few clicks. The reporting was released to great fanfare locally and has gained global traction in the company.