Manage your projects with daily insights
Modern Engineering, Procurement, and Construction (EPC) projects generate vast amounts of data across disciplines. Yet project controls specialists often struggle to consolidate engineering, procurement, and construction information into a single, timely view for decision-makers. Traditional status reports and manual Excel trackers, updated weekly or monthly, leave executives with lagging indicators and siloed insights. Buro Matei has addressed this challenge by developing daily, automated project dashboards – unified, one-page reports that pull live data from all sources. These dashboards provide actionable, transparent metrics every day, enabling project managers and executives to make informed decisions in real time. This article explores how such integrated dashboards work, the five levels of dashboard analytics (from descriptive to cognitive), and best practices for progress measurement and risk analysis. We will delve into techniques like weighted progress tracking (illustrated with a wooden fence mini-project) and compare traditional tools (Primavera P6, Excel, static reports) with Buro Matei’s Brumata platform and Power BI approach. The goal is to demonstrate deep expertise in unified project controls.
The Power of Daily Integrated Dashboards in EPC

EPC projects traditionally suffer from fragmented data and delayed reporting. Engineering deliverables might be tracked in one system, procurement status in another, and construction progress in yet another – often ending up in separate Excel files or slide decks prepared manually for weekly meetings. This fragmentation leads to limited visibility, manual errors, and reactive decision-making. In fact, project engineers often find themselves “drowning in Excel sheets, trying to track progress manually,” losing valuable hours in meetings and chasing data instead of managing the project. Such inefficient collaboration and lack of real-time insight contribute to delays and cost overruns.
Daily integrated dashboards resolve these issues by providing real-time, one-stop visibility into all critical project metrics. Instead of waiting for a monthly progress report, project managers can see today’s engineering progress, procurement bottlenecks, and site productivity on a single page. At Buro Matei, this approach has been honed through years of EPC experience: the firm recognized that “projects constantly struggled with clarity…No one could easily see what needed to be done or the real status of their work” and set out to automate and unify project data. By leveraging tools like Power BI connected to live databases, their dashboards ensure key data and metrics are in one place, updated automatically, and accessible to all stakeholders.
Crucially, an integrated dashboard is not just a static report – it is interactive and diagnostic. Users can click on a metric (e.g. a late procurement item) and drill down to root causes (e.g. a delayed vendor document), all within the same interface. This immediacy addresses common pain points: “lack of real-time visibility”, “poor integration of data from diverse sources like 3D models, document systems, and procurement platforms”, and “manual, error-prone systems that hinder productivity”. By having all critical indicators on one page – schedule performance, cost performance, milestones, resource utilization, quantities installed, change orders, and more – project leaders can grasp the overall health at a glance each morning. Any emerging issue is highlighted early (e.g. via red/yellow flags on the dashboard), enabling proactive management rather than after-the-fact firefighting.
Benefits of Dashboards
In summary, daily one-page dashboards bring the following benefits:

Unified Insight
Combines engineering, procurement, construction data into a single source of truth (e.g. design progress, material deliveries, field progress, all correlated).

Real-Time Updates
Automatically refreshes with the latest data (often via live connections to project databases or schedules), reducing the reporting lag from weeks to hours.

Actionable Metrics
Shows critical KPIs like Schedule Performance Index (SPI), Cost Performance Index (CPI), earned value, baseline vs actual progress, and pending issues in a concise view.
For instance, a dashboard can display planned vs. actual progress with SPI, CPI, and variance charts alongside key milestones.

Interactive Drilldown
Allows users to click into problem areas (e.g. a late activity or a cost overrun) to see underlying details – something static PDF reports can’t offer.

Improved Collaboration
Because everyone from engineers to executives sees the same live data, it fosters transparency and alignment.
This supports a culture of data-driven decision making and reduces time wasted on status meetings.

One-Page Executive View
All critical insights are available at a glance, eliminating the need to flip through multiple pages or separate reports.
Executives get a clear daily snapshot of project health on a single screen.
By focusing on daily, integrated dashboards, project controls specialists can significantly accelerate decision-making, mitigate risks early, and instill confidence in project outcomes. But not all dashboards are created equal – the most effective ones evolve through different levels of analytical sophistication. Next, we examine the five levels of dashboards and how each adds value.
Five levels of dashboard analytics

From Descriptive to Cognitive
Not only should a dashboard present data, it should also generate deeper insights. As analytical capabilities mature, dashboards generally progress through five levels: Descriptive, Diagnostic, Predictive, Prescriptive, and Cognitive. Each level answers a different question about project performance:
Level 01- Descriptive – “What happened?”

- This is the most basic level, where dashboards describe the current status and historical trends.
- For example, a descriptive project dashboard might show actual progress to date vs. baseline, cost incurred vs. budget, and key performance indicators (KPIs) like SPI or CPI. It provides a snapshot of past and current performance.
- Most project dashboards today are at least descriptive – consolidating data into charts and tables for status reporting.
- This establishes the baseline understanding of where the project stands.
Level 02 – Diagnostic – “Why did it happen?”

- A diagnostic dashboard goes a step further by helping users explore causes and correlations.
- It might allow drilling down into variances: e.g. if the schedule is slipping, the dashboard can highlight which discipline or work package is behind, and perhaps link to reasons (such as late approvals or low productivity).
- Techniques like root cause analysis and interactive drill-downs are employed.
- For instance, the dashboard could show that engineering deliverables are lagging (diagnosing why overall progress is slow), or that a particular vendor’s late delivery caused a construction delay.
- Diagnostic analytics thus provide context and explain drivers behind the numbers.
Level 03 – Predictive – “What will happen?”

