Google Sheets Reporting Dashboard Creation

I'm looking for a Google Sheets expert to create a reporting dashboard for me. The dashboard should feature charts, specifically a small vertical histogram (or similar).

Key Requirements:
- Design a dashboard with charts
- Implement automated data updates
- Use pivot tables and summaries for data organization

Ideal Skills and Experience:
- Proficiency in Google Sheets
- Experience in creating dashboards and charts
- Strong understanding of data automation and pivot tables

Please provide samples of similar work done.