Requirement Document for Cable Performance Power BI Report

1. Introduction

The Cable Performance Power BI report is designed to provide insights into the performance, assessment, and mitigation efforts of electrical cables across various sites. This document outlines the functional and technical requirements for the Power BI report.

2. Objectives

• Evaluate the quality and performance of electrical cables.
• Identify substandard terminations, splices, and phases.
• Measure the success rate of mitigation efforts.
• Provide insights by site, contractor, and year.
• Track cable segment quality rating (CSQR) and site quality rating (SQR).
• Enable decision-making for maintenance and future improvements.

3. Data Sources The report utilizes data from:

• Cable assessments and testing data.
• Site owner and contractor performance records.
• Year-wise component performance.
• Cable manufacturers’ quality statistics.
• Historical mitigation performance.

4. Functional Requirements

• Performance Overview:
  • Display conductor miles, circuit miles, and cable length.
  • Breakdown of cables assessed, phases assessed, and mitigated cables.
• Quality Assessment:
  • Site Quality Rating (SQR) with passing percentage.
  • Cable Segment Quality Rating (CSQR) overview.
• Mitigation Analysis:
  • Percentage of cables mitigated and successfully mitigated.
• Component Analysis:
  • Identification of substandard terminations, splices, and phases.
  • Year-wise trends in component performance.
• Performance by Site & Contractor:
  • Insights into site-specific and contractor-specific performance.
  • Comparative analysis across different entities.
• Manufacturer Performance:
  • Cable manufacturers’ defect rates and testing results.
• Visualization & Reporting:
  • Bar charts, pie charts, and trend lines to present data effectively.
  • Drill-down functionality to explore data at different granularity levels.

5. Technical Requirements

• Power BI Platform:
  • Report to be hosted on Power BI Service.
  • Interactive dashboards and filters.
• Data Integration:
  • Connection to databases or CSV/Excel files.
  • Scheduled data refresh for up-to-date reporting.
• Security & Access Control:
  • Role-based access to ensure data confidentiality.
  • Secure sharing with authorized users.

6. Performance Metrics

• Accuracy: Data should be accurate with minimal discrepancies.
• Timeliness: Data refresh cycles should be scheduled appropriately.
• Usability: The report should be user-friendly and intuitive.

7. Project Completion Method The project will be completed using a combination of SQL Queries, Power Query, and DAX measures within Power BI.

• SQL Queries:
  • Extract and transform data from source databases.
  • Example Query:

SELECT SiteName, CableType, COUNT(*) AS CableCount, AVG(QualityScore) AS AvgQuality FROM CablePerformanceData WHERE Year >= 2015 GROUP BY SiteName, CableType;

• Power Query:
  • Perform data cleaning and transformations.
  • Merge datasets for comprehensive analysis.
  • Remove duplicates and handle missing values.
• DAX (Data Analysis Expressions):
  • Create calculated measures and columns.
  • Example Measure:

SuccessfulMitigationRate = DIVIDE( SUM(CableData[SuccessfullyMitigated]), SUM(CableData[TotalMitigated]), 0 )

• Report Design & Visualization:
  • Implement slicers for dynamic filtering.
  • Configure tooltips and drill-through options for in-depth analysis.

8. Conclusion This Power BI report is a comprehensive tool for monitoring and improving cable performance across various sites. By analyzing quality ratings, mitigation success, and component failures, stakeholders can make informed decisions to enhance operational efficiency