POWER BI / BIM ANALYTICS

BIM analytics for projects and construction

Quantities under a common criterion

In tenders, models provide quantities, but each category can store them in different fields. To prepare comparable reports, we developed a Dynamo procedure that transferred the relevant lengths, areas, and volumes into shared parameters: BDC Length, BDC Area, and BDC Volume. Power BI could then group the information by cost classification, building, level, discipline, or category. The task was not to add up every available measurement, but to put the appropriate quantity for each element type into a common field.

A schedule that retains its link to the model

On the monorail project, we worked with objects that already had WBS references, making it possible to link geometry and activities. The reports showed the schedule and progress from a 4D perspective. In another analysis of the same setting, the team programmed automations that added steel optimization and waste information to elements. My contribution was to present and break down those data in Power BI while preserving their association with objects and site engineers' checklists. These cases showed that data must retain its context: a tonnage figure means something different when it is linked to the rebar type, the element, and the review of the construction front.

Reviewing documentation and anticipating activities

For drawing control on an industrial project, I developed a Dynamo script and a Power BI template. The routine queried sheets, views, text, and dimensions in Revit and calculated possible overlaps. The outputs retained identifiers that made it possible to locate observations. The team received a template that could be updated: the automated task flagged situations for review but did not correct the drawings. I also built an editable Gantt visual in Power BI from scratch for procurement tracking. It included a look-ahead window of about two months before planned activities, so supply needs could be reviewed before execution. The tool was published in the corporate environment with differentiated permissions: authorized users could edit and save, while others could consult the visual's status.

Exploring asset information

At another stage, I prepared demonstrations that linked thermal measurements to elements and used a custom heat map, along with a way to consult warranties associated with objects. These dashboards could be updated by refreshing their data sources and the report. Their role was to show how an analytical interface can help locate and understand asset information. This was not a single platform containing all those modules. Each experience addressed its own questions related to tendering, coordination, construction, procurement, or maintenance. What connected them was the preparation of data that could be interpreted alongside the objects, documents, or activities to which they actually referred.