- At the predictive level, dashboards leverage forecasting models to project future outcomes.
- In project controls, this means using trend data and statistical methods (even machine learning) to predict, for example, the project’s completion date or final cost.
- A predictive dashboard displays a forecast finish date range (derived from a schedule risk analysis), or predict that if current productivity continues, the project will complete at 5% over budget.
- Key tools include trend charts, regression analysis, and Monte Carlo simulations to compute confidence levels for schedule and cost targets.
- Predictive insights let teams anticipate issues rather than just react – for example, spotting that at the current burn rate of concrete placement, a certain milestone will likely slip by two weeks.
Level 04 – Prescriptive – “What should we do next?”

- Prescriptive analytics not only forecast the future but also recommend actions to optimize outcomes.
- In the context of a project dashboard, prescriptive features could involve scenario analysis or optimization algorithms.
- For example, if a project is forecasted to finish late, a prescriptive dashboard might allow the user to test “what-if” scenarios (adding extra crews, or re-sequencing tasks) and then recommend the optimal approach to recover the schedule.
- It could also prioritize intervention by highlighting which risk mitigation or change, out of many, would yield the best improvement in project KPIs.
- Essentially, the dashboard starts to function like a project advisor, not just a reporter, answering “Given the data, here’s the best course of action.”
- Techniques can include scheduling optimizers, AI-driven recommendations, or integrated project controls simulations.
Level 05 – Cognitive – “How can learn from this?”

- The highest level involves cognitive analytics, where the dashboard employs AI and machine learning to mimic human insight and learning.
- A cognitive project dashboard automatically interpret unstructured data (like reading issue logs or contract text), understand context, and provide insights in a human-like manner.
- For instance, it could use natural language processing to let users ask questions (“Which contractor poses the biggest schedule risk?”) and get answers or even intelligent explanations.
- It learns from historical project data to flag subtle patterns –identifying that a certain type of change order typically leads to cost overruns, or predicting safety incidents based on complex factors.
- Cognitive dashboards can also include virtual assistants (akin to a Siri or Alexa for project managers) that proactively notify stakeholders in plain language: e.g. “The fabrication progress is 10% behind trend; likely cause is material delay, recommended action is to expedite inspection of incoming materials.”
- This level is still emerging in project controls, but it represents the frontier where the system continuously learns and adapts, providing context-aware, adaptive decision support.
Each level builds on the previous ones. In practice, a daily EPC dashboard will incorporate elements of all five levels for maximum impact. For example, Buro Matei’s approach starts with robust descriptive content (one-page view of all KPIs), adds diagnostics (interactive drilldowns into each discipline’s data), includes predictive foresight (trend-based forecasting and Monte Carlo risk analysis), and even prescriptive guidance (scenario simulations and alerts). Cognitive features are on the horizon, with potential AI-driven anomaly detection and conversational interfaces for project data. By understanding these five levels, project controls specialists can assess their current dashboards and plan the roadmap towards more advanced, intelligent systems. Ultimately, a mature dashboard doesn’t just tell you what and why – it also tells you what’s next and what to do, all while continuously learning from new data.
Integrating Engineering, Procurement & Construction data

