Back

Posted on July 20, 2023 in

This post expands on previous articles where we detailed how Joulica extends the powerful capabilities of Amazon QuickSight with real time, streaming analytics. You can get a good overview here: Unified Realtime and Historical Analytics with Amazon QuickSight. In this article, we will focus on the following use cases and industry verticals:- 

  1. Customer Experience
  2. Internet of Things
  3. Sales 
  4. Healthcare

A common architectural pattern is followed for all of these: -

  1. Amazon Kinesis for streaming data
  2. Joulica platform for realtime analytics
  3. Amazon QuickSight for dashboard creation
  4. Amazon QuickSight Custom Visual Content (see Using custom visual content)

The following diagram shows the approach. As can be seen, Amazon Kinesis is used here as the primary means of accessing streaming data. Utilising Kinesis has many advantages, including the broad integrations that are in place across the AWS ecosystem and cloud applications generally.

Extending Amazon Quicksight 1

The Joulica platform allows users to transform and analyse data from Kinesis, and for the resulting analytics to be incorporated into visual widgets. Each widget is a separate web component, and we utilise the Custom Visual Content type to embed the Joulica components within QuickSight dashboards. We make heavy use of the Free-form layout to produce the infographic-style visualisations below.

The following sections detail examples from each of the use cases and verticals.

Customer Experience

The first example is from the Customer Experience market and utilises Amazon Connect as the core CCaaS solution. Realtime Contact Center KPIs are shown along with sales and customer sentiment analytics. Historical data is also shown, highlighting the seamless integration between the real-time and historical KPIs.

Extending Amazon Quicksight 2

Internet of Things

The next example shows streaming sensor data across a number of devices, alongside a daily trend (with the historical trend visualisation a core capability of QuickSight). For reference, the solution architecture is similar to that depicted in Detect water leaks in near real time using AWS IoT where device data is streamed by AWS IoT services onto Amazon Kinesis. As new data becomes available, updates are pushed automatically to the Joulica web components within QuickSight. The result is shown below (for reference, the Joulica components are on the right).

Extending Amazon Quicksight 3

Sales

It is critical that leaders have access to up-to-date sales data across all channels and regions. In the example here, Salesforce is providing sales data via the Salesforce Event Relay. Data arrives at AWS Event Bridge, which is configured to push the information to Kinesis. From there, Joulica can ingest the data and enable the QuickSight dashboard shown below. This example illustrates the QuickSight free-form layout features nicely, with all of the data overlaid on a map.

Extending Amazon Quicksight 4

Healthcare

The final example is taken from the Healthcare field and focuses on a number of critical KPIs such as admission wait times, bed occupancy, and length of stay. These KPIs are mainly relevant to Admissions optimisation, but there are many more, including equipment utilisation and staffing. It is becoming increasingly important for these metrics to be monitored in real-time and made available to all stakeholders, including the broader community, in some cases.

Extending Amazon Quicksight 5

Summary

This post provided a number of examples where the combination of Joulica, Kinesis, and QuickSight can be used to provide unified real time and historical analytics across a number of domains and use cases. Other data streaming technologies, e.g., Kafka, are also supported, and naturally, there are many more verticals and areas that benefit from having access to live analytics.

If you are interested in finding out more, contact us at info@joulica.io or visit www.joulica.io/request-demo to arrange a demo.

July 20, 2023 AWS

Related Materials

Realtime and Historical Analytics for Salesforce Service Cloud

Joulica is an AWS-based real time and historical reporting solution for ...


Learn More

The Power of Real-Time Analytics in Modern Contact Centers

In the fast-paced world of business, where customer expectations are...


Learn More

Unifying Real-Time and Historical Analytics

In an age where decisions are driven by data, both real-time and historical...


Learn More

Extending Amazon QuickSight with Realtime Analytics

This post expands on previous articles where we detailed how Joulica extends...


Learn More

Unleashing the Power of Analytics with Joulica and Amazon Connect

In the modern business world, the significance of an exceptional customer...


Learn More

Customer Experience Analytics with Amazon Connect

Amazon Connect makes it easy to measure the sentiment of all customer...


Learn More

Unified Analytics for Salesforce Contact Center

With Salesforce Contact Center organisations can deliver proactive,...


Learn More

Get the latest news from Joulica

Ready to get started?

Easily visualize, measure, monitor, and optimize your customer journeys, all with Joulica’s Data Analytics.

Request a Demo