Business Intelligence
TMS

Excel-Native Data Model

Author project data by pasting rows into Excel worksheets, where typed codes resolve parent references, derivable cells fill in for review, and text identifiers keep their exact form.

Excel-Native Data Model

Define project custom fields with data types, option lists and required flags, fill in their values in a bulk editing worksheet, see them in the Gantt and Node Graph, and filter lenses by them.

Custom Fields

Add text or pick-list fields, flat or hierarchical, to projects, WBS, OBS, control accounts, work packages, resources, activities, and assignments, then group the Gantt and schedule network by them.

Custom Fields

Excel Bulk Editing

Open any set of custom fields as columns in an Excel table, fill, paste, sort, and filter as usual, then commit every change through the same validation as the editors.

Snapshot-Sourced Reporting

Generate analytics datasets and customer report packages for a chosen reporting period from saved snapshots, after a readiness check that names what must be fixed first.

Snapshot-Sourced Reporting

Numeric and Date Custom Fields

Roadmap

On the roadmap: number, currency, date and yes/no custom field types, so custom fields can carry project-specific measures as well as text and pick-list tags.

Direct Analytical Access

Roadmap

On the roadmap: direct workbook access to earned value, EAC and time-phased cost records, so analysts can build custom EAC checks, dashboards, and workbook models against live ProjectXL rows instead of exporting them first.

BI-Ready Export Packages

Roadmap

On the roadmap: schedule history, snapshot comparisons, and risk outputs exported in analysis-ready shapes, so downstream BI tools can use governed data without manual translation.

Preconfigured Power BI Semantic Model

Roadmap

On the roadmap: a companion Power BI model that starts teams with schedule health, schedule performance, and trend measures already mapped, while still leaving room for custom analytics.

home Home inventory_2 ProjectXL hub Services menu_book Knowledge Base info About forum Forum