REQUIREMENTS TRACEABILITY MATRIX (RTM)
Project: US Energy Market Performance Analytics
|
Version |
Author |
Date |
Status |
|
1.0 |
Priyanka Chaudhari |
2024-Q1 |
Approved |
Maps each Business Objective to its Functional Requirements, deliverables, test cases, and completion status. Ensures 100% traceability from business need to implemented solution.
TRACEABILITY MATRIX
|
BRD Ref |
Business Objective |
FRD Ref |
Deliverable |
Test Case |
Status |
|
BO-01 |
Source performance comparison |
FR-SQL-02 FR-XL-02 |
energy_analysis.sql (Q2) Energy_Market_Analytics.xlsx: Source Analysis |
TC-01: Revenue by source sums to portfolio total |
Complete |
|
BO-02 |
Renewable transition tracking |
FR-SQL-03 FR-SQL-10 FR-PBI-03 |
SQL Views Power BI Page 3 |
TC-02: Renewable % view returns Q1–Q4 for both years |
Complete |
|
BO-03 |
Outage risk quantification |
FR-SQL-06 FR-PBI-04 |
SQL Query 6 Power BI Page 4 with map |
TC-03: Outage cost = outage_hours * demand_mwh * 0.08 verified |
Complete |
|
BO-04 |
CO2 emissions for ESG |
FR-SQL-08 FR-SQL-10 |
SQL Query 8 (CO2 intensity) Renewable Tracker View |
TC-04: Coal CO2/GWh approx 820T; renewables = 0 |
Complete |
|
BO-05 |
Seasonal demand gap analysis |
FR-SQL-05 FR-XL-04 |
SQL Query 5 Excel: Seasonal Analysis tab |
TC-05: 4 quarters present; Q1/Q3 demand higher than Q2/Q4 |
Complete |
|
BO-06 |
Capital allocation recommendations |
FR-PBI-01 FR-PBI-02 |
Portfolio Overview page Source Performance page |
TC-06: All 4 recommendations addressable from dashboard filters |
Complete |
TEST CASES
|
Test ID |
Description |
Expected |
Pass/Fail |
|
TC-01 |
Revenue by source sums to total |
SUM(total_revenue_k) by source = overall SUM |
Pass |
|
TC-02 |
Renewable tracker view covers full period |
8 rows: 2 years × 4 quarters × Renewable/Non-Renewable |
Pass |
|
TC-03 |
Outage cost calculation is correct |
outage_cost_k = outage_hours × demand × 0.08 for all outage_flag=1 records |
Pass |
|
TC-04 |
CO2 rates match source type |
Solar/Wind/Hydro = 0; Coal highest; Nuclear ~0 |
Pass |
|
TC-05 |
Seasonal pattern present |
Q1 and Q3 avg_demand_mwh > Q2 and Q4 |
Pass |
|
TC-06 |
Dashboard recommendations navigable |
Filters can isolate Southwest region + Solar source in one click |
Pass |