This interactive view offers a rich understanding of product performance. Key features include:

• Top 30 Products: A dedicated table showcases the top 30 product brands by total transactions, total profit, profit margin and return rate. This allows for quick identification of high-performing and potentially problematic product brands.

• Overall Product KPIs: Key performance indicators (KPIs) for all product brands are displayed prominently, providing a snapshot of the current month's transactions, profit and return. 

• Weekly Revenue Analysis: A bar chart tracks overall weekly revenue across a chosen time frame, helping identify trends and seasonality.

• Interactive Map: The size of each bubble on the map corresponds to the total number of transactions processed per store in each country, allowing for quick visual identification of high-volume markets. 

The underlying data model ensures efficient data interaction and fosters seamless analysis. It primarily leverages one-to-many relationships between lookup tables and data tables. This structure offers several advantages: 

• Centralized Reference Data: Lookup tables store static information like product categories or customer locations. This eliminates redundancy and simplifies data management.

• Scalability and Performance: One-to-many relationships optimize query performance and enable efficient retrieval of detailed data from transaction tables.

• Data Integrity: Foreign key constraints enforce data consistency by ensuring references in data tables always point to valid entries in lookup tables.