A quick look at using Dynamo for extracting key insights from your project related to departments, rooms, total square footage and the ratios within. Then using Power BI to understand visually what is happening in the project instead seeing numbers in Excel, use graphs and charts that are easier to understand.