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
Applicable Functions
- Business Operation
Use Cases
- Predictive Quality Analytics
- 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 needed 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 goal was to improve the services and facilities available to citizens.
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 developed an internal report that identified a low quality in public works projects related to roads, schools, parks, and other public facilities. Ultimately, the Mexican people were the ones that were slighted, since these projects were not completed in the time and manner expected. To improve the services and facilities available to citizens, administration officials realized they needed a more comprehensive way to audit and control public works projects.
The Solution
The IT department of MPA began by preparing a secure back-end database environment for consolidated reporting. They created 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. These tools work together to extract, transform, load, and cleanse information from different types of databases into a trusted information source for agency-wide reporting. Once all of the information was properly cleansed, processed, and centralized, the Ministry used WebFOCUS to create reports and dashboards to visualize the collected data and drill down into the details.
Operational Impact
Related Case Studies.
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
IoT Data Analytics Case Study - Packaging Films Manufacturer
The company manufactures packaging films on made to order or configure to order basis. Every order has a different set of requirements from the product characteristics perspective and hence requires machine’s settings to be adjusted accordingly. If the film quality does not meet the required standards, the degraded quality impacts customer delivery causes customer dissatisfaction and results in lower margins. The biggest challenge was to identify the real root cause and devise a remedy for that.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.