How to turn a raw sales workbook into an interactive Excel dashboard

A Freelancer listing requests an Interactive Excel Sales Dashboard. The client already has a raw sales workbook spanning several months. Data fields mentioned: product names, regional breakdowns, quantities and revenue. The workbook "simply lacks the visual layer" that helps decision-makers spot trends quickly. The posted budget range is ₹750–₹1250 INR.

The brief indicates a single in-Excel dashboard — not a separate BI tool. The goal is clarity and interactivity so decision-makers can spot trends at a glance. The buyer's tag list identifies the skills they expect: Business Intelligence, Data Analysis, Data Entry, Data Management, Data Processing, Data Visualization, Excel and Visual Basic.

Concrete dashboard features to propose

• Data preparation: normalize columns into a single transactions table (date, product, region, quantity, revenue, other dimensions).

• Trend charts: time-series revenue and quantity with ability to change date ranges.
• Interactive controls: slicers and form controls or data-validation dropdowns to filter by product, region, and time window.
• Highlights: top products, top regions, and quick KPI cards (total revenue, total units, average order value).
• Drill paths: clickable pivots or buttons to view raw transactions behind summarized numbers.
• Optional automation: simple VBA to refresh data, protect/unprotect sheets, or export a PDF snapshot if the client accepts macros.

Questions to ask the buyer before starting

• Where is the raw data currently stored (single file, multiple sheets, external sources)?
• How frequently will data be updated (daily, weekly, monthly)?
• Which KPIs do decision-makers care about explicitly (revenue, quantity, margin, growth rates)?
• Do you want live formulas only, or are macros/VBA acceptable? Any company policy on macros?
• Any preferred chart types or corporate color palette to match? Do you need printable or exportable views?
• Required file format and compatibility (Excel desktop.xlsm/.xlsx, Excel for web limitations)?

A practical delivery plan and timeline

• Day 3: Build pivot tables, slicers/dropdowns, KPI cards, and charts.
• Day 4: Add optional VBA tasks (refresh, snapshot) and finalize cell protection and user instructions.
• Final: Deliver file, short usage notes, and a single revision round.

• A short checklist of deliverables you will provide (structured data table, dashboard sheet, supporting pivot/raw-data sheets, any macros).
• Clear statement on whether macros will be used and compatibility notes for Excel Online.
• Timeline and number of revisions included in the price.
• Sample screenshots or past dashboard thumbnails if available (attach separately on Freelancer).

The buyer's budget is modest (₹750–₹1250 INR). That budget fits a compact dashboard with standard charts and slicers. If the client requires extensive cleaning, multiple custom views, or complex VBA, propose tiers or a higher price option.

Lead with a brief audit: confirm you'll start by inspecting the workbook and listing required fields. Offer a short example KPI set and a clear small-scope deliverable that matches the posted budget. State compatibility and whether you'll include a brief usage guide. Be explicit about macro use so the buyer can accept or reject it.