Given the significant volume of transactions a government’s ERP can process daily, there is an increasing need to organize and summarize pertinent data. A data warehouse has processes to extract detail transaction data (e.g., payment requests), and transform it into information to support business process reporting and analysis (e.g., what are the total payments for Vendor X for the month of March?). Essentially, a data warehouse converts raw data into business intelligence.
Team Aeris has implemented multiple data warehouses for large organizations including the County of Orange, CA. Each custom data warehouse effort centers around principles of: creating an efficient, structured data model; defining queries and reports key to specific business processes; and, ensuring rapid delivery of accurate results