Nimbus Power BI Template

Luware BI Template Files

INC Nimbus Power BI Files

📊Power BI Template Files

Template Download: Luware provides Power BI Files on request. To get the latest version, visit our BI Template request site | Luware.com.

✅ Usage Instructions:

  • First Time Users: To connect the Template to your Nimbus data source, read Setting Up Power BI. While setting up the Template (.pbit), you need to provide connection parameters and your Reporting Role User credentials to perform a first query.
  • Performance: Once setup is done, save your template as a .pbix report, as it will use considerably lower RAM/CPU than a template.
  • Daily Usage: Visit Nimbus Power BI Template for further details on the template itself.
 

INC Reporting Template Disclaimer

DISCLAIMER: Power BI Template updates and support

Note that we continuously develop the template not just visually, but also to reflect the latest OData Feed and Nimbus Reporting Model data warehouse concepts. This also requires our Power BI template to be updated in regular intervals.

While we strive to maintain backwards compatibility, your older stored Power BI file template versions can become outdated over time. This is also due to the physical nature of Power BI files and Power BI App development itself, resulting in Nimbus data not being queried as expected anymore and/or features getting deprecated and replaced over time.

Recommendation: Regular BI Template Updates 

As communicated via our Nimbus BI Template Release Notes we are constantly improving our products, including the Nimbus BI template; this results in changes, not just to visible template functionality, but also the underlying queries. Since each improvement can only be delivered in the form of a new physical file, we never make retroactive adjustments to older versions of the template, and thus, we cannot guarantee that an old template file will continue to work indefinitely as expected. 

For those reasons we strongly recommend the following:

Regularly check the Nimbus BI Template Release Notes for any changes on features that you use.

Update your template at regular intervals to ensure seamless interaction with the OData Feed and any Nimbus updates.

 
 

Note: Support on customized Templates

While we understand the need and allow our users individually to customize the Nimbus Power BI Template, please understand that this also introduces a huge variety of possible error causes. We gladly take customer feedback to continuously improve our template in general, however this must be done by striking a balance between features, clarity, maintainability and stability.

☝For the reasons above, please understand that Luware Support cannot assist you with your own customized templates.

✅Whenever you encounter errors on your customized templates: Please ensure to test in parallel with the newest BI Template first, before contacting customer support.

 
 
 

Template Overview

The Nimbus BI template consists several views/tabs:

  1. Service Overview - Service Session KPI aggregated by service.
  2. User Overview - User Session KPI aggregated by user.
  3. Session Details - KPI by service session (can be used to drill down into a KPI from Service Overview).
  4. User Session Details - KPI by user session (can be used to drill down into a KPI from User Overview).
  5. Tags-Codes - Tags and Codes as recorded in My Sessions view by users.
  6. Unified Sessions - Provides the details of the end-2-end concept of a conversation in the business world (e.g. an end-2-end call). A session is a transaction in Nimbus, a unified session can contain one or more service sessions and user sessions. 
  7. User States - Provides duration KPI aggregated by user and state type as well as profile names and not available reasons (if applicable), based on every single state change recorded in User States 
  8. Transfer - Provides a high level view of transfer sessions volume, as well as a grid with details of each transfer.
  9. Info - Template versioning, session volume and other technical details needed when opening support tickets with Luware.
  10. Data Load Check -  Shows a data count and summary for each main KPI table, as well as the timestamp of first and last session record for each table. This is especially useful with incremental refresh to evaluate the volume of data loaded in the report as well as the completeness and freshness of the data in each KPI table. 

🔎 Each tab is described in further detail below. Data shown is based on the Nimbus Reporting Model

💡 The Nimbus KPI Calculations are completely done in the product itself, the report does only query the results.

 

Template Tabs

GOOD TO KNOW

To switch between the tabs and views:

  1. Hold CTRL and left-click on the icons at the left hand sidebar     
    or 
  2. Use the tabs at the bottom of the report to navigate

Also noteworthy:

  • In Power BI Desktop you must use CTRL + Click on buttons and links, otherwise you may just select fields in the template for editing.
  • CTRL is also used to multi-select filtering options and list entries.
  • Arrows indicate Drill-Through possibilities into further data.
 

Overview pages

Service and User Overview

Service and User Overview provide a general overview of the sessions associated with a user or a service. Here you may find:

  • ... total measures showing counts and time for all your Services and Users.
  • ... KPI such as as Reachability, Acceptance and Hang-up SLA%. Call distribution in time.
  • ... performance comparisons in different time periods between services/users in your system.

💡 You can drill through a selected user session for details as described in the “How to use” chapter below.

 
 

