It would be helpful for school admins or principals to see ticket activity per school per week. Seeing data like how many tickets in total, ticket number per user, tickets that were resolved vs opened would be helpful for admins to see.
To do this, we should organize the data based on school first, so each school has their own delta table. To do this, we should do an initial ingest of data per school into their respective delta tables using a csv import to delta table transition.
- In the case where there is an update on an issue key, we would update the record data accordingly to replicate changes.
A power bi report should be then connected to each delta table and have visualizations that give key information like:
- How many tickets were created/resolved/in-progress
- How many tickets per user
- How many tickets per request type
- Average resolution time
- Tickets reopened
We then supplement the report with an automated power automate job that will convert the powerbi report into a pdf and send it via email to appropriate stakeholders.
After talking to the boss, we also wanted in the power bi report a link that points to a jira dashboard per school that will give them real-time ticket data.