Executive Sales Dashboard Development

EXECUTIVE SALES DASHBOARD *Title:* Executive Sales Dashboard - Interactive Performance Summary & Business Insights 1. Key Performance Indicators (KPIs) - Top Section - *Total Revenue:* $63,525.00 - *Total Profit:* $27,464.50 - *Units Sold:* 372 Units - *Profit Margin:* 43.2% 2. Regional Sales Breakdown (Table + Bar Chart) - *East Region:* Profit $5,680.00 | Sales Revenue $12,800.00 | Units 98 - *North Region:* Profit $5,187.00 | Sales Revenue $13,140.00 | Units 26 - *South Region:* Profit $6,915.00 | Sales Revenue $17,730.00 | Units 82 - *Highest Revenue* - *West Region:* Profit $3,525.00 | Sales Revenue $6,900.00 | Units 53 - *Lowest Revenue* - *Grand Total (for this table):* Profit $21,307.00 | Revenue $50,570.00 | Units 259 *Insight from Bar Chart (Revenue by Region):* South region is performing best, followed by North, East, and West is lowest. 3. Category Breakdown (Table + Pie Chart) - *Electronics:* Revenue $36,325.00 | Share 57.2% - *Majority contributor* - *Clothing:* Revenue $13,140.00 | Share 20.7% - *Home & Kitchen:* Revenue $14,060.00 | Share 22.1% *Insight from Pie Chart (Revenue Share by Category):* - Electronics dominates with 57% of total revenue - Home & Kitchen is 22% - Clothing is 21% 4. Overall Business Insights in Bullet Points: - Total business generated $63.5k revenue with 43.2% profit margin which is healthy. - Electronics category is the main driver of business (more than half revenue). - South region is the most profitable region in terms of both profit and revenue. - West region needs attention - lowest sales and profit. - Average selling price is high in North region (less units but good revenue).