EG: Make a POC for a Realtime report

[jesusitd]

The goal is to prepare ahead of a possible requirement that needs a real-time solution to report. Ideas are in plenty.

POC for Realtime reports Action items:

• [x] Ingest data from Genesys into Azure Storage. (WORKING WITH A.S)
• [ ] Test processing pipelines once the data is in Azure Storage
• [ ] Post processed data from Azure Storage on Event
• [x] Receive from Power BI Streaming Dataset and display the information

[jesusitd]

Ingest data from Genesys into Azure Storage

They will be publishing data using web sockets. There should be a no-to-low-code entry point that received the data in the web socket and dump it in Azure Storage (JSON).

Test processing pipelines once the data is in Azure Storage

A fast pipeline should be triggered on the Blob Created event. Options are available: Azure Function, Logic App, Event Grid/Hub. For this POC:

• Upload some dummy data: { "agent_id": "SOME-CRM-USERID", "status": "IN A CALL", "random": "44538534" }
• Trigger a Logic App on Blob Create event
• The Logic App should retrieve the Agent Name from CRM User data (from a place different than the Slave servers :) ) and join this data with the JSON data. Then make it:
• Compose an enhanced JSON and write it to a different Blob folder

Post processed data from Azure Storage on Event

From this processed data folder, trigger Blob Create Events that:

• Make a HTTP POST request to a Power BI Streaming Dataset endpoint :)
• This can also be a Logic App. Try to integrate with lo-to-no-code against Power BI.

Receive from Power BI Streaming Dataset and display the information

Set up the Power BI Streaming Dataset, and report in such a way that displays the processed data :)

[jesusitd]

Starting from bottoms up:

4. Receive from Power BI Streaming Dataset and display the information

I created a Streaming dataset in Power BI:

with these API specs:

Check out my recording to demonstrate the LIVE STREAMING dataset in Power BI: https://web.microsoftstream.com/video/88872759-3f18-4d38-beae-4ef1b5bd3a08

Unfortunately

Only a few options are available to display the Streaming data

[jesusitd]

1. Ingest data from Genesys into Azure Blob

We have Andrey from Upwork working on a POC. He's gonna create a Function App that listens to Genesys webhook and post that data in Azure Blob Storage. He's invited into Azure resource group by me, and added to it as a Contributor.

Some extra requirements:

• Logging
• Alerting
• Routing of messages (TBD)
• Handling renewal of websockets expiring every 24h
• Getting the IDs for Campaigns and Queues on a regular basis to capture all the data accordingly
• Manage throttling and limits from Genesys (20 channels per socket)

[jesusitd]

Done in development.