We helped a client compute and review requested metrics on employees. The end result was an Excel file. Every month, a manager would click on a button that would refresh employee data that was pulled from the company’s database. The manager could then pick an employee from a drop-down menu. Once picked, all requested metrics for the employee would be displayed. This allowed the manager to meet monthly with employees and identify ways to increase productivity. This report card was invaluable for helping with hiring and firing decisions.
This project required custom SQL and Excel formulas to calculate custom metrics. Visual Basic was also used to help with the user interface.