Interactive Sales & Inventory Excel Dashboard

Замовник: AI | Опубліковано: 06.03.2026

I want a single Excel file that lets me drop in fresh sales and purchase data and instantly see what’s happening in the business. The heart of the job is an interactive dashboard—clean, professional, and easy for anyone on my team to grasp at a glance. Here is what I need the file to do: • Automatically refresh whenever I upload a new data file, so no manual copy-pasting. • Display bar, line, and pie charts that highlight both sales trends and purchase trends. • Use pivot tables and slicers to let me drill down by product, date, or supplier without breaking the layout. • Track current inventory levels in real time, flagging low-stock items. • Surface the two KPIs I care about most—product-wise performance and overall revenue growth—right on the front page. Acceptance criteria • Uploading a new data sheet instantly updates every visual, table, and KPI without extra clicks. • All charts respond correctly to filters and slicers. • File opens with no macro or security warnings in the latest desktop version of Excel. • The layout remains readable when printed on A4 and when viewed on a laptop screen. Deliverable: the finished .xlsx dashboard with all formulas, pivot tables, and sample data in place so I can test the workflow end-to-end.