Excel Monthly Consumption Dashboard

I need a polished, interactive dashboard in power bi that lets me track monthly consumption while also comparing related expenditure and production figures. The raw data will come to you in simple spreadsheets; once I paste the latest month’s numbers, the dashboard should refresh automatically and update every chart, table, and KPI.

Here is what I expect:
• One interactive front-page that uses slicers or drop-downs so I can flip between different years, individual months, or the full year-to-date view.
• Dynamic charts and graphs for each metric—consumption, expenditure, and production—plus an at-a-glance section showing totals, variances from the previous month, and year-to-date figures.
• Supporting tables beneath or behind the visuals so I can drill down if required.
• A clean layout, clear color coding, and no hidden surprises in the formulas.

You are free to use Power Query, pivot tables, named ranges, or any other native Excel tools you like, as long as the final file remains a self-contained .xlsx without external add-ins. Hand over the finished workbook with a short, one-page guide that explains where to drop new data and how to refresh the views.

I’ll review by checking that:
1. All slicers and filters respond quickly without errors.
2. Monthly and yearly charts flip correctly when I change the selected period.
3. Totals in the visual layer match the raw data.

If that sounds clear, let’s get started—looking forward to seeing a dashboard that tells the whole story at a glance.