Case 9: E-commerce Data Visualization

Pain Point

Sales data lives in separate Excel files by region. Merging and visualizing takes manual work. Getting a global view is slow.

After QoderWork

Merge US, EU, and global sales Excel files and generate an interactive HTML report.

Prompt Example

This folder has three Excel files: US sales, EU sales, global summary. Please:
1. Merge all three, standardize column names
2. Create an HTML report with:
   - Regional sales share (pie chart)
   - Monthly sales trends (line chart)
   - Top 10 products (bar chart)
   - Filters by region, month, category
3. Output as HTML that opens in a browser

Key Metrics

Metric	Result
Visualization	Direct charts from data, typical cross-region use
Interactivity	Dynamic filtering
Ease of use	HTML, no extra software