Download PDF
Mexico Ministry of Public Administration Improves Accountability for Public Works Projects
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
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.
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 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
Quantitative Benefit
Related Case Studies.
Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.
Case Study
Airbus Soars with Wearable Technology
Building an Airbus aircraft involves complex manufacturing processes consisting of thousands of moving parts. Speed and accuracy are critical to business and competitive advantage. Improvements in both would have high impact on Airbus’ bottom line. Airbus wanted to help operators reduce the complexity of assembling cabin seats and decrease the time required to complete this task.
Case Study
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
Improving Production Line Efficiency with Ethernet Micro RTU Controller
Moxa was asked to provide a connectivity solution for one of the world's leading cosmetics companies. This multinational corporation, with retail presence in 130 countries, 23 global braches, and over 66,000 employees, sought to improve the efficiency of their production process by migrating from manual monitoring to an automatic productivity monitoring system. The production line was being monitored by ABB Real-TPI, a factory information system that offers data collection and analysis to improve plant efficiency. Due to software limitations, the customer needed an OPC server and a corresponding I/O solution to collect data from additional sensor devices for the Real-TPI system. The goal is to enable the factory information system to more thoroughly collect data from every corner of the production line. This will improve its ability to measure Overall Equipment Effectiveness (OEE) and translate into increased production efficiencies. System Requirements • Instant status updates while still consuming minimal bandwidth to relieve strain on limited factory networks • Interoperable with ABB Real-TPI • Small form factor appropriate for deployment where space is scarce • Remote software management and configuration to simplify operations