Release Notes - June 2021

Call Journey has released a new version of the Power BI dashboard template (Data Bridge - 1.3.062621.pbit) 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

Table/ Visual	Comment
public generated_analytics_data	Removed unused JSON columns to reduce the table size original_json appdata clientdata
public generated_analytics_client_data	Disabled load
public generated_analytics_scorecard_data	Disabled load
Moving Averages ** (can be done with All Agents)	Disabled load in Power Query (should/ will remove in reduce workload on public generated_analytics_data) 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 Top 20 Customer Phrases in Positive CSAT Calls Top 20 Customer Phrases in Negative CSAT Calls Best and Worse Agent Calls Top 20 Agent Phrases in Positive CSAT Calls Top 20 Agent Phrases in Negative CSAT 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 as follows:

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

How to add column/s to generated_analytics_data

Note: adding some columns might impact loading performance

Please follow these steps If you require additional columns in generated_analytics_data

Go to Power Query Editor

2. Go to public generated_analytics_data > click on Source setting

3. Go to SQL statement section > add column/s name (start with “,”, for example “, scorecard”) at the end of the SELECT statement > then click OK

(You can find the columns lists from this link: Databridge: Data Dictionary )

4. Click Close & Apply

Additional Information

Please follow these steps If you prefer the calculation of the Moving Averages table in Power Query

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