Revision Request

The data model includes measures and views related to various currency amounts, such as Origin, Requested, Review, Reserved, Taken Unreserved, Taken non-ventilated, and Extension amounts converted to reporting currency. Views cover revision request tracking, rejection, department categorization, approval time calculation, status trends over time, and the latest submissions. It facilitates analyzing and monitoring revision request processes alongside currency dynamics and conversions efficiently.

Benefits of This Data Model

• Enhanced Revision Request Tracking: Enables tracking all revision requests requiring follow-up action, aiding in proactive management of revision processes.
• Efficient Rejection Analysis: Facilitates in-depth analysis of revision requests that were rejected by stakeholders, identifying patterns and reasons for rejections.
• Department-Based Request Categorization: Allows categorizing revision requests based on the department making the request, providing insights into department-specific trends and needs.
• Trend Analysis Over Time: Provides a comprehensive view of revision request status changes over time, assisting in identifying long-term patterns and areas for improvement.
• Real-Time Monitoring of Latest Submissions: Offers visibility into the most recent revision requests submitted for review, enabling timely decision-making and action.

Key Performance Indicators (KPIs)

• Origin Currency Amount: The original amount in the currency in which the request was initiated.
• Origin Amount in Reporting Currency: The original amount converted to the reporting currency.
• Request Currency Amount: The amount requested in the currency specified.
• Requested Amount in Reporting Currency: The requested amount converted to the reporting currency.
• Review Currency Amount: The amount under review in the specified currency.
• Review Amount in Reporting Currency: The amount under review converted to the reporting currency.
• Reserved Currency Amount: The amount reserved in the specified currency.
• Taken Unreserved Amount in Reporting Currency: The unreserved amount taken converted to the reporting currency.
• Taken non-ventilated Currency Amount: The non-ventilated amount taken in the specified currency.
• Taken non-ventilated Amount in Reporting Currency: The non-ventilated amount taken converted to the reporting currency.
• Extension Currency Amount: The amount of extension in the specified currency.
• Extension Amount in Reporting Currency: The amount of extension converted to the reporting currency.

Available Visualizations

View Name	Description
Follow-up Requests for Revision	View tracking all revision requests requiring follow-up action.
Rejected Revision Requests	View displaying all revision requests that were rejected by stakeholders.
Average Time to Approve Revisions	View calculating the average time taken to approve revision requests.
Revision Requests by Department	View categorizing revision requests based on the department making the request.
Revision Request Status Over Time	View showing the trend of revision request status changes over time.
Latest Revision Requests	View presenting the most recent revision requests submitted for review.