Modernizing Solid Waste Management Analysis and Reporting

About the Program

Category: Financial Management (Best in Category)

Year: 2021

On December 1, 2020, the Solid Waste Management Division migrated its weighing, billing, and collection system to a new system where transaction history did not transfer. Consequently, the Finance staff no longer had data available to do routine work, meet deadlines, and conduct business trend analysis, reporting and forecasting. Finance staff partnered with Wake County Information Systems to create a Power BI app that would combine the two databases and address data needs. The programmer showed creativity and resourcefulness when creating the weekly year-over-year comparison analysis by finding a calendar where each fiscal year starts with the nearest Monday to July 1. With an investment of approximately 100 hours of staff time identifying business requirements, programing, testing, adjusting and training, Finance staff was able to use the app on January 15 and has met deadlines and conducted trend analysis ever since and will continue to do so year after year. This modest investment will save approximately 150 hours annually while providing accurate information. In addition, our response time for customer payment inquires have been reduced by 60%.