Hi,
I can build you a dashboard based on data in google sheet. If you have any sample format, I can do the same way. If you don’t have, I can create a dashboard that provides actionable insights. I am a business consultant and advising clients on data visualisation is part of my day job.
If you are looking for a drill down facility, I would suggest you to go with third party like Zoho analytics. If you are not willing to spend on those, You can chose Google data studio. I can build dashboard in any of these or google sheets. Ping me to discuss further.
Thank you. Looking forward to working together.