I am looking for a professional experienced in data analysis and report generation using Google Sheets. I have around 20 technicians, each with their own salary file containing detailed information such as:
Job date
Customer name
Job number
Appointment booking details
Lead source
Appliance type (low-end, high-end, premium, residential, commercial)
Sales status (sold or not sold)
Profit and other job-related metrics
Each technician's file is organized by month (separate pages for each month). I need a skilled analyst who can consolidate this data across all months and technicians to create a comprehensive report, along with graphical representations of key statistics.
Tasks:
Data Consolidation: Create a page that compiles all jobs completed for each technician across all months.
Generate Statistics: From the consolidated data, produce statistics on:
The number of jobs and profit per appliance category (low-end, high-end, premium, residential, commercial).
Separate statistics for residential vs. commercial appliances.
Visualize key metrics like average profit per category, total jobs completed, etc.
Graphical Presentation: Use the data to create graphical visualizations (e.g., charts, graphs) similar to examples I have provided in my Google Sheets file.
Requirements:
Experience with Google Sheets (advanced functions, charts, pivot tables).
Strong analytical and data visualization skills.
Ability to work with multiple sheets and large datasets.
Clear communication, as further details will be discussed once we start working.
Additional Notes:
This is an initial project, but I plan to continue working with the right person for future reports, including marketing statistics and further technician performance analyses.
I have provided examples of the required graphs and statistics in the attached Google Sheets file for reference.
If you’re detail-oriented and have the skills to deliver insightful, graphical reports, I’d love to hear from you!
Here are the links to example sheets :
https://docs.google.com/spreadsheets/d/1_YjPqZrHFYd-yFtfdb_rVEfuyVdQFiig8srgJx89o7c/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1lA2VieVMHudyCPKfM4P6dkc3utBtn0R7hy4-1dm43Qo/edit?usp=sharing
Location: Anywhere
Posted: Oct. 16, 2024, 6:32 a.m.
Apply Now Company Website