Development of "Country Report Risk Warning" Dashboard

Employee Count

Definition: Ensure that the total number of employees includes offshore crew members. Display: Add a tooltip or info icon near employee metrics to clarify this inclusion. Effective Tax Rates (ETRs)

CbCR ETR Numerator: Exclude amounts for deferred income tax or other uncertain tax items. Pillar 2 Transitional Safe Harbor ETR Numerator: Include amounts for both deferred income tax and uncertain tax items. Clarification: Provide explanatory footnotes or pop-ups for users when they hover over related metrics. Geographic Heat Map Enhancements

Red Dots for Capitals:

Represent each country with a red dot at the capital's location. Adjust the size of the dots to indicate the total number of occurrences of warning indicators. Interactive Features:

Clicking on a red dot for a specific country triggers: Right-Side Table Update: Display detailed statistics for all companies within that jurisdiction, broken down by individual indicators. Highlight the country on the map for better visibility. Interactive Table (Right Panel)

Details to Include: Company Name Indicator Name Number of Occurrences Severity Level Sort and Filter Options: Allow sorting by company name, indicator type, or occurrence count. UI/UX Adjustments

Map Legends: Add a legend for red dot sizes to indicate warning frequency ranges (e.g., small = few, large = many). Tooltips: Display warning details when hovering over red dots on the map. Data Integration

Sources: Pull employee count and tax rate data from TRS_FACT_COUNTRY_REPORT and relevant tax reporting databases. Integrate risk indicator frequency data for the heat map visualization. Performance and Accessibility

Optimize map loading speeds for smooth interaction. Ensure drill-down features and data visualization are intuitive and responsive across devices.

timmochou / CFC-MODEL

Development of "Country Report Risk Warning" Dashboard #8