A core challenge in creating a single dashboard is data integration. Engineering, procurement, and construction each have distinct data sources and metrics. To unify them, a standard structure and robust data pipeline are needed. Buro Matei’s solution, for instance, involves a centralized cloud database (built on Microsoft Dataverse) that acts as a single source of truth for all project data. By connecting previously disconnected systems into one platform, they ensure “everyone sees the same accurate data” across the project lifecycle.
Strategies
Key strategies for integrating disparate EPC data include:
Establish a Work Breakdown Structure (WBS)
- The WBS is the backbone that links all project elements.
- By using a consistent WBS (or coding system) across engineering deliverables, procurement packages, and construction activities, data from different domains can roll up together.
- For example, if “WBS 1.2.3” corresponds to a specific plant system or area, all drawings, purchase orders, and construction tasks for that system should carry that code.
- This allows the dashboard to aggregate progress and performance by WBS or by deliverable group.
- A well-defined WBS for EPC projects (covering all phases) is essential to avoid gaps and overlaps; every piece of work should be accounted for so that engineering percent complete, procurement status, and construction progress can be correlated directly.
- International best practices recommend developing the WBS early (during FEL planning) and including it in the Project Execution Plan.
Use a unified data model and data standards
- Adopting industry standards for data definitions greatly aids integration.
- Buro Matei emphasizes aligning dashboards with standards like CFIHOS (Capital Facilities Information Handover Specification) and BIM Level of Development (LOD) references.
- CFIHOS, for instance, standardizes the tags and properties for equipment and documents in EPC projects, making it easier to match engineering data with procurement and commissioning information.
- Similarly, BIM LOD standards ensure that 3D model data is structured consistently.
- By conforming to such standards, disparate tools (3D modeling software, document control systems, scheduling tools) produce data that can be more readily joined.
- The result is future-proof compliance and easier data exchange between systems.
- In practice, this could mean using standard codes for document types, standard discipline codes, or common tagging of equipment from design through construction.
Data integration
- Modern dashboards pull data automatically using APIs or ETL (Extract, Transform, Load) pipelines.
- For example, an engineering documents and design system (like Aconex, AVEVA or Autodesk) might provide an API to list all deliverables and their status; Primavera P6 can be queried for schedule updates; procurement might be tracked in an ERP (like SAP).
- These can feed a central repository or directly feed Power BI.
- Buro Matei’s technology stack leverages Microsoft Power Platform tools (Power Query, Dataflows) to seamlessly integrate data from Microsoft 365, on-premise SQL databases, cloud services, and even 3D model platforms.
- The technical goal is a real-time data warehouse of project information. An integration manager role can be crucial here – as described in Advanced Work Packaging (AWP) methodology, Integration Management focuses on breaking down information silos and ensuring “timely access to accurate, up-to-date information” across all stakeholders.
- This goes beyond traditional document control by actively redesigning data flows so that engineering, procurement, and construction data streams are connected and standardized.
Link 3D Models and BIM to progress
- A powerful aspect of integration is tying the 3D model to the dashboard.
- Each component in a BIM model (e.g. a structural steel beam or a pipe) can carry metadata like the CWP, procurement package ID or the schedule activity ID.
- By linking these, the dashboard can visualize progress in terms of the model (for instance, color-coding model components by installation status or showing quantities installed vs. planned).
- It also enables quantity-based progress measurement – if the model knows the total count or volume of each item, and the field data provides how many are installed, the dashboard can compute progress.
- Buro Matei has developed 3D Model dashboards to monitor progress of 3D model elements and construction work packages (CWPs).
- This integration ensures that the status of work can be seen not just in tables but also in context of the physical plant (often called 4D BIM when tied with time).
- For example, an integrated EPC dashboard might highlight on the model which areas are behind schedule or which components are missing from procurement – giving an intuitive visual cue to project teams.
Advanced Work Packaging (AWP)
- AWP is a best-practice framework that intrinsically links engineering, procurement, and construction through structured work packages.
- By organizing work into Construction Work Packages (CWPs) and smaller Installation Work Packages (IWPs), and aligning engineering deliverables and procurement items to these packages, projects can ensure readiness of work fronts.
- An integrated dashboard that supports AWP will track the status of each CWP/IWP across phases – e.g. engineering deliverables (drawings, materials) completed for that package, materials delivered, and construction progress on that package.
- This approach creates a constraint-free work environment where crews always have what they need.
- AWP’s focus on early planning and involving construction in engineering decisions (i.e. “construction-driven planning”) means that data integration starts at the planning phase.
- Dashboards reflecting AWP might include a CWP readiness index (showing how prepared each upcoming work package is in terms of design, materials, permits, etc.).
- By integrating these data, the dashboard not only shows what is happening, but ensures alignment with a path-of-construction plan.
- AWP is recognized as a best practice in capital projects because it maximizes field productivity through such integration.
In summary, building an integrated EPC dashboard requires breaking down data silos and connecting systems under a unified framework. It involves careful planning of data architecture and often adopting a platform (like Brumata) that serves as the hub for all project data. The payoff is significant: instead of disjointed reports, everyone from engineering leads to site managers works off the same real-time dashboard, with data that is consistent and cross-linked. This not only improves accuracy (no more version confusion or manual re-entry errors) but also boosts collaboration – when engineering, procurement, and construction see each other’s data in context, it encourages a more holistic approach to problem-solving. An engineer can notice, for instance, that a design document delay is now holding up a procurement item on the dashboard, prompting faster resolution. As one case study noted, highly integrated project delivery (as enabled by AWP and data integration) “requires engineering, procurement and construction professionals working in concert” – the integrated dashboard is the medium that makes this concerted effort possible on a daily basis.
Metrics, Benchmarking and Baselines

