This is, in miniature, what an operations dashboard does. It runs here, in the page — you can try it on your own data right now, with no sign-up and without talking to anyone.
A table of jobs, visits, orders or tickets — as you already keep it. You do not need to rename your columns: they are recognised by what is in them, not by what they are called, and you are told which ones were used.
Press „Use the sample data" to see what this is about.
Source:
What the numbers show
Volume, month by month
Count by category
Average time by category
Split by person
Here you upload a file every time. In a real dashboard the data arrives on its own — from SharePoint, from your invoicing software, or from the database — and the numbers refresh without anyone opening anything. On top of that: history kept month by month, permissions per person, filters, and the report emailed on the date you choose. What that is built with