Advanced Excel Interactive Dashboard
Budget: ₹600 – ₹1,500 INR
I will hand you an Excel workbook that contains both the raw dataset and a list of business questions. Your task is to transform that file into a single-file, fully interactive dashboard driven by PivotTables and slicers.
The dashboard must support advanced interaction: multiple slicers working in tandem, drill-downs from high-level KPIs to detailed views, and seamless cross-filtering between components. Alongside the visual summaries—dynamic bar/line charts, column charts, and other meaningful graphs—include well-formatted PivotTables that update automatically with each filter change.
I have no fixed branding rules, so feel free to choose a clean, professional colour palette that keeps the focus on readability and insight. The workbook should refresh gracefully when I paste in updated data, with no broken links or manual tweaks. A brief “how-to-refresh” note inside the file is all I need for handover.
Deliverable: the finalized Excel file containing the dashboard, underlying PivotTables, slicers, and any supporting calculations, ready for immediate use.
The dashboard must support advanced interaction: multiple slicers working in tandem, drill-downs from high-level KPIs to detailed views, and seamless cross-filtering between components. Alongside the visual summaries—dynamic bar/line charts, column charts, and other meaningful graphs—include well-formatted PivotTables that update automatically with each filter change.
I have no fixed branding rules, so feel free to choose a clean, professional colour palette that keeps the focus on readability and insight. The workbook should refresh gracefully when I paste in updated data, with no broken links or manual tweaks. A brief “how-to-refresh” note inside the file is all I need for handover.
Deliverable: the finalized Excel file containing the dashboard, underlying PivotTables, slicers, and any supporting calculations, ready for immediate use.