Versions Compared

Old Version 1

changes.mady.by.user Call Journey

Saved on

compared with

New Version 2

changes.mady.by.user Call Journey

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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:

  1. Go to Power Query Editor

Image Modified

2. Right-click on a disabled table (you can see the table name in italic format) > then click Enable load

Image Modified

3. Click Close & Apply

Image Modified

Additional Information

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

...

  1. Right-click Moving Averages in Fields > click Delete from model

Image Modified

2. Go to Power Query Editor

Image Modified

3. Right-click on Moving Averages (disable) > rename to Moving Averages

Image Modified

4. Right-click on Moving Averages > then click Enable load

Image Modified

5. Click Close & Apply

Image Modified