Salt Lake City Public Utilities requested a water demand information system specifically for Commercial, Industrial and Institutional (CII) water use tool to help better understand water use by specific markets. The project included a categorization portal, database design, billing data API and a detailed output reporting tool.