Roads Database Platform

Roads Database Platform One of the strongest projects I have worked on, if not the strongest ever, Roads Database Platform It is an integrated project management system, specializing in road construction projects.

 The database was built in the Excel environment with a user interface using the VBA programming language,  The database was divided into several parts:

1. Entry Interface:

  Dedicated to entering daily work reports [ (basic data: “day, date, shift, road name, contractor, weather condition”), activities performed,  equipment (whether owned or rented), Manpower, RFI delivery requests, laboratory tests, material withdrawals , Drilling and blasting works, surveying works ]

This interface also allows editing of previous reports by searching through several criteria.

This interface has been linked to the RFI follow-up Log file, as well as to the laboratory follow-up Log file.

It is also possible to include an image to the report for printed copies, whether on paper or PDF ,

2. Viewer:

Through this window, you can search and review previously saved daily reports. The search is done using several criteria , such as the date, the author of the report, the road name , or the name of the contractor. 

3. Monthly Reports:

Through this window, all parts of the database and saved data are integrated so that all required data is displayed according to the time period specified by the user , you can browse this reports (diesel withdrawals, Material withdrawals, Drilling and Blasting quantities, Equipment time sheet, Manpower , Executed Work statement  , Cost Report (Password Protected)

All data extracted from the monthly reports can be printed for easy data sharing on paper or PDF .

4. Dash board

The saved data are integrated using a proper Data Modeling with  Power BI  to create a dashboard to analyze all the data recorded and monitored in the database, to identify works trends, identify strengths and weaknesses, and predict problems by analyzing trends, to help make the necessary decisions at the right time.

The database supports work on multiple devices in the network simultaneously, and all incoming scenarios are programmed to avoid any problems while saving or recalling data.

Download : Not Available