Build an interactive dashboard that allows for drill-down various elements from my datasource. Ideally one that dynamically updates in response to a live data source, but if not possible/practical one that gets updated on a periodic basis.

I need to take the Smartsheets spreadsheet (can be exported to Excel) that I use to monitor my inspection business operations (~3,000 rows, 70 columns) and turn it into a dashboard that can drill-down based on a variety of criteria. I have not settled on a software solution to achieve this and am looking for advice and suggestions on the best way to implement, as well as the actual implementation. I would like to have widgets for a variety of KPI's and a simple way for modifying the dashboard going forward as my business priorities shift.