Integrated Cost Data Platform

challenge

Challenge 5

brief

Integrated Cost Data Platform delivered an end‑to‑end cost management architecture that migrates fragmented Excel‑based cost data into a structured PostgreSQL database and exposes a single, trusted cost model to Power BI for analysis across estimation and execution.

Please be aware that this content was generated follwing an automated review so may not be perfectly accurate; refer to the original challenge brief and team files for authoritative information

key outcomes

Expected to improve cost transparency and consistency, reduce manual reconciliation effort, and enable more reliable cost forecasting and variance analysis across the project lifecycle.

important files

• Submission/Solution/Scripts/0 README.md: Provides the full end‑to‑end workflow for migrating costing data into PostgreSQL and building Power BI reports.
• Submission/Solution/Scripts/00_create_target_schema.sql: Creates the target database schema for structured cost, WBS, P6 and SAP data.
• Submission/Solution/Scripts/08_power_bi_dax_measures.dax: Defines recommended DAX measures for cost reporting and analysis in Power BI.

details

team: Integrated Cost Data Platform members: tbc topics: solution-centre, hack25, challenge5, postgresql, sql, power-bi, dax, excel, cost-management, cost-forecasting, data-integration, project-controls, financial-performance, analytics technologies: PostgreSQL, SQL, Power BI, DAX, Excel