## Phase 1 — Summary tab with dynamic totals

Role: you are an expert data analyst for [your company or project name].

Task:
1. Read the raw data in the sheet [name of the raw data sheet].
2. On a new tab called 'Data Engine', build a clean summary table that aggregates:
   - [main metric, e.g., total monthly revenue]
   - the top [number] [category, e.g., product subcategories] by performance
   - [second metric, e.g., regional sales]
3. Every calculation must rely on dynamic cell references, so that totals refresh on their own when the raw data changes.

Under the table, add a short note saying where each total comes from.

## Phase 2 — Charts and formatting

Start from the 'Data Engine' tab.

Task:
1. Create a [first chart type, e.g., bar chart] of [first metric, e.g., monthly revenue].
2. Create a [second chart type, e.g., donut chart] of the [number] best [category, e.g., traffic sources].
3. Put both charts, neatly arranged, on a new tab called 'Dashboard Layout'.
4. Color scheme: [color theme, e.g., minimalist high-contrast / clean corporate blue].
5. For a modern look, remove every chart border and all gridlines.
6. On the summary table, add conditional formatting that highlights the best-performing [category] in [color, e.g., soft green].

## Phase 3 — Pivot table and slicers

Now make the dashboard interactive.

Task:
1. Turn the summary data behind these charts into a Pivot Table.
2. On the 'Dashboard Layout' tab, add Excel Slicers for [first filter, e.g., Year], [second filter, e.g., Region] and [third filter, e.g., Client Status].
3. Connect the slicers to every chart, so one click updates them all.
4. Line the slicers up vertically, neatly, along the [left/right] side of the layout.