Call Journey has released a new version of the Power BI dashboard template that has improved performance for an initial load and data refresh.
To understand how this dashboard has changed, please see the following table:
Table/ Visual | Comment |
|---|---|
public generated_analytics_data | Removed unused JSON columns to reduce the table size
|
public generated_analytics_client_data | Disabled load |
public generated_analytics_scorecard_data | Disabled load |
Moving Averages ** (can be done with All Agents) | 1) Disabled load in Power Query (should/ will remove in reduce workload on public generated_analytics_data) 2) Re-created a calculation in DAX (please see the additional information for enabling this table) |
Client Phrases Agent Phrases | Disabled load (should/ will remove in reduce workload on public generated_analytics_data) |
Best and Worse Customer Calls
Best and Worse Agent Calls
| Removed visuals and calculations |
How to enable load for a table in Power Query Editor
If you want to utilise the disabled table above, you can simply enable it by:
STEPS:
Go to Power Query Editor
2. Right-click on a disabled table (you can see the table name in italic format) > then click Enable load
3. Click Close & Apply
Additional Information
Please follow these steps If you prefer the calculation of the Moving Averages table in Power Query
STEPS:
Right-click Moving Averages in Fields > click Delete from model
2. Go to Power Query Editor
3. Right-click on Moving Averages (disable) > rename to Moving Averages
4. Right-click on Moving Averages > then click Enable load
5. Click Close & Apply
