Interactive Excel Coffee Sales Dashboard

I need a dynamic sales dashboard built in Excel that helps me monitor my coffee business in real time. The finished file must pull data from both a set of Excel spreadsheets I provide and a small SQL-based database we currently use for inventory. Once connected, the dashboard should let me:

• Filter results by any custom date range
• Hover over charts or data points to reveal additional details (totals, percentages, underlying records)
• Click column headers to sort tables on the fly

Beyond wiring up those interactive elements, I’d like clean visuals—charts, trend lines, and summary cards—that instantly show how my different coffee products are performing without forcing me to dig through raw sheets.

Deliverables
• An .xlsx file with all queries, Power Query or VBA code, pivot tables, and interactive charts ready to refresh at a single click
• Clear setup notes so I can update data connections or tweak visuals later
• A short walkthrough (screenshare or recorded) showing how the date filter, hover tooltips, and sortable tables work

I will supply sample spreadsheets, the database connection string, and any credentials you need right after we start.