Improve Analytic Efficiency

Improve analytic efficiency through automation…

Problem: A major employees union contract is set to expire. The union represents 20,000 employees and the employer, a large municipality, needs to quickly understand the financial impact of a complex set of proposed rate increases as negotiations progress. Municipal officials have attempted to perform this analysis using spreadsheets, but the complexity and magnitude of the problem has demanded a more robust solution.

Solution: A fully automated analytic database application which allows the user to easily change assumptions to build a range of scenarios. Instead of combing through complex formulas and linked cells, the user conducts the same analysis through a simple point and click interface.

Click here to view an illustration.