When designing a daily project dashboard, it’s important to include all critical metrics and contextual data that project controls professionals rely on. A truly useful dashboard will cover not only current progress, but also benchmarks, baselines, trends, and change impacts. Here are key elements that should be addressed:
Baseline vs Actual tracking
- Any effective dashboard must show how the project is performing against its plan.
- This includes baseline schedule versus actual progress (often visualized through timelines or S-curves) and baseline budget versus actual cost.
- For example, a dashboard might display an S-curve of cumulative progress (% complete) with the baseline curve and actual curve, highlighting any deviation.
- If the actual progress line is below the baseline, that indicates a negative variance (behind schedule).
- Similarly, costs can be shown with Budgeted Cost of Work Scheduled (planned spending) vs Actual Cost.
- By preserving baselines (whether schedule baseline or control budget baseline), the dashboard ensures that any variations are clearly visible and quantifiable.
- In a monthly progress report template, one would typically include graphs for “Baseline vs Actual Trend” and “Negative Variance Trend” – a daily dashboard condenses that into an always-up-to-date visual.
- Descriptive statistics like schedule variance (SV) and cost variance (CV) values, or indices like SPI and CPI, can be calculated on the fly to quantify these differences (e.g., SPI = 0.83 indicates 17% behind schedule).
Benchmarking and historical data
- Benchmarks put performance into perspective.
- A sophisticated dashboard incorporates benchmark data either from past similar projects or industry standards.
- For instance, if the project is constructing 100 km of pipeline, how does the current laying rate (km per week) compare to similar projects in the past?
- Benchmarking can also apply to cost (e.g. unit rates) or schedule (e.g. design cycle times). Including these in the dashboard (perhaps as reference lines or targets) helps identify whether a project is truly performing poorly or if the plan was over-ambitious.
- In early project phases, benchmarks are used to develop estimates and schedules; in execution, they serve as yardsticks for progress.
- A dashboard might display a productivity index for construction crews against an industry benchmark, or show how the project’s percentage complete compares to a historical average for projects at a similar stage.
- Incorporating historical data and benchmarks can also feed predictive analytics – for example, using past trends to forecast remaining durations more realistically.
- Best practices even suggest that a baseline schedule package include a benchmarking report, underlining the importance of comparing plan vs. external reality.
- Dashboards that draw from a repository of historical project data (e.g. using a library of past performance metrics) enable continuous improvement and realistic forecasting.
Estimates and Forecasts
- Beyond showing current status, a project dashboard should answer: “Where are we headed?”
- Thus, forecasts like Estimate at Completion (EAC) and Estimate to Complete (ETC) are critical.
- These can be derived from Earned Value Management (EVM) calculations or from trend analysis.
- For example, if the project’s Cost Performance Index (CPI) is 0.90 (meaning for every dollar spent only €0.90 of value is earned), one can project the final cost (EAC) as Budget at Completion / CPI.
- A good dashboard automatically computes these metrics and displays them clearly, alerting management if the forecast suggests an overrun or a delay.
- Likewise, finish date forecasts should be shown, often with ranges. Techniques like Monte Carlo simulation can provide a probabilistic finish date – e.g. a P80 confidence finish date might be displayed to reflect schedule risk.
- According to the Project Management Institute, running a schedule risk analysis with Monte Carlo helps “determine the likelihood of dates” and identify potential overruns.
- Advanced dashboards incorporate such an SRA (Schedule Risk Analysis) report summary, sometimes showing a confidence slider or distribution for completion.
- In short, including up-to-date EAC/ETC for cost and schedule (with consideration of risks) turns the dashboard into a forward-looking tool, not just a rear-view mirror.
Change management
- EPC projects inevitably undergo changes – scope additions, design modifications, site conditions changes, etc.
- These variations (change orders) can significantly impact outcomes if not controlled.
- A comprehensive dashboard includes a section on change management: number of change requests, approved changes, their cumulative impact on cost and schedule baselines, and pending changes in the pipeline.
- For example, it might list “Total Approved Variations: 5, adding €2.3M and 30 days to the baseline” along with charts of trend of changes over time.
- It should also highlight baseline adjustments – e.g. if the finish date has slipped due to approved changes, that new baseline should be reflected and clear to all.
- Integrating the change log with the dashboard ensures that everyone is aware of scope growth and corresponding baseline shifts, preserving transparency.
- Many traditional project status reports dedicate a section to key changes; the dashboard makes this information continuously visible.
- Additionally, tracking budget contingency drawdown or trend logs (records of potential changes before formal approval) can be part of this module.
Weight factors and quantity surveillance
- In order to measure physical progress accurately, many EPC projects use weighting factors for different deliverables and activities.
- Weight factors assign a relative weight or value to each element of work, so that progress can be measured in a weighted average fashion.
- A dashboard should clearly incorporate these weightings – often through the concept of earned value or a progress percentage that reflects weighted completion.
- For example, if a certain subsystem of the project carries 10% of the total weight and it is 50% complete, then it contributes 5 percentage points to the overall progress.
- By summing across all weighted components, the dashboard shows overall % complete. Additionally, quantity surveillance refers to tracking actual installed quantities of work (cubic meters of concrete poured, tons of steel erected, drawings completed, etc.) against planned quantities.
- A good dashboard will have a quantity progress view for major commodities: e.g. “Concrete: 8,000 m³ of 10,000 m³ poured (80%)”, “Cable pulled: 50 km of 100 km (50%)”, etc.
- This raw quantity tracking, often verified by quantity surveyors on site, underpins the progress calculation and also helps validate that reported progress is grounded in field reality.
- For instance, if 8,000 m³ of concrete are poured out of 10,000 m³ total, that discipline’s progress is 80% (assuming equal weight per volume).
- Dashboards might use gauges or bar charts to show such quantity-based progress for key trades, ensuring no guesswork is involved – it’s measured work in place.
Data sources
- Finally, transparency about the data itself is useful.
- The dashboard can indicate the source of each metric (e.g. schedule data from Primavera, cost data from ERP, etc.) and when it was last refreshed.
- This gives users confidence in the data’s timeliness.
- If a data source hasn’t updated (say a procurement spreadsheet wasn’t refreshed that day), the dashboard can flag it so users understand any potential staleness.
- Over time, as systems become fully automated, all data should refresh at least daily, if not in real-time.
- Buro Matei’s approach uses automation to ensure data quality and consistency – they highlight overcoming “data fragmentation” by creating a centralized, cloud-based database that everyone uses.
- Knowing that, for example, all engineering progress comes from a controlled system that is updated by the engineering team at end-of-day, gives credibility to the dashboard.
- Some dashboards include a small indicator like “Data last updated: today at 06:00 AM” for each section.
Inclusion of these elements transforms a dashboard from a simple status tool to a comprehensive project control center. It mirrors the content of a full project status report or an executive overview, but in an interactive and continually updated manner. By addressing benchmarking, estimates, variations, baselines, weights, quantities, and data integration, the dashboard ensures no key piece of the project’s performance puzzle is missing. Everything is on one page or a click away – from high-level summary to detailed support data – giving project controls specialists and executives confidence that they have the complete picture.
Progress Measurement

