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

Edit This Case Study Record

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

Mexico Ministry of Public Administration Improves Accountability for Public Works Projects

Information Builders

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

Impact #1	Real-time access to a trusted single source of truth that is accurate, trusted, timely, and organized
Impact #2	Greater security for a large and diverse public enterprise
Impact #3	Improved supervision and oversight of public works, with an emphasis on preventing runaway costs

Impact #1

Real-time access to a trusted single source of truth that is accurate, trusted, timely, and organized

Impact #2

Greater security for a large and diverse public enterprise

Impact #3

Improved supervision and oversight of public works, with an emphasis on preventing runaway costs

Benefit #1	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.”

Benefit #1

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.”

Download PDF Version

Overview

Mexico Ministry of Public Administration Improves Accountability for Public Works Projects

Operational Impact

Quantitative Benefit