Team Productivity Tracker Dashboard in Google Sheets

I'm looking for an expert who can develop a Dashboard using Google Sheets to track my team's productivity. The dashboard should be able to integrate data from two sources: the weekly in-out punching report and Jira logs.

Key features and requirements:
- The Dashboard should primarily track the time every individual has spent in a week or month.
- It should be able to break down this time into specific categories such as time spent on projects, billable and non-billable hours.
- Data visualization is crucial: I prefer the use of Bar Charts to represent the data.
- There should also be a functionality for manual data entry or corrections, specifically for adding notes or comments.

Ideal skills and experience required:
- Proficiency in Google Sheets, including advanced functions and data visualization techniques.
- Experience in developing productivity tracking systems or dashboards.
- Familiarity with integrating and managing data from different sources.
- Strong attention to detail to ensure accurate and user-friendly data representation.
- Explain How does it work and how to use the Dashboard.