Implementing Oracle Autonomous Data Warehouse and Analytics Solution for Jeddah Municipality

Jeddah Municipality wanted to design and develop analytics reports in order to track the performance KPIs of each department. They wanted to develop a centralized data warehouse to create a single source of truth for all their reporting requirements. The client body had to put in place an ETL (Extract, Transform, and Load) layer that will automatically fetch data from various data sources and periodically load this data into the newly built data warehouse.

Jeddah Municipality also wanted their team to be trained using the analytics platform, ensuring they are enabled to create robust analytics reports for any new future use cases.

Being in the public sector, Jeddah Municipality’s main concern was data security. The organization wanted a fully secure, private network to carry out all its reporting processes. For this reason, we implemented Oracle Analytics Cloud and Oracle Autonomous Data Warehouse, a private and secure platform that can solely be accessible within the Jeddah Municipality network. With this, the organization can transfer data from their on-premise system to the Oracle Cloud environment securely.

Implementing Oracle Data Warehouse helped Jeddah Municipality’s executive leadership members to develop an easily configurable reporting solution. Evosys developed a customized data mart layer with 50 reports for all the client’s major KPIs. This goes on Jeddah Municipality’s OAC dashboards, helping them access data and gain insights faster, as they won’t have to manually aggregate data from different sources or spend time searching within a complex data warehouse. Overall, these reports included project performance scoreboards, HR & financial performance indicator dashboards, and performance indicators for all real estate records. Finally, the Evosys team integrated the entire client database with 8 different data sources, which included both in-house systems as well as local databases.