> ## Documentation Index
> Fetch the complete documentation index at: https://docs.qoder.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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

```plaintext theme={null}
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                           |