Session Detail pages

Session Details and User Session Details

Session Detail pages give a closer look on the distinct sessions accrued on the Service / or the User.

💡 You can drill through a selected session for details as described in the “How to use” chapter below.

 
 

Tags and Codes

Tags and Codes

Tags and Codes specified by users during (via the My Sessions UI) are shown as a tag cloud in the reporting template. The bigger the tag shown, the more frequent it has been used.

For example you can click on tags to ...

  • ... narrow down data by user / service sessions that used these tags.
  • ... identify months where tags have been used more frequently.
  • … identify users that were using those tags.

In the Nimbus Power BI template we have two pages to provide an example of how tags and codes can be analysed from from two different perspectives.

Tab: Tags-Codes 1st User

Shows tags and codes assigned by the first accepting user. ☝If the first accepting user didn't add any tags or codes but the subsequent user did, then this page will not show any tag or codes assigned to that service session. Use this page if you want to analyze the tags and codes assigned at the first user touch point.

Tab: Tags-Codes: All Users

Allows to analyze all tags and codes assigned by all users across various user sessions. Use this page if you want to analyze tags and codes across all user touchpoints in your services.

☝Non-retroactive feature: Please be aware that the data separation into two tabs is a recent feature. Data was generated since October 2024. For tags and codes recorded before that point please refer to the tab “Tags and Codes 1st User”.

 
 
 

Unified Sessions

Unified Sessions

Lists Caller (customer) data like PSTN or Name, the Caller path and connection times with the final session outcome.

💡 Click on a Session, then CTRL+Click the button on the bottom to show further details. Also see “How to use” chapter below.

Related Info

  • Update Frequency: note that Unified Session can take up to 1hr after the end of the last Service Session or Unified Session in the series of Sessions of belonging that Unified Session (end-to-end-interaction) to fully load and become visible in the OData Feed.
  • To learn more about Unified Sessions and related User and Service Sessions, visit Nimbus Reporting 
 
 
 

User States

User States

This tab lists User States, also referred to as "Team Enability" (e.g. the On/Off Service participation toggle in the Frontend UIs during daily use of Nimbus).

PRECONDITIONS

Contact Center Licensing - please note that reporting on tracked User States is a Contact Center feature.

✅Feature toggles

Tenant Admin Feature Toggle - To gather User State data, this feature needs to be enabled for your tenant. This is done via Tenant Administration > Data Privacy > "Persist User States in Reporting" option.

User State related Options in the Tenant Administration

You can learn more about each feature in the Tenant Administration pages.

✅ Power BI parameters - In the Power BI template, the connection parameter “Load User States” must be set to “True” before refreshing the dataset.

Impact on your Data Query: Tracking presence states can generate considerable amounts of personal user data. Aside from Power BI query performance considerations on a large userbase you need to consider privacy and EU GDPR compliance before enabling this feature.

🤔 What User States data is being tracked? User, User ID, Organization UnitResponsibility Profiles (User State), MS Teams Presence Status and all related event changes with timestamps and durations.

 
 

✅ Supervisor Role Requirement

User Supervisor Role - The user refreshing the Power BI report must be a Nimbus User Supervisor (this role can only be assigned to a user with a Contact Center license). 

  • The User States tab in Power BI will not show any information unless you have this role assigned via the User Administration. More infos on this role can be found on User Role (RBAC) Matrix.
  • The Nimbus User Supervisor will see user states for all users in the supervised OUs irrespective of whether such users have a Contact Center license or not.

Organization Units dependency - The Nimbus User Supervisor will only see the user states for the users in the Organization Units they are explicitly assigned to (as a Supervisor). 


LIMITATION BY DESIGN If a user has only Supervisor and not a Team Owner / Service Admin role, only the "UserStates" dataset in the report will be shown, consisting of: UserStates, StateTypes, ResponsibilityProfile, OU, Users. Other tabs and queries in the BI Report may appear blank.     
→ This is intended by design to prevent exposure of individual Service/User/Session data to the wrong audiences. To see a full dataset, the same user also needs a "Service/Team Owner" role assigned. 

 
 

🤔 What are user states?

User States

For its Reporting Model, Nimbus performs checks on various User States. You can think of this as a multi-factor validation performed by Nimbus in order ensure a user is ready (and suitable) to take an incoming task from the internal queue. In short, the user is either considered as “selectable” or “not selectable”.

Factor Tracked User State relevant to Nimbus
  Teams Layer (monitored by Nimbus, always manually controlled by user)
