A portfolio-scale view of flood control progress, budget utilization, risk reduction, timelines, and contractor performance.
Summary
This dashboard provides an executive-level view of a simulated DPWH Flood Control Project portfolio, covering 320+ projects nationwide. Built as the final requirement for the Power BI Training workshop with Excelhelpline Analytics PH using a synthetic dataset, it consolidates project progress, budget utilization, flood risk reduction, contractor performance, and scheduling into a single interactive report spanning seven pages.
Decision-makers can filter the full dashboard by Project Status, Location, and Contractor to surface the metrics that matter most, from budget efficiency and completion rates to which regions carry the highest flood risk and which contractors are delivering results. The result is a live, at-a-glance tool for tracking whether public infrastructure spending is translating into measurable flood mitigation outcomes.
Problem Statement
Government infrastructure agencies like DPWH often manage hundreds of concurrent projects, with data on budgets, timelines, contractor performance, and risk levels scattered across disconnected spreadsheets. This fragmentation makes it difficult for stakeholders to answer basic but critical questions in real time: Which projects are behind schedule? Where is the budget being over- or under-utilized? Which regions remain at high risk despite completed interventions? How are individual contractors performing across their portfolios?
This project simulates that scenario using a synthetic dataset modeled on a DPWH Flood Control Project portfolio (320+ projects), built as the final requirement for a Power BI Training workshop with Excelhelpline Analytics PH. The goal was to design an interactive Power BI dashboard that unifies project, budget, timeline, flood risk, and contractor data into a single connected data model, enabling stakeholders to filter, drill down, and monitor project performance across a full portfolio in real time, rather than relying on static, siloed reports.
Note: built on a synthetic dataset for training purposes.
Inside the report
What it answers: "What does the entire portfolio look like at a glance?"
Shows headline totals: Total Projects, Total Allocated Budget, and High Risk Project Sites, alongside bar charts breaking down project count and budget by Region and by Contractor. Start here to get oriented before drilling into any specific dimension on the following pages.
What it answers: "What are all 320 projects, individually, and where do they stand?"
A searchable, filterable table listing every project with project ID, name, type, location, cost, funding source, percentage completion, start and end dates, paired with a bar chart of project count by province and a pie chart of status breakdown. This is the detail and reference page for looking up or auditing a specific project.
What it answers: "Are we spending within budget, and where is the money going?"
Cards summarize Total Allocated Budget, Total Expense, and Remaining Balance, with a Budget Utilization Rate showing spend efficiency. A table breaks down allocation versus utilization per project, a bar chart compares actual expense against remaining balance per project, and a narrative Budget Insight Text Card auto-summarizes the picture as filters change. A Fiscal Year slicer lets you isolate a specific year's spending.
What it answers: "Which projects are on schedule, which are delayed, and why?"
A Gantt chart visualizes each project's actual start-to-end schedule and flags Delay Status as On Track or Delayed. A supporting table lists exact delay days per project, and a bar chart ranks the most common Reasons for Delay by average days lost, useful for spotting systemic bottlenecks such as procurement, weather, or permitting. A Timeline Insight Text card summarizes schedule health narratively.
What it answers: "Are these projects actually reducing flood risk?"
Compares pre- versus post-project risk level per barangay or project, alongside Flood Incidents Before versus After and an Average Flood Incident Reduction Rate by region. A scatter chart cross-references rainfall intensity against post-project incidents to test whether risk reduction holds up under heavier rainfall. This is the page that most directly answers the "did this work?" question.
What it answers: "Which contractors are performing well, and who's handling what?"
A table lists each contractor's assigned region, total contract value, and performance rating, with a bar chart of projects handled per contractor and a scatter chart plotting performance rating against contract value and workload. This helps identify contractors who are over-extended versus efficient.
What it answers: "In one glance, how healthy is the whole program right now?"
The executive summary page shows Completion Rate, Risk Reduction Rate, and Budget Utilization Rate, plus a scatter chart plotting all three together by Region. A dynamic KPI Insight Text card ties it all into a single auto-generated sentence, providing the fastest way to read the state of the portfolio without opening any other page.
How to use the report
Every page shares the same three slicers: Project Status, Region, and Contractor, positioned in the top-left corner. Any selection carries across pages as you navigate, keeping the context consistent from the overview through the detail pages.
The suggested flow is Overview and KPI for the two big-picture pages, then Project List, Budget, Timeline, Flood Risk, and Contractor as the detail pages for drilling into a specific concern.
The build
| Tool | Usage |
|---|---|
| Power BI Desktop | Dashboard design, seven-page report layout, snowflake data model, relationships, slicers, and interactivity |
| DAX | KPI, budget, risk, timeline, and contractor measures; dynamic insight text cards; completion, utilization, and reduction rate calculations |
| Power Query (M) | Data cleaning, Barangay label cleanup, unpivoting Flood_Risk_Data into the Flood_Risk_Comparison reference table |
| Excel | Source workbook containing Project_List, Budget_Allocation, Project_Timeline, Flood_Risk_Data, Contractor_Info, and KPI_Summary sheets |
| Gantt Chart (Microsoft AppSource Visual) | Timeline page visualizing project schedules with on-track and delayed status |
Data disclosure
This dashboard was built on a synthetic dataset for training purposes. The project portfolio, budget figures, timelines, flood risk measures, contractor information, and KPI results are simulated for demonstration and do not represent actual DPWH project records or official performance data.
Interactive report
Have a dataset, dashboard, or business question that needs a clearer answer?