One of the most important (and challenging) aspects of project controls is measuring progress in a way that is accurate, fair, and standard across the project. EPC projects involve different types of work – engineering designs, documents, procurement items, construction quantities – which are not directly comparable. To aggregate progress, a Progress Measurement System (PMS) is established, often assigning weights or earned value to each component of work. Let’s break down how a robust progress measurement system works, including how weights are set and rolled up, and then illustrate it with a concrete example.
Setting weights
The basic idea is to allocate a weight (or worth) to every deliverable or activity such that the total project weight is 100% (or some convenient total like 1000 points, or equal to the budget in euros). Weights can be based on different factors:
1. Bill of Quantities (BOQ) / Physical Quantity
- Weight proportional to the quantity of work.
- For example, if a project has 10,000 cubic meters of concrete and 5,000 meters of piping, one might assign weights corresponding to these volumes (adjusted by importance or effort).
- This is common in construction where each unit of work contributes equally to progress (assuming similar effort per unit).
2. Cost or Budget
- Weight proportional to cost (this is essentially the Earned Value Management approach, where the budget of each activity represents its weight).
- Higher cost activities contribute more to overall progress.
- This ties progress directly to spending – if an activity has a budget of €1M out of a €10M project, it represents 10% of the project by weight.
3. Effort hours
- Weight based on planned labor hours.
- If certain tasks are labor-intensive, their weight reflects the proportion of total hours.
- For instance, engineering deliverables might be weighted by the design hours estimated for each.
4. Deliverable value or criticality
- Sometimes weights are chosen by expert judgment to reflect the relative significance of deliverables.
- For instance, a critical system might be given extra weight to ensure focus, or a simple deliverable gets less weight.
- However, this can be subjective and is usually backed by one of the above (cost/hours) as justification.
A good practice is to determine weights during project planning. Many organizations set up a Progress Measurement System table. For example, an Engineering PMS might list all document types (drawings, calculations, specs) each with a certain number of points such that total engineering points sum to 100 (or 1000). Similarly, a Procurement PMS might break each purchase order into steps like Requisition, Technical Bid Evaluation, Purchase Order, Manufacturing, Delivery, each step given a percentage of the PO’s weight (ensuring the steps add to 100% per PO). A Construction PMS often defines progress measurement by quantities installed and uses a “rule of credit” for partially completed elements (e.g. credit 50% when an equipment is installed, additional 30% when aligned and grouted, final 20% when pre-commissioned, etc.).
For instance, each discipline (civil, piping, electrical, etc.) has deliverables weighted such that within that discipline, progress can be calculated. In engineering, “progress is based on the number of deliverables issued” with each deliverable type carrying a portion of the weight. In procurement, typically “units of ‘each’ are used for every purchase order… broken down into steps and weights”, meaning each PO is treated as 100% and milestones like PO placement, manufacturing, delivery are assigned a percent each. For construction, while activities might be resource-loaded by man-hours, “progress is usually by units or quantities installed”, and the key is to design a balanced weighting system (avoiding front-end loading where too much credit is given early).
Earning progress
Once weights are set, tracking progress means determining how much of each weight has been earned at any point. Each deliverable or activity will earn its weight when completed, or sometimes in incremental milestones (e.g. earn 60% of the weight on document submission, remaining 40% on document approval). In a pure 0/100 method, nothing is earned until the item is finished, to ensure no overestimation of partially done work. But often a rule-of-credit method is used: assign fixed percentages for intermediate steps. For example, for a piece of equipment installation: 20% credit when the foundation is done, 50% when equipment is installed, 20% after alignment, 10% after testing – totaling 100% for that equipment. This way, progress accumulates as work proceeds, not just at the end.
Once each lowest-level element’s progress is determined (either 0% not done, 100% done, or some partial credit based on milestones or percentage of quantity installed), the roll-up is straightforward: Overall Progress % = (Earned Weight / Total Weight) × 100. The earned weight is the sum of weights of all completed work (or partially completed, if partial credit given). This approach mirrors Earned Value (where Earned Value (EV) is essentially the earned weight in budget terms, and Budget at Completion (BAC) is the total weight in budget terms).
For integration across disciplines, it’s common to maintain separate progress for Engineering, Procurement, and Construction, then combine them (often with their own weight splits). For example, the project might assign overall weight 20% to Engineering, 15% to Procurement, 65% to Construction. Within Construction, further breakdown by trade or area sums to that 65%. This hierarchy ensures at every level, progress can be reported (discipline-wise and overall). Earned Value Management guidelines encourage using physical percent complete for each activity in scheduling tools like Primavera, with an assigned “weight” or budget to each activity so that the software calculates overall % complete properly. In fact, on a construction activity, “Progress will be calculated based on % of quantities executed / total budget quantities… The assigned weight on construction activities is updated to reflect the recorded physical progress.”.
Risk analysis and forecasting

