Google Sheets Professional wanted for Data Dashboard

Looking for someone well versed with Google Sheets to support me with building a data dashboard. The data is already integrated in the Google Sheets, no need for external APIs or Google Apps Script.

Please include the solution to 2+4 in your letter to highlight yourself from bot applications.