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 Mastek 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 Mastek 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. Mastek 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 Mastek 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 Mastek 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 Mastek?
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 Mastek 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.