Presence in MS Teams User is not present on the machine User can make and receive Non-Nimbus calls. Online AND set to any presence that Nimbus considers “not selectable” Online AND set to any presence that Nimbus considers “selectable” Set to any presence that Nimbus considers “selectable”
Offline 
(Appear Offline)
Signed in DND Busy in a call Busy Away 
(Appear Away, Be right back)
Available
  Nimbus Layer (in addition to Teams, according to dependencies described above▲ or below ▼ )
Offline Presence check ► Offline 
User will not receive Nimbus tasks.
User is inactive in all MS Teams-based services… AND/OR 
in Off Duty Profile
  🔎Configurable Distribution Service Settings exception: 
MS Teams "Busy" or “Away” status ▲can be opted-in, making users Selectable ▼ for Tasks
 
Service assignment check   ►Off Duty 
User will not receive Nimbus tasks.
Active in Nimbus - MS-Teams based Services will distribute to this user. 
🔎Individual Active toggles: Each Service has individual “Active” toggles, allowing users to steer availability per Service.
On Duty Profile - Contact Center Services will distribute to this user.
🔎 Profiles and Skills:  Any "On Duty" type Responsibility Profile allows Contact Center participation. 
For the user to be "Selectable" ▼ Skills and Responsibilities defined in the profile must match the Service. This is determined by the individual Distribution Policies  assigned to the respective Service.
Conditional Presence check  

❌►Not Selectable 

User will not receive Nimbus tasks.
User is not available either due to the MS Teams Presence ▲ AND/OR, …
Service Settings configuration ▲ says Busy/Away - Do not Distribute. 
A Not Available Reason is requested, if enabled on user level.

 
Task count check   Task Parallelization is enabled for the user. 
AND user is Available ▲ OR Service configuration says "Busy/Away - Distribute to the user" …
AND user has reached tasks limit …
AND all the tasks are in non-blocking states.
► Task Limit Reached 
User will not receive Nimbus further Nimbus tasks.
💡This state has lower priority than “Not Selectable” due to MS Teams presence ▲.
Selectable state   User can get at least one task 
User is Available or Service Distribution settings ▲ allow  Busy/Away - Distribute 
✅ ► Selectable 
User can receive Nimbus tasks.
Nimbus Task-related states   User currently reserved and blocked by a Nimbus task. Can result in any of the following User States.
RONA 
User flag after not responding to a task, blocked for the next tasks.
Ringing 
User is reserved for new task, but has not accepted yet.
Dialing Out 
User accepted outbound task, is waiting for destination to accept.
Connected 
User has accepted and is now blocked by a task. 
After-Call Work 
User-extensible timespan to complete work after a call.
Table: User States tracking in Nimbus

User State Factors explained

First and foremost, it is important to note that User State factors relate to each other. Reading the table above, relationships are indicated with arrows ▲▼. Expand the items below to learn more about each factor.

MS Teams presence

💡Good to know: Nimbus will always read Teams Presence, never actively change this status. It is upon the user to change their presence actively to signal willingness to take new tasks.

 

MS Teams presence always forms the uppermost layer for Nimbus for User State validation:

  • The presence check must always be passed first. Presence must meet the criteria of the Distribution Service Settings. This can be individually configured per Service, which means that users can be conditionally made “selectable” even while Away.
  • Online users are considered for Nimbus tasks depending on:
    • … the Services for which they have a Portal Role assigned AND
    • … the Service mapping criteria (Active / Duty State) are met → See below.
  • Offline / DND users are not considered. Nimbus will not distribute tasks.
 
 

Service assignment & presence

These factors are shared criteria among Services, depending on the Services the users participate in. The Type of Service determines when a task is being distributed to selectable users:

Advanced Routing and Enterprise Routing  Contact Center
Start condition: MS-Teams "Team”-based Services with a fixed pool of team members. Users are signed in within MS Teams  Start condition: Nimbus standalone Services with a dynamically assigned user base. Users are signed in within MS Teams

Advanced Routing and Enterprise Routing consider users selectable once they are set “Active” in the Nimbus UI.

“Active” Toggle in the UI

Contact Center Services replace the “Active” state with a Duty State as a conditional “is selectable” check.

Duty Profile selector in the UI
💡The  “Active” toggle is considered as “selectable” factor. 💡The “Active” toggle is replaced by the Duty profile. Nimbus distributes according to the Skills and Responsibilities related to the profile. These criteria are defined in each Service's Distribution Policy.
Selectable are: The entire “Online” and ”Active" pool of users with in an Microsoft Teams Team is considered as selectable. Any “Online” Nimbus user can be considered depending on the factors above, regardless of “MS Teams” membership.

🔎Note: Mixed participation is possible

