Forum Discussion
Case Stydy with Sample Data
1.What do you forsee the reasons for the delay and how can you help expedite the report generation ?
2.What teams would you work with to reduce the latency of the data from 30 days down to <7days
3.What would the output be from the weekly tracker?
4.What KPIs would the business be interested?
5.What key fields would you expect from the dataset?
How do you create dashboard Please help me
I'm new to power bi
| Ticket ID | Subject | Status | Priority | Source | Agent | Created time | Due by Time | Resolved time | Closed time | Last update time | Initial response time | Time tracked | First response time (in hrs) | Resolution time (in hrs) | Customer interactions | Resolution status | First response status | Survey results |
| 1 | AC not working | Closed | Low | Suresh | 2021-04-01 01:19:51 | 2021-04-01 13:26:00 | 2021-04-06 15:52:30 | 2021-04-11 16:30:04 | 2021-04-11 16:30:04 | 00:00 | 00:00:00 | 64:52:30 | 1 | SLA Violated | ||||
| 2 | Fridge issue | Closed | Medium | Ramesh | 2021-04-01 04:16:56 | 2021-04-08 04:16:56 | 2021-04-01 04:18:58 | 2021-04-03 04:29:24 | 2021-04-03 04:29:24 | 2021-04-01 04:18:52 | 00:00 | 00:01:56 | 00:02:02 | 2 | Within SLA | Within SLA | ||
| 3 | Fan issue | Closed | High | Nisha | 2021-04-01 04:22:51 | 2021-04-11 04:23:19 | 2021-05-16 05:36:46 | 2021-05-18 06:29:25 | 2021-05-27 14:27:00 | 2021-04-01 04:31:40 | 00:00 | 00:08:49 | 1081:13:10 | 1 | SLA Violated | Within SLA | ||
| 4 | Mixer issue | Closed | Low | Raja | 2021-04-01 04:29:53 | 2021-04-01 16:29:53 | 2021-04-01 16:26:26 | 2021-04-03 16:29:41 | 2021-04-03 16:29:41 | 00:00 | 00:00:00 | 05:26:26 | 1 | Within SLA | ||||
| 5 | Charger Issue | Closed | Medium | AFG | 2021-04-01 04:49:55 | 2021-04-01 17:04:24 | 2021-04-01 14:21:03 | 2021-04-03 14:29:28 | 2021-04-03 14:29:28 | 00:00 | 00:00:00 | 03:21:03 | 1 | Within SLA | ||||
| 6 | Others | Closed | High | Portal | Suresh | 2021-04-01 04:55:08 | 2021-04-01 15:00:00 | 2021-04-01 11:44:09 | 2021-04-03 12:29:59 | 2021-04-03 12:29:59 | 00:00 | 00:00:00 | 00:44:09 | 1 | Within SLA | |||
| 7 | AC not working | Closed | Low | Phone | Ramesh | 2021-04-01 07:03:57 | 2021-04-02 07:03:57 | 2021-04-01 07:10:29 | 2021-04-03 07:29:24 | 2021-04-03 07:29:24 | 00:00 | 00:00:00 | 00:06:32 | 1 | Within SLA | |||
| 8 | Fridge issue | Closed | Medium | Nisha | 2021-04-01 08:59:55 | 2021-04-02 00:03:37 | 2021-04-06 18:04:15 | 2021-04-11 18:30:02 | 2021-04-17 14:56:45 | 00:00 | 00:00:00 | 67:04:15 | 1 | SLA Violated | ||||
| 9 | Fan issue | Closed | High | Portal | Raja | 2021-04-01 09:06:35 | 2021-04-01 13:47:33 | 2021-04-01 12:24:33 | 2021-04-03 12:29:59 | 2021-04-03 12:29:59 | 2021-04-01 11:46:32 | 00:00 | 00:46:32 | 01:24:33 | 1 | Within SLA | Within SLA | |
| 10 | Mixer issue | Closed | Low | Phone | AFG | 2021-04-01 09:43:34 | 2021-04-01 13:43:34 | 2021-04-01 09:43:41 | 2021-04-03 10:29:44 | 2021-04-03 10:29:44 | 00:00 | 00:00:00 | 00:00:07 | 1 | Within SLA |
1 Reply
Looks good. First thing would be to unpivot the data to make it usable.
What have you tried and where you are stuck?
