Information Builders > Case Studies > Mexico Ministry of Public Administration Improves Accountability for Public Works Projects

Mexico Ministry of Public Administration Improves Accountability for Public Works Projects

Company Size

1,000+

Region

America

Country

Mexico

Product

WebFOCUS
iWay Integration Suite
iWay Data Quality Suite

Tech Stack

Business Intelligence
Data Integration
Data Quality

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Digital Expertise
Productivity Improvements

Technology Category

Analytics & Modeling - Real Time Analytics
Application Infrastructure & Middleware - Data Exchange & Integration
Application Infrastructure & Middleware - Data Visualization

Applicable Functions

Business Operation

Use Cases

Process Control & Optimization
Real-Time Location System (RTLS)

Services

Data Science Services
System Integration

About The Customer

The Ministry of Public Administration of Mexico (MPA) is a federal agency whose purpose is to coordinate, evaluate, oversee, and audit public projects undertaken by the federal government. The agency is responsible for ensuring that public works projects related to roads, schools, parks, and other public facilities are completed in a timely and efficient manner. The MPA is committed to improving the services and facilities available to citizens and has identified a need for a more comprehensive way to audit and control public works projects.

The Challenge

The Ministry of Public Administration of Mexico (MPA) was facing a challenge of low quality in public works projects related to roads, schools, parks, and other public facilities. The agency identified a need for a more comprehensive way to audit and control public works projects. They decided to create a business intelligence (BI) and data integration environment that could link several public information systems, create a consolidated and trusted source of project information, and present results on demand through interactive reports and dashboards.

The Solution

The MPA developed a BI environment to present results on-demand through interactive reports and dashboards; using data quality and BI to gather, combine, and leverage information from various applications. The first step was to create a specialized entity called the Public Works Audit and Control Unit (PWACU), which records all types of information, such as the beginning, conclusion, or cancellation of a project. After the creation of the PWACU, the Secretary of Public Affairs integrated other systems to manage the planning, contracting, control, and overseeing of public works and services. The Ministry of Public Administration created the Public Works Intelligent System (PWIS), which covers the different steps in a construction project and is crucial when making management decisions. To catalog and integrate all these existing information and data sources, the team used Information Builders’ iWay DataMigrator and iWay Data Quality Suite.

Operational Impact

Real-time access to a trusted single source of truth that is accurate, trusted, timely, and organized
Greater security for a large and diverse public enterprise
Improved supervision and oversight of public works, with an emphasis on preventing runaway costs
Legal validation via a system that enables advanced electronic signatures

Quantitative Benefit

The public works initiative received first place in the 2012 awards given by the United Nations in the category of “Combat and Prevention of Corruption in Public Service.”