When users participate in multiple Services, a mix of “Active” toggle and “Duty Profile” can be leveraged by users to steer their participation.

💡Example: A user is “Signed In” in MS Teams and wants to steer presence in the Nimbus UI for multiple Services

MS Teams Presence Active Toggle

Selectable for:

Advanced- / Enterprise Routing

On Duty Profile

Selectable for:

Contact Center

Signed in ❌ (not selectable while "Inactive") ❌(not selectable while “Off duty”)
Available ✅ (Distribution Policies apply)
Available ✅ (Distribution Policies apply)
Available
Away ✅ While Distribution Service Settings > Away > "Distributed to the user”. ✅ (Distribution Policies apply).
Busy ✅ While Distribution Service Settings > Away > "Distributed to the user”. ✅ (Distribution Policies and Distribution Service Settings apply).
DND ❌ (DND is always task-blocking) ❌ (DND is always task-blocking)
 
 
 

Task count / limit check

Whenever Task Parallelization is enabled for a user, they can get multiple tasks distributed to them. This will happen when the following prerequisites are met:

  • Task Parallelization is enabled for the user in their General User Settings.
  • The user is “Selectable” according to the presence/mapping factors described above. 
  • The user is already Parking a task.
  • The user is not in any task blocking state. → 🔎See table below, or visit the Task Parallelization page to learn more.

🔎Table: Task blocking states

INC Task blocking states

Modality ►

Audio/Video 

External Task 

Instant Messaging 

Email 

Direction ►
State Category ▼ 

Inbound

Outbound
Call on Behalf

Outbound
Scheduled

Outbound with Workflow

None 
(stays in Nimbus)

Inbound

Inbound

Incoming Blocking Blocking Blocking Blocking Blocking Blocking Blocking
Dialing Out N/A Blocking Blocking N/A N/A N/A N/A
Connected Blocking Blocking Blocking Blocking Blocking Blocking Blocking
Transferring Blocking N/A N/A N/A N/A N/A N/A
On Hold Blocking Blocking Blocking Blocking N/A N/A N/A
Parked Non-blocking Non-blocking Non-blocking Non-blocking Non-blocking Non-blocking Non-blocking
Unparking1 Blocking Blocking Blocking Blocking N/A N/A N/A
In (Extended) ACW N/A N/A N/A N/A N/A N/A N/A

1 Not visible as a dedicated state on the UI. While Nimbus is unparking a session, a “blocking” invitation is ringing in MS Teams, preventing the User from receiving further tasks.

💡Good to know

Once the maximum numbers of tasks is reached, Nimbus will not distribute further tasks to the user. 

Even with Task Parallelization enabled, additional factors may prevent the user from getting additional Tasks. Examples are: 

  • Being in any task-blocking state (according to the table above).
  • Being in DND presence, marking the user as “not selectable”. This will take precedence the task limit.
 
 
 

This factor is considered by all Nimbus Services. Nimbus uses these flags to signal why a user is currently “Not selectable”. This is also done to keep a track record for Nimbus Reporting purposes.

 

Task states

Nimbus these states to make users unavailable for further tasks. For example:

  • While already being in a blocking status (e.g. Not Selectable, already busy in a task, in After-Call Work (ACW) or flagged by RONA from not answering a task), no further tasks will be distributed to the user.
  • ACW, Connected and Ringing are reported as dedicated states, all other blocking statuses are reported as “Not Selectable”.
  • “Offline” in Teams or “Off Duty” in Nimbus are also reported as dedicated User States. 

🔎Table: Overview of User States

INC User State Type Table

For Reporting purposes Nimbus tracks User States, which define the ability of a User accept and handle tasks. Below is a table of these tracked states:

Id

Name

1 Offline: User offline in MS Teams and thus cannot be selected for Tasks.
2 Off Duty: User is either in a “Offduty” Duty States or “Inactive” in Nimbus UI.
3 Selectable: User logged-in MS Teams and available to take Nimbus tasks. → Also see Task Queue and Distribution.
4 Not Selectable: User is in a MS Teams presence state that blocks task distribution as per Distribution Service Settings.
5 Ringing: A task has been assigned to an User but not yet been accepted. Can be either incoming calls or when an User is accepting an Outbound Call. Also applies for non-telephony-related modalities like Email, External Task, Instant Messaging etc.
6 Connected: The User and Customer are in a session together. Also applies when the User is just handling an External Task.
7 After-Call Work: User is handling After-Call Work (ACW).
9 RONA: User flagged with RONA state by a non-accepted task.
10
Dialing Out: User has accepted an Outbound Call and Nimbus is now ringing the target Customer.
11 Task Limit Reached: User has reached max allowed number of tasks assigned. Even if the user state would allow for new tasks, the task limit will prevent further distribution to this User.

