Google Sheets Process Log Revamp

I need a professional to help me overhaul a Google Sheets process log I'm using. The aim is to enhance user-friendliness, automate data entry and improve data analysis along with changing some of the formatting to fit new processes.

Key Requirements:
- Make the process log more user-friendly
- Automate data entry
- Improve data analysis capabilities

Data Analysis Expectations:
- Trend analysis
- Real-time reporting
- Summary statistics

Desired Features:
- Custom dashboards and reports

Ideal Skills:
- Expertise in Google Sheets
- Experience with data analysis
- Skills in creating custom dashboards and reports
- Knowledge of data validation and error checks
- Ability to integrate with other tools

I expect a professional who can deliver a comprehensive revamp of my process log, enhancing its usability and analytical capabilities.