1. Parse and clean the data
2. Embed as JSON in the dashboard

If working from a description without data:

1. Create a realistic sample dataset matching the described schema
2. Note in the dashboard that it uses sample data
3. Provide instructions for swapping in real data

3. Design the Dashboard Layout

Follow a standard dashboard layout pattern:

┌──────────────────────────────────────────────────┐
│  Dashboard Title                    [Filters ▼]  │
├────────────┬────────────┬────────────┬───────────┤
│  KPI Card  │  KPI Card  │  KPI Card  │ KPI Card  │
├────────────┴────────────┼────────────┴───────────┤
│                         │                        │
│    Primary Chart        │   Secondary Chart      │
│    (largest area)       │                        │
│                         │                        │
├─────────────────────────┴────────────────────────┤
│                                                  │
│    Detail Table (sortable, scrollable)           │
│                                                  │
└──────────────────────────────────────────────────┘

Adapt the layout to the content:

• 2-4 KPI cards at the top for headline numbers
• 1-3 charts in the middle section for trends and breakdowns
• Optional detail table at the bottom for drill-down data
• Filters in the header or sidebar depending on complexity

4. Build the HTML Dashboard

Generate a single self-contained HTML file using the base template below. The file includes:

Structure (HTML):

• Semantic HTML5 layout
• Responsive grid using CSS Grid or Flexbox
• Filter controls (dropdowns, date pickers, toggles)
• KPI cards with values and labels
• Chart containers
• Data table with sortable headers

Styling (CSS):

• Professional color scheme (clean whites, grays, with accent colors for data)
• Card-based layout with subtle shadows
• Consistent typography (system fonts for fast loading)
• Responsive design that works on different screen sizes
• Print-friendly styles

Interactivity (JavaScript):

• Chart.js for interactive charts (included via CDN)
• Filter dropdowns that update all charts and tables simultaneously
• Sortable table columns
• Hover tooltips on charts
• Number formatting (commas, currency, percentages)

Data (embedded JSON):

• All data embedded directly in the HTML as JavaScript variables
• No external data fetches required
• Dashboard works completely offline

5. Implement Chart Types

Use Chart.js for all charts. Common dashboard chart patterns:

• Line chart: Time series trends
• Bar chart: Category comparisons
• Doughnut chart: Composition (when <6 categories)
• Stacked bar: Composition over time
• Mixed (bar + line): Volume with rate overlay

Use the Chart.js integration patterns below for each chart type.

6. Add Interactivity

Use the filter and interactivity implementation patterns below for dropdown filters, date range filters, combined filter logic, sortable tables, and chart updates.

…

customer-research

围绕客户问题进行多来源调研与溯源，快速整理背景并支持准确回复。

fabriciq

用自然语言查询 Power BI 报表与仪表板，快速获得业务数据答案。