mnikonov / gpt-labs

Welcome to GTP Labs, the ultimate application for unlocking the power of OpenAI's API for Windows.
Apache License 2.0
37 stars 12 forks source link

Power Bi Visualization #49

Open suchit5837 opened 9 months ago

suchit5837 commented 9 months ago
  1. A separate sheet with a chart view of average monthly Cases / HC / month over time (last 12 months) a. Total by LOB (all case types), and then with splits by the following: i. POPs cases
  2. Split out by case type ii. MOPs cases
  3. Split out by case type

We need this to track trends in volume / HC to enable us to proactively manage resourcing. The number of HC can be defined by the number of unique individuals who handle cases in that month.

  1. One more sheet with a table of all team members handling cases with their last 3 month (i.e. currently would show Aug, Sep, Oct) KPIs including a. Monthly average cases closed b. Monthly average IRT c. Monthly average TTR