This view shows:

• Top 10 Products: A dedicated table showcases the top 10 products by order quantity, revenue, and return rate. This allows for quick identification of high-performing and potentially problematic products.

• Overall Product KPIs: Key performance indicators (KPIs) for all products are displayed prominently, providing a snapshot of overall sales, order volume, and returns. 

• Order Distribution by Category: A bar chart visually depicts the number of orders by category, aiding in understanding product category trends.

• Monthly Trends: Line charts track monthly revenue, orders, and returns, enabling executives to monitor performance changes over time.

This interactive world map provides a comprehensive view of order distribution across different countries

• Filter by Continent: Easily focus on specific regions by filtering the map by continent.

• Bubble Size Reflects Order Volume: The size of each bubble on the map corresponds to the total number of orders placed in that country, allowing for quick visual identification of high-volume markets.

This view empowers users to analyze the performance of individual products with a granular level of detail. Key features include:

• Product Performance Metrics: Access key metrics such as number of orders, revenue, profit, returns, and return rate, offering a comprehensive understanding of a product's health.

• Goal Tracking with KPIs: Monitor progress towards sales and profitability targets with easy-to-read KPIs for monthly revenue, profit, and their respective targets.

• Profitability Analysis: A line chart visually compares total profit and adjusted profit, providing insights into potential cost factors affecting profitability.

This interactive view offers a rich understanding of your customer base. Key features include:

• Customer Segmentation: Analyze customer behaviour by income level and occupation with a clear donut chart, aiding in targeted marketing strategies.

• Revenue Analysis: A line chart tracks overall customer revenue or revenue per customer (selectable via slicer) across a chosen time frame, helping identify trends and seasonality.

• Customer Ranking: A dedicated card highlights the top customers by revenue, showcasing their order volume and revenue contribution.

• Detailed Customer List: A sortable table lists individual customer names, order counts, and revenues, allowing for deep dives into specific customer segments.

• Year-over-Year Comparison: Filter by year to compare customer performance across different periods.

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.