Monte Carlo and historical data
A proactive dashboard not only displays current progress but also integrates risk analysis to forecast potential outcomes. Project controls specialists increasingly use techniques like Monte Carlo simulation and historical data analysis to predict schedule and cost risks. Incorporating these into a dashboard elevates it to a decision-support tool that can answer “Where might we end up?” with statistical rigor.
Monte Carlo Simulation
- This method runs a project model thousands of times with varying inputs (like activity durations or costs) to produce a distribution of possible finish dates or costs.
- It’s considered a best practice for schedule risk analysis – PMI recommends Monte Carlo especially for complex projects with multiple parallel paths, as PERT analysis falls short in those cases.
- A well-designed dashboard can include results of Monte Carlo simulations performed on the schedule.
- For instance, after feeding in uncertainty ranges for each critical activity, the simulation might reveal there’s only a 60% chance to meet the current deadline, with a P90 (90% probability) completion date 3 weeks later than the deterministic date.
- The dashboard could show: “Schedule Confidence: 60% for finishing by June 30. P90 finish: July 21.” Similarly, for cost, it could indicate a contingency needed for certain confidence levels.
- In practice, tools like Bruo Matei’s Brumata, Oracle Primavera Risk Analysis, @Risk, or Safran Risk are used to perform these simulations and produce outputs which can be fed into Power BI or similar visualization tools.
- Key risk metrics like confidence level, P-factor, critical risk drivers can be summarized.
- Buro Matei’s dashboards support this by allowing integration of risk data – for example, their approach would include an SRA report with schedule confidence level as part of the baseline package.
- This turns the dashboard into a forward-looking radar, not just a rear-view mirror.
- It helps answer questions like “What is the probability of on-time completion?” or “What’s the worst-case if certain risks occur?” and thus prompts early mitigation (which can also be tracked on the dashboard’s risk register section).
Historical data for forecasting
- Another powerful asset is using past performance data to predict future performance.
- Historical data can come from earlier phases of the same project or from similar projects the company has done.
- For example, if historically the design of a certain type of facility had a productivity of X drawings per week, and currently the project is performing at 0.8X, one might forecast that unless something changes, design will complete later than planned.
- Machine learning can be applied to large historical datasets to find patterns and make predictions (this edges into cognitive analytics).
- On a simpler level, trending of performance indices is common: e.g. track the Schedule Performance Index (SPI) or productivity rates over time; if SPI is steadily declining each week, the dashboard could extrapolate that trend to estimate the likely SPI in coming weeks, thus estimating a completion date.
- Earned value provides formulas for Estimate At Completion (EAC) based on past CPI or schedule forecasts based on SPI (as shown in the fence example).
- The dashboard can offer multiple forecast scenarios: e.g. EAC using CPI=0.89 (assuming current efficiency continues) vs EAC using CPI & SPI combined or even a manual forecast from project teams.
Risk-adjusted forecasting
- Importantly, risk-adjusted forecasting can combine Monte Carlo results with deterministic trends.
- For instance, using historical data to calibrate the risk model itself (if, say, tasks typically have a certain variability based on past projects).
- Buro Matei’s philosophy of “data-driven project execution” suggests leveraging such historical insights – one of their aims is to embed historical knowledge into current project tools.
- A dashboard could, for example, include a benchmark productivity vs actual chart, or a historical range for a metric like “Engineering design usually completes in 6–8 months for projects of this size; currently we are trending to 9 months.”
- These insights give management an early warning if the project is deviating from norms.
Contingency
- Additionally, dashboards can incorporate risk registers and Monte Carlo on costs to forecast contingency usage.
- For cost, one might simulate the impact of risk events (like a risk of labor strike causing X week delay with Y cost) and see a distribution of possible cost at completion.
- The result may be an 80% confidence that the cost will not exceed, say, €105 million – which informs how much management reserve to keep.
- Presenting this in a digestible way (perhaps a simple tornado chart of top risk drivers or a cumulative probability curve for cost) equips decision-makers to allocate resources wisely.
In summary, weaving risk analysis into daily dashboards means that project controls specialists and leaders are not blindsided. They can see probabilities and not just single-point estimates. A culture of using Monte Carlo analysis and referencing historical performance has been shown to improve project predictability. It shifts conversations from “Are we on track today?” to “Are we likely to hit our targets, and what can we do now to improve those odds?” With the dashboard continuously updated, any change in risk status or performance triggers an updated forecast – keeping everyone informed in near-real-time about the projected outcomes.
Traditional tools vs. modern dashboards
How are these functions handled traditionally, and what makes Buro Matei’s approach different? Let’s contrast the conventional project controls toolkit (often Primavera P6, Excel, and static reports) with a modern integrated dashboard approach (Brumata + Power BI).
Traditional Approach
Primavera P6 Schedules

- Primavera P6 is the de facto scheduling tool for large EPC projects.
- Planners use it to develop detailed CPM schedules with thousands of activities.
- P6 can store a wealth of data (start/finish dates, activity codes, resources, costs, relationships, etc.), and it does have features to record progress (via percent completes, resource units, etc.).
- However, P6 itself is not very accessible to most team members – typically only a few planners access the software, and others see the schedule via exported PDFs or printed Gantt charts.
- Updating P6 is often a periodic batch process (weekly or biweekly updates). While P6 can generate reports (tabular or S-curves), they are not interactive and usually require manual compilation.
- Many project controllers export P6 data to Excel to create custom graphs.
- So, while P6 holds the schedule data, it doesn’t inherently provide an executive-friendly dashboard.
- Another limitation is that P6 doesn’t integrate well with other data like procurement or cost without custom coding or add-ons, making it hard to get a unified view.
- In practice, P6 is powerful for planning, but project status reporting still ends up being a manual exercise of pulling data from P6 and other sources into presentations.
Excel