✅ Enabling User State Tracking & Data Privacy

Each time a user changes from one Status to another, a Nimbus Reporting record is written as an historic entry to the database. Transitions will therefore not appear in the UI, but only as timestamp record on each status change.

💡GDPR Data Privacy Opt-In: Tracking detailed User States allows for a time-based analysis of the states of each user. Note that this option generates a lot of additional reporting data that also reveals daily user habits. Tracking of this data must be explicitly enabled via Tenant Administration > Data Privacy in order to be recorded in the historic reporting.

 
 
 
 
 
 
Example showing accumulated time spend in various states

INC User State Type Table

For Reporting purposes Nimbus tracks User States, which define the ability of a User accept and handle tasks. Below is a table of these tracked states:

Id

Name

1 Offline: User offline in MS Teams and thus cannot be selected for Tasks.
2 Off Duty: User is either in a “Offduty” Duty States or “Inactive” in Nimbus UI.
3 Selectable: User logged-in MS Teams and available to take Nimbus tasks. → Also see Task Queue and Distribution.
4 Not Selectable: User is in a MS Teams presence state that blocks task distribution as per Distribution Service Settings.
5 Ringing: A task has been assigned to an User but not yet been accepted. Can be either incoming calls or when an User is accepting an Outbound Call. Also applies for non-telephony-related modalities like Email, External Task, Instant Messaging etc.
6 Connected: The User and Customer are in a session together. Also applies when the User is just handling an External Task.
7 After-Call Work: User is handling After-Call Work (ACW).
9 RONA: User flagged with RONA state by a non-accepted task.
10
Dialing Out: User has accepted an Outbound Call and Nimbus is now ringing the target Customer.
11 Task Limit Reached: User has reached max allowed number of tasks assigned. Even if the user state would allow for new tasks, the task limit will prevent further distribution to this User.

Related Pages

 
 
 

Transfers

Transfers

Allows to inspect where sessions are transferred to and to which result, so involved services can be optimized accordingly.

Transfer Report

Can be filtered by: 

  • Start Date Time
  • Service From
  • Service To

Provides the following Visuals:

  • Pie Chart "Transfer by"
  • Pie Chart "Transfer by Result"
  • Transfer Flow Diagram by Service 
  • Source Service
  • Destination
    • Service by Name
    • External
    • User
  • Grid “Transfer Overview”
  • For related OData Tables on static dimensions and facts see Nimbus Reporting Model→ “Transfer Sessions”
  • If there was more than one transfer session occurring during a single service session, it is stored in the Transfer Sessions table. However:
    • If the last logical Workflow Activity of a service session was a transfer, then the "transfer" fields in service sessions table will be populated.
    • if the last logical Workflow Activity was not a transfer (e.g. Transfer > Queue in new Service), then "transfer" fields in service sessions table will be left empty.
 
 
 

Info

Info

Shows the template version and (last) connected user that did the data refresh.

 
 

Data Load Check

Data Load Check

The Data Load Check page provides the full overview of the amount of data loaded in the tables that can be incrementally refreshed.  It shows details of the number of sessions loaded for each of the fact table as well as the earliest and most recent session. This allows the user to get an idea of the amount of data loaded into the report and to verify the most recent available sessions available in the report. 

Data Load Check
 
 

How to use…

Drill Through

Drill Through buttons provide a convenient way to navigate between entry overviews and detail pages. The drill through possibility is signaled with an arrow:

 

Example:

  1. Select a Service entry (row) on the Service Overview page.
  2. Use the Drill Through button (don't forget: CTRL+ Left-click) → The Caller Overview page with a full list of Service Sessions for this particular service is shown
  3. Pick one session (row) on the Caller Overview page and CTRL + Left-click "See Session Details" → The Session Details page for that user is shown.
  4. Use the "Back" buttons/arrows to get back to the previous pages.
Drill down into sessions of a particular user
Example of multiple drill-through steps

Data Slicers

From within any tab you can narrow down the data with predefined slicers (filters).

  1. Navigate to any tab that has a slicer symbol shown in the menu.     
     
  2. CTRL + Left-click the Slicer Symbol at the bottom left → The Slicer Menu opens
  3. Select your filters and time range slicers as needed 💡 Don't forget to hold down CTRL while handling UI elements.     
    → The BI Template automatically refreshes the data based on your selection.
Slicer Menu

Template Troubleshooting

Did you encounter issues with the BI Template? Please refer to Setting Up Power BI > Known Issues and Solutions.

 

Table of Contents