
Home / Data, automation and AI
Construction data you can trust, with fewer hours spent producing it
Power BI dashboards for projects, portfolios and BIM coordination, data analysis that finds root causes, Autodesk Construction Cloud set up properly, and tools in C# and Python that take repetitive work off your team.
Cumulative progress, planned against earned
Progress by zone, planned and actual (%)
Activities driving delay
| Activity | Float | Delay |
|---|---|---|
| Core walls L7 to L12 | 0d | 8d |
| Curtain wall L3 | 4d | 6d |
| Chiller delivery | 0d | 5d |
Power BI
Construction and project controls dashboards
Dashboards are the easy part. The work is the data model underneath, with one coding structure and measures that everyone agrees on. We build both, and you own both.
- Project and portfolio dashboards for progress, cost and earned value
- Data models and DAX measures documented for your team
- Scheduled refresh from Primavera P6, ACC and your cost systems
- Role-based views from executives to site engineers
- Row-level security so each team sees its own projects
Open clashes by week
Clashes by discipline, opened and open
BIM reporting
BIM and coordination dashboards
Coordination meetings move faster when everyone sees the same trend. We report open clashes, issues, RFIs and model health from ACC and Navisworks data, by discipline, level and week.
- Clash and issue trends by discipline, level and week
- Model health scores from our QA/QC checks
- RFI and submittal ageing from Autodesk Build
- Design review and approval status by package
- Exports for the client and consultant monthly reports
Data analysis
Data analysis and business analysis
Most projects already hold the data they need. It sits in P6 exports, cost sheets, site reports and model schedules that never meet. We clean it, join it and turn it into answers you can act on.
- Data audits for coding, completeness and duplicates
- Schedule and cost variance analysis with root causes
- Productivity and resource analysis from site records
- Trend analysis and forecasting for progress, cost and cash flow
- Business analysis: process maps, reporting requirements and KPI design
| Ref | Subject | Discipline | Status | Due |
|---|---|---|---|---|
| RFI-118 | Slab edge detail at L09 balcony | Structural | Open | 3 days |
| SUB-204 | Chiller shop drawings, rev B | Mechanical | In review | 6 days |
| ISS-331 | Fire damper access panel missing | MEP | Assigned | 2 days |
| RFI-112 | Curtain wall bracket spacing | Facade | Closed | Closed |
ACC
Autodesk Construction Cloud and Autodesk Build
A common data environment works when it is configured before the project fills it. We set up ACC to your standards, train your team and connect the data to reporting.
- Autodesk Docs folders, naming, permissions and approvals
- Autodesk Build RFIs, submittals, issues, forms and daily logs
- BIM Collaborate Pro and Model Coordination
- Autodesk Takeoff and Cost Management configuration
- ACC data connected to Power BI
// Revit add-in: find elements with no Activity ID before 4D linking [Transaction(TransactionMode.ReadOnly)] public class CheckActivityIds : IExternalCommand { public Result Execute(ExternalCommandData data, ref string message, ElementSet set) { Document doc = data.Application.ActiveUIDocument.Document; var missing = new FilteredElementCollector(doc) .WhereElementIsNotElementType() .Where(e => e.Category?.HasMaterialQuantities == true) .Where(e => string.IsNullOrEmpty(e.LookupParameter("Activity ID")?.AsString())) .ToList(); TaskDialog.Show("4D check", $"{missing.Count} elements have no Activity ID."); return Result.Succeeded; } }
C# and .NET
Revit add-ins and BIM automation
Repetitive model work belongs in software. We write Revit add-ins and scripts that check, fix and export, so your modellers spend their time on design and coordination.
- Revit API add-ins in C# and .NET
- Model QA/QC: parameters, naming, worksets and Activity IDs for 4D
- Batch exports, sheet automation and family management
- Dynamo and pyRevit scripts for quick wins
- Selective workset loading for large models
# Extract quantities by assembly code from a model on Autodesk Platform Services import requests, pandas as pd BASE = "https://developer.api.autodesk.com/modelderivative/v2/designdata" def properties(urn, guid, token): r = requests.get(f"{BASE}/{urn}/metadata/{guid}/properties", headers={"Authorization": f"Bearer {token}"}) r.raise_for_status() return r.json()["data"]["collection"] rows = [{"code": o["properties"].get("Identity Data", {}).get("Assembly Code"), "volume": o["properties"].get("Dimensions", {}).get("Volume")} for o in properties(URN, GUID, TOKEN)] pd.DataFrame(rows).groupby("code").sum(numeric_only=True).to_csv("quantities.csv")
Autodesk Platform Services
Python, APS and Power Platform automation
Autodesk Platform Services, formerly Forge, gives programs access to models and project data. We use it with Python and the Power Platform to extract, connect and report without manual exports.
- Model properties and quantities through the Model Derivative API
- Project data through the Data Management API
- ACC cost management automation with Power Apps
- Power Automate flows for approvals and notifications
- Scheduled reporting pipelines into Power BI
| Discipline | Overdue | Oldest |
|---|---|---|
| Structural | 6 | 19d |
| MEP | 5 | 12d |
| Facade | 3 | 8d |
Applied AI
AI-assisted workflows
Language models are useful in construction when they work on your records, show their sources and leave the decision to a person. We set them up that way, inside your data boundaries.
- Summaries of RFIs, submittals and meeting minutes
- Classification of documents and correspondence
- Data extraction from PDF schedules and bills of quantities
- Search across project records with cited sources
- A person reviews every output before it is used
Sample screens and models on this page use illustrative data prepared by Ascendix.
Software and standards
We work in your platforms and to your standards. Licensed software only.
- Power BI
- DAX and Power Query
- Power Automate
- Power Apps
- Autodesk Platform Services
- Model Derivative API
- Data Management API
- Revit API
- C# and .NET
- Python
- pandas
- Dynamo
- pyRevit
- Autodesk Construction Cloud
- Autodesk Build
- SQL
Questions we get asked
Something else? Ask us directly.
Who owns the dashboards and code you build?
You do. We hand over the files, the data model documentation and the source code.
Can you connect Primavera P6 and ACC data in one dashboard?
Yes, provided both use a shared coding structure. We set that up first if it does not exist.
What does a data analysis engagement produce?
A cleaned, joined dataset, the analysis with root causes, and the recommended changes, usually with a dashboard so the analysis can be repeated.
Do you use AI on our confidential data?
Only within the boundaries you approve, with sources shown and a person reviewing every output.

Send us a scope
A drawing list, a programme, an EIR or a short description is enough to start. We reply within two business days with questions or a fixed price.
Or email info@ascendixprojectsolutions.com or call +1 (571) 741-9558