The challenge

The client needed a portfolio dashboard fed from its planning workbook, but seven of the eight required per-project fields did not exist in that workbook.

What we built

We built six SharePoint web parts over five lists, with an executive summary, trend views, alerts, Excel bulk import and custom charts, in English and Arabic.

The missing fields became columns the business maintains, and re-importing the workbook updates a field only when the workbook supplies a value. Date filtering includes any project that overlaps the chosen period.

Outcome

Working. Until the business fills in the new fields, projects show as Not Started at 0% progress, which is expected and documented.

Have a similar challenge?

Tell us about it, and we will tell you how we would approach it.