Lewis County: Budget Transparency
Lewis County faced three major challenges:
The county needed to improve transparency with residents regarding public spending.
Department heads lacked easy access to general ledger reports detailing spending and revenues.
The general ledger data did not integrate with other county datasets.
Rather than accept these limitations, county leaders took action by partnering with Quantify Consulting.
The Problem
The Solution: Connected Data Sources
Quantify Consulting built a cloud-based analytics infrastructure that freed Lewis County's financial data from its ERP prison:
We connected the Tyler ERP and payroll systems to a centralized Azure SQL data warehouse, creating automated ETL pipelines that refresh weekly.
The data warehouse enabled rapid development of additional analytics.
The Solution: Public Transparency through Visual Storytelling
Quantify built interactive Power BI dashboards on top of the Azure data warehouse
Today, department heads can quickly see where funds have been allocated, and residents have clear, accessible insights into how public money is being spent.
Lewis County became one of the first rural counties in upstate New York to offer real-time financial transparency. Citizens can track tax dollars as they're spent, strengthening public trust.
"I am delighted to recommend Evan Jennings for his outstanding performance on a recent data analytics project. His work provided actionable insights. Evan approached the project with a clear vision and a structured methodology. He conducted a thorough needs assessment, identified key performance indicators, and gathered relevant datasets from various sources. He maintained a clear timeline and not only met the project objectives but exceeded expectations in terms of quality and impact."
Tim Hunt, County Manager at Lewis County NY
The Impact
Lewis County's transformation happened in three months, not three years. They didn't replace their ERP system—they built a modern analytics layer on top of it. The result: every department head has instant budget visibility, every citizen can track spending, and the county has a foundation for future data-driven initiatives. Meaningful financial transparency doesn't require ripping out legacy systems. It requires the right architecture and a commitment to turning data into stories that stakeholders can understand and act on.