- Excel spreadsheets are ubiquitous in project controls.
- Teams track everything from engineering deliverable lists, procurement status logs, to construction progress in Excel files.
- These might be shared via email or SharePoint.
- While flexible, Excel trackers are error-prone (typos, broken formulas), often not linked together, and updated by different people at different cadences.
- Collating them for a meeting can be a scramble.
- For example, engineering might maintain an Excel with all drawings and their progress, procurement with one for POs, etc., and a controls engineer manually merges key figures for a status report.
- This approach is labor-intensive and not scalable.
- It’s easy to see why “manual, error-prone systems hinder productivity and increase rework” – if someone forgets to update an Excel or uses an outdated revision, reports can be wrong.
- Moreover, Excel data usually lacks real-time connectivity; one has to open and refresh files.
- There’s also the issue of version control: multiple copies of reports and data may float around.
Project Reports

- Traditionally, progress info is communicated via project status reports – often lengthy Word documents or PowerPoint presentations generated at set intervals.
- These include narrative sections (accomplishments, issues, actions), data tables, and graphs (progress curves, histograms).
- A lot of effort goes into formatting these, and by the time they are issued (say a few days after period-end), the data may already be somewhat old.
- Executive overviews similarly might be a PowerPoint slide with key KPIs and traffic lights (red/yellow/green status).
- These are great for snapshot in time, but they are static. If an executive has a question (e.g. “Why is mechanical progress red this month?”), they have to ask the team and wait for analysis – the report itself can’t be queried.
- Also, these reports are often very high-level; the backup data resides in separate attachments or systems.
Primavera P6 + Excel + PDF workflow example

- A typical scenario might be
- Each discipline lead updates an Excel tracker for progress
- The planner updates P6 activities’ % complete accordingly (or vice versa, using P6 as the primary and Excel as a check)
- Cost engineers get cost data from SAP and do EVM calculations in Excel
- Then the project controls manager compiles a PowerPoint with charts (maybe copy-pasting from Excel charts), writes an analysis, and circulates as a PDF.
- This could be weekly or monthly.
- By the time issues are identified in this cycle, a week or more might have passed.
- Also, the data integration is done in people’s heads or via Excel, which is not robust.
Modern Dashboards
Buro Matei’s Brumata approach

