Product: Oracle Analytics Cloud (OAC),Oracle Autonomous Data Warehouse (ADW) & Oracle Data Integrator from Oracle Marketplace hosted onOracle Cloud Infrastructure (OCI)

Industry:Public Sector

About Jeddah Municipality

As the name suggests, Jeddah Municipality oversees improving the urban planning facilities and provisional services in the city of Jeddah and its surrounding suburbs. Recently, the organization also started undertaking multiple redevelopment projects, where they demolish the entire structure and work on rebuilding its infrastructure from scratch.

Project Summary

Jeddah Municipality partnered with Evosys to implement data integration tools, reports, and analytics dashboards. We also enabled Oracle Cloud Infrastructure (OCI) in order to fetch data from the client’s system so that data can automatically be stored in the Oracle Autonomous Data Warehouse (ADW).

After successful implementation, Jeddah Municipality could fetch the data through Oracle Analytics Cloud. The client developed a robust portal in-house, which could integrate Oracle Application Express (APEX) into Oracle Analytics Cloud. Additionally, the reports developed in Oracle Analytics Cloud can be used to view the dashboards and KPIs of both HR and finance teams. The Evosys team created more than 50 KPIs for the client, all of which are easily accessible from their Oracle APEX Portal dashboard.

Business Objectives

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.

Business Challenges

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.

Business Benefits

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.

Project Details on the Solution Designed

The Evosys team enabled data integration and reporting by setting up Oracle Data Integrator to fetch the data from the source database and route it back, so it is stored in Oracle ADW. We further set up the Oracle ADW environment via OCI and enabled data integration through Oracle Data Integrator. Our team also set up the Oracle Analytics Cloud, developed three different reporting dashboards, and trained the Jeddah Municipality team to develop two other dashboards, generating a maximum of 25 reports and 25 KPIs from the customized data mart layer mentioned above.

Lastly, we integrated eight different data sources, which included in-house systems and local databases.

Why did Jeddah Municipality Choose Evosys?

Jeddah Municipality was looking for an Oracle partner with experience in Oracle Analytics and Autonomous Data Warehouse, who could help them with a quick implementation of a pilot scope. Given Evosys’ experience of delivering similar projects in the past within the deadlines and our strong references in the public sector and in the Middle East, we were chosen as the client’s preferred implementation partner.

Move to Oracle Cloud Today!

Adopt. Automate. Accelerate.

Let's Connect
Image Image
Recommendations
Star
Oracle Cloud
Star
Connect with Experts
Star
Let Evosys contact you
Star
Partnership & Tieup's
Star
Request a call back
Rapid Response
Demo for Oracle Fusion Cloud
Connect with Experts
Let Evosys contact you
Partnership & Tieup's
Request a call back
  Loader
Thank you for contacting us. Our team will contact you soon.