Onyx Analytics

Case Study

Dashboarding and Reporting

This project involved data management, dashboard and report creation for the performance assessment of a Sales force of the client. The project involved accessing the data sources – normalizing the data, applying business rules, sending the processed data to the team, and then applying business rules for the reports generation to identify the sales of an account and its impact on the neighboring areas to determine its contribution to the overall national sales. The dashboard showed the performance on the identified KPIs and the impact on sales results vs the efforts. The information was presented in a drill down or drill up manner to be able to view aggregated performance or the granular details that impacted the results. Managerial views were also incorporated for the ease of team’s assessment.