Centralized data platform (Brumata)
- Instead of scattered Excel files and disparate systems, Brumata provides a central cloud database where all project data is logged and managed.
- It’s built on Microsoft Dataverse, meaning it’s a structured, relational database that can enforce data consistency and business rules.
- Engineers, buyers, and field staff can input or validate data through model-driven apps (friendly interfaces) that feed this database.
- This ensures data quality (no conflicting data sources) and that everything is up-to-date.
- Brumata also implements advanced data standards (like CFIHOS for tagging and LOD for deliverables) so that data from different domains fits together logically.
- Essentially, it is the single source of truth – a concept vital for avoiding confusion.
- With this in place, all the dashboard has to do is read from this central source to reflect reality.
Power BI Dashboards
- Power BI is used as the front-end to create interactive dashboards and reports.
- The connection to Brumata (Dataverse) means that whenever data is updated in the platform, the Power BI visuals update (often on a scheduled refresh or even in real-time for certain data).
- Users can access these dashboards via a web browser.
- Unlike static PDFs, they can click filters (e.g. select a specific contractor or a WBS to see focused data) and drill down into details.
- For example, an executive could filter the dashboard to see progress in a particular plant area, or a certain subcontractor’s performance, instantly.
- The visual nature of Power BI also allows combining charts, tables, and even 3D model snapshots on one screen.
- Visual status tracking like traffic-light indicators and progress bars are built-in.
- Another advantage is self-service analytics – Buro Matei designs dashboards with the idea that teams can investigate anomalies themselves.
- If a data point looks off, the user can often click to see the underlying data (for instance, a list of activities that are driving the delay).
- This reduces the back-and-forth where an executive asks a question and the team goes offline to research it; instead, the answer is usually a click away on the dashboard.
Automation and frequency
- The new approach allows updates daily or even more frequently with minimal human effort.
- Data flows are automated (e.g. pulling from P6 via API or ODBC, syncing from SharePoint lists, etc.), so the dashboard could refresh every morning.
- Buro Matei recounts that after implementing live dashboards, they saw “immediate results: reduced rework, improved communication, and significant time savings”.
- Essentially, automation freed engineers from clerical tasks (like manually preparing reports) so they could focus on actual engineering.
- The mindset shift is that reporting is no longer an event, but a continuous process.
- It’s not about making a pretty PDF each month; it’s about ensuring the data is always current and accessible.
- This is a form of digital transformation in project management – moving from document-centric updates to data-centric, continuous updates.
Actionable insights and transparency
- A critical difference with Buro Matei’s approach is the emphasis on insights and actions.
- The dashboards aren’t just passive displays; they are designed to highlight bottlenecks and prompt action.
- For example, an “Issues & Delays” section of a dashboard might automatically list critical activities that slipped or materials that are overdue, and flag responsible parties.
- Everyone can see this, including leadership, which creates accountability.
- This level of transparency may be uncomfortable in traditionally siloed organizations, but it drives problems to the surface.
- Buro Matei supports leadership in adopting these data-driven methods by emphasizing transparency and even helping shift the culture to embrace it.
- When the data is open and drillable, “every stakeholder—whether field engineers or executives—[is empowered] to act on insights that improve productivity and outcomes.”.
- Compare this to old reports, where maybe only the project manager had the full detail and others saw a summarized picture.
- Now, a construction superintendent could log into the dashboard and see that, say, a design deliverable he needs is 2 weeks late, and he can call engineering directly – he doesn’t have to find out in a meeting a month later.
Collaboration and workstreams
- The Brumata platform isn’t just a passive database; it also includes workflow features and collaboration tools.
- For example, it might notify a buyer when an engineering document is approved so they can proceed with procurement – and this status change reflects on the dashboard.
- This integration of workflow means that the act of managing the project (approving documents, updating progress, etc.) and the act of reporting are one and the same.
- Traditional approach separates the two (work happens in one set of tools, reporting in another).
- By blending them, any action taken is immediately visible.
- It’s a closed-loop system: data drives insights, which drive decisions, which update data.
- One concrete case: Instead of using separate emails or meetings to coordinate, teams use the platform’s comments or logs, so context is captured and available.
- If a package is blocked awaiting a decision, the dashboard can show it as “blocked” (perhaps highlighted in amber) until resolved – this is far more transparent than a footnote in a weekly report.
Overall, the difference lies in speed, depth, and user empowerment. Traditional methods produce a snapshot after significant lag and with limited detail at the top level. The modern dashboard approach gives an up-to-the-minute, detailed, and interactive view that anyone can explore. It reduces the reliance on manual labor for reporting and the risk of human error. It also encourages a proactive management style: teams can spot a negative trend on Tuesday and correct course by Wednesday, rather than discovering it at Friday’s report review and losing another week.
From a leadership perspective, having such live insights builds confidence. As a project controls specialist, being able to pull up any metric or answer any question with a few clicks in a meeting is extremely powerful. It shifts your role from report-generator to value-adding analyst and advisor. No wonder, then, that projects using integrated dashboards have reported faster decision cycles and better alignment. In one example, by implementing a unified platform, teams saw much clearer identification of what was “ready, blocked, or urgent” at any given time – which is exactly the situational awareness management needs to allocate resources effectively.
Conclusion
Driving reliable and predictable projects
Daily automated project dashboards are transforming how EPC projects are managed. By unifying engineering, procurement, and construction data onto a single page, updated daily, project controls professionals can provide leadership with unprecedented clarity and actionable insight. These dashboards encapsulate all critical metrics – from high-level progress and costs down to detailed issues – and leverage advanced analytics to not only describe and diagnose project performance, but also predict future outcomes and prescribe optimizations. In doing so, they align with international best practices like AWP for integrated planning, Earned Value Management for objective progress tracking, and Monte Carlo risk analysis for forecast confidence. The result is a transparent, proactive project environment where data is a common language for all stakeholders.
Buro Matei’s expertise in this arena shines through their Brumata platform and Power BI dashboards, which have demonstrated measurable improvements: reduced rework, accelerated schedules, and optimized team efficiency. By combining deep EPC domain knowledge with modern technology, they avoid the pitfalls of generic dashboard developers – their solutions are grounded in actual project workflows and pain points. As discussed, they address the very challenges many organizations face: real-time visibility, cross-discipline collaboration, and trust in data. The dashboards don’t merely present data; they drive a culture of accountability and continuous improvement, where every team member can see how their part contributes to the whole.
For project controls specialists reading this, the implication is clear: championing daily integrated dashboards can be a game-changer for project success. Instead of spending days each month assembling reports, you can invest time in analyzing and acting on the insights that the dashboard surface. You become an enabler of fast, informed decision-making – a strategic partner to project leadership. Moreover, when armed with a dashboard that executives can check anytime, the communication gap narrows. Leadership gains confidence because there is a single version of the truth, visible to all, and it’s updated continuously. Surprises are minimized because early warnings are plentiful and visible.
If your organization currently relies on P6 printouts, Excel sheets, and static reports, consider how much more agile and resilient it could be with a live dashboard that integrates everything. Think of the trust it builds when a project sponsor can, with a quick glance each morning, see accurate progress and any emerging risks, and know that the data is coming straight from the source systems without manual filtering. That trust extends to the project controls team – they are seen as forward-thinking and on top of the project.
In today’s fast-paced, complex projects, information lag and fragmentation are liabilities. The solution is at our fingertips: the technology to connect and visualize data has matured, and Buro Matei’s work is a testament to how it can be applied in EPC. It’s not an exaggeration to say that real-time integrated dashboards are becoming the new standard for project controls excellence. They embody the old adage “What gets measured gets managed”, updated for the digital age – except now we can measure and manage virtually everything, in real time.
By investing in such a system, you equip your project leadership with the insight to make timely decisions and the foresight to mitigate risks. This not only increases the chances of project success (on-time, on-budget delivery) but also instills a culture of openness and continuous learning. Projects can leapfrog outdated methods and embrace a data-driven execution model. In closing, as someone passionate about project controls, I encourage you to explore and advocate for these integrated dashboard solutions. The confidence and clarity they bring are invaluable – and as demonstrated, Buro Matei’s Brumata platform is leading the charge in this space, offering a proven way to turn complex, siloed data into clear, actionable intelligence. With such tools, you can redefine EPC project execution in your organization, delivering results that speak for themselves and earning the trust of all project stakeholders.