Install Power BI template
Note: A Workgroup license or higher is required for access to this feature.
Before you can start to install the Power BI template, follow the steps below to create SQL views on the SQL CDR Database. Installing the template itself is done in Microsoft Power BI Desktop.
Add/Create SQL Views for Power BI
- Open Microsoft SQL Server Management Studio (SSMS) Learn More - Microsoft
- Connect to Server / Instance where the UCC A Unified Contact Center, or UCC, is a queue of interactions (voice, email, IM, etc.) that are handled by Agents. Each UCC has its own settings, IVR menus and Agents. Agents can belong to one or several UCCs and can have multiple skills (competencies). A UCC can be visualized as a contact center “micro service”. Customers can utilize one UCC (e.g. a global helpdesk), a few UCC’s (e.g. for each department or regional office) or hundreds of UCC’s (e.g. for each bed at a hospital). They are interconnected and can all be managed from one central location. Database is located.
- Navigate to the UCC Database
- Right Click Database
- Select New Query
- Paste the SQL code from the Power BI Template package, the SQL queries (.sql file) can be found in the folder where the template itself is (.pbit file).
- Execute the Query (F5 or Run)
Tip: An Alternative to SSMS is Azure Data Studio a newer and more lightweight Microsoft Application to manage SQL Queries, very similar to described steps above. Learn More - Microsoft
Installation Power BI Desktop and .pbit (template)
- Download and Install the latest Microsoft Power BI Desktop. Learn More - Microsoft
- Open the Anywhere365 Power BI Template [ .pbit file from template package]
- Enter SQL Server \ Instance name
- Enter Database name
- Select the Filter Method
- By default No Filter (all data) will be loaded into the template
- Select Previous Days to limit the amount of data collected in this query
- Fill the Previous Days parameter
- This parameter cannot be zero, even if the filter parameter is left to default.
- Choose if you want to Load Call Details
- Selecting False will speed up data collection at a cost of having no individual call detail data available.
- Choose if you want to Load Presence Data
- Selecting False will speed up data collection at a cost of having no individual agent presence data available (This may have been disabled altogether by the UCC setting EnablePresenceRecording, Learn More.)
- Choose if you want to Anonymize Data of a specific usergroup.
- You can choose between No (default), Agents, Callers or both Agents & Callers.
- You can choose between No (default), Agents, Callers or both Agents & Callers.
- Enter the value (in seconds) for Service Level Agreement
- Enter the value (in seconds) for Service Level Agreement 2
- Enter the value (in seconds) for the Quickdrop threshold level
- Enter the Frequent Contacts threshold to use
- Used in the Frequent Contacts calculation. Calculates the total number of callers that have contacted your contact center more times than the set Parameter.
- Enter the Frequent Transfers threshold to use
- Used in the Frequent Transferees calculation. Calculates the total number of calls per transferee with more calls than the set Parameter.
- Load the template
- Log on to the selected database if asked for your credentials.
Warning: Power BI Desktop is updated on a monthly basis. Only the most recent version is supported. See Power BI Desktop application details for the most recent version.
Tip: You can choose to not load presence and/or call data, to improve data load efficiency. However, this information will not be able to be included in reports.