Create your own #exceldashboard or #googledashboard using the below tutorial.
Learn how to use QUERY function with drop down validation lists to get dynamically filterer results of of a data-set in Google Sheets.