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.