Executive Dashboarding for the Enterprise

Apache | ChartDirector | JavaScript | MySQL | Perl | RHEL

Summary

Jumped in two weeks before release date, took ownership, and still delivered a web-based, executives' dashboard solution for experience monitoring without the benefits of system documentation or tests.
execdash icon

Background

An external consultant to the team had been brought in to develop an überdashboard to aggregate data from another project. The learning curve was steep and the consultant wasn't familiar with the base data so his dashboard had some major shortcomings.

Achievements

  • Achieved a 74% reduction in page load-time through a combination of refactoring back-end data structures, improving database queries, & introducing pagination for an 80 KLOC (LAMPerl) data warehousing web app.
  • Discovered and remedied major data quality issues before going live.
  • Radically improved the look and usability of the tool.