Article #268 Developing the Common Data Visualization and Business Intelligence Environment for Capital Construction Projects

For many of those involved in construction projects having a “Common Data Environment (CDE)” is becoming a requirement. By definition, a CDE is the single source of information for the project, used to collect, manage and disseminate documentation, the graphical model and non-graphical data for the whole project team (i.e. all project information whether created in a BIM environment or in a conventional data format). Creating this single source of information facilitates collaboration between project team members and helps avoid duplication and mistakes.

Similar to CDE, there is also a growing requirement among executive project stakeholders, program and project managers, contract and commercial managers, project control managers and other executive project team members to develop what is known as Common Data Visualization and Business Intelligence Environment (CDVnBIE). The CDVnBIE will provide a single source of information when it comes to monitoring, evaluating and reporting projects and programs performance as well as enable these stakeholders to analyze the captured data to provide them with the insight to make better and faster informed decisions.

The data sources or the data authorization applications for CDVnBIE will usually include tools for developing and managing BIM models, planning and scheduling, cost estimating and financial data, procurement and contract, risks and issues, quality assurance and control, health and safety, environmental and sustainability, communications generation and distribution, document management, geospatial information management among others such as ERP, CMMS and HRMS. The data extraction for those applications can be based on simply MS SQL queries, building data integration applications using APIs and creating visuals for data visualization and business intelligence applications like MS Power BI. The extracted data will become the basis for associating, blending and consuming the data in the format needed to provide the needed data visualization and business intelligence.

Data Authorizing Software

There are number of data authoring software that are common to the capital construction projects. Those include Project Management Information Systems (PMIS) like PMWeb, planning and scheduling software like Primavera P6 and MS Project, document management systems like Aconex, OpenText among others, BIM models data like Revit, geospatial data like ESRI, ERP like Oracle, SAP, MS Dynamics among many others.

PMWeb will be the platform that will be used to capture all project’s data that relate to formal communications, cost and budget management, procurement and contract management, safety, health and environmental (HSE) management, quality assurance and quality control (QA/QC), risk and issues management, sustainability and other project management data. This captured data which can be extracted and queried by MS Power BI will become the basis for reporting the performance of all project management processes.

Primavera, MS Project, MS EPM Server among other planning and scheduling software applications will be used to capture the project’s baseline, revisions and updated resource-loaded schedule data. MS Power BI enables extracting and querying data from both MS SQL database and MS SharePoint database for which they will become the basis for MS Power BI reports.

Document management systems like OpenText and Aconex are examples of some of the widely used document management systems on construction projects. Using the API which is the acronym for Application Programming Interface, an application can be created to extract the data associated with documents that are uploaded into the Document Management System like Aconex. This data will become available to be extracted and queried by MS Power BI.

The BIM model data captured in Revit can be extracted by applications like Dynamo where the workflow for the data extraction needs to be created to enable reading the Revit data by MS Power BI. Another quicker and simpler approach would be to use an application like BEXEL Manager where they have created a direct BIM model data extract to MS Power BI. In addition, BEXEL Manager MS Power BI tool has few templates that can be used in visualizing the BIM model data. Those include for example the clash detection register where it details all identified BIM model clashes and the status of each.

In addition, Vcad for Blogic can create an interactive BIM model visual that can be used in MS Power BI reports and dashboards. The BIM model visual can be created from Revit or IFC BIM models. Along with the BIM model visual, Vcad comes with data templates that captures the details of objects and assets included in the Revit or IFC BIM models.

As for the ESRI GIS, shapefiles need to be created to include the information that need to be displayed in the MS Power BI. The shapefile would usually include the latitude and longitude values for the different points that defines project’s boundaries or polygon. Those shapefiles will be converted into Geojson file format to enable viewing the ESRI GIS data in MS Power BI using Mapbox interactive map visual.

The data captured from those data authoring applications will be associated with each other using the data fields that are common for all those applications. The common data fields would usually include project number, work breakdown structure (WBS) levels, cost breakdown structure (CBS) levels, GIS latitude and longitude values, BIM ObjectID and ExternalID among others. This will enable blending and visualizing the captured data in any desired form and format to provide the needed Common Data Visualization and Business Intelligence Environment (CDVnBIE).

About the Authorfounder

Bassam Samman, PMP, PSP, EVP, GPM is a Senior Project Management Consultant with more than 35-year service record providing project management and controls services to over 100 projects with a total value in excess of US $5 Billion. Those projects included Engineering and Construction, Oil and Gas Plants and Refineries, Telecommunication and Information Technology projects. He is thoroughly experienced in complete project management including project management control systems, computerized project control software, claims analysis/prevention, risk analysis/management (contingency planning), design, supervision, training and business development.

Bassam is a frequent speaker in topics relating to Project Management, Strategic Project Management and Project Management Personal Skills. Over the past 35 years he has lectured at more than 350 events at different locations in the Middle East, North Africa, Europe and South America. He has written more than 250 articles on project management and project management information systems that were featured in international and regional magazines and newspapers. He is a co-founder of the Project Management Institute- Arabian Gulf Chapter (PMI-AGC) and has served on its board of directors for more than 6 years. He is a certified Project Management Professional (PMP) from the Project Management Institute (PMI), a certified Planning and Scheduling Professional (PSP) and Earned Value Professional (EVP) from the American Association of Cost Engineers (AACE) and Green Project Management (GPM).

Bassam holds a Masters in Engineering Administration (Construction Management), (1982) with Faculty Commendation, GWU, Washington, D.C., USA, Bachelor in Civil Engineering (1980) – Kuwait University, Kuwait and has attended a number of executive management programs at Harvard Business School, Boston, USA and London Business School, London, UK.

 

Contact us