Create a Cognos Analytics Dashboard

Summary

In this developer code pattern, unstructured data consisting of product reviews and customer surveys is imported into Cognos® Analytics from IBM Watson® Discovery. The customer data also indicates the sentiment toward the products surveyed. This data can then be displayed on the Cognos Analytics dashboard.

Description

To leverage the voice of the customer to drive business results, companies need to leverage AI to gain actionable insights from sentiment, emotion, concepts and key words mentioned in customer feedback. Much of the important data a customer wants to share can already be found. It exists in public forums, blogs, social media posts, and chat logs with customer representatives. The challenges to leveraging this information has historically been the unstructured nature of it. Today though, we have AI and services like Watson Discovery that can be trained to aggregate, enrich, and help surface key customer insights. This code pattern shows how you can visualize unstructured data from Watson Discovery in Cognos Analytics for product performance analysis.

You will import unstructured data consisting of product reviews and customer surveys into Cognos Analytics from Watson Discovery. The customer data also indicates the sentiment toward the products surveyed. This data can then be displayed on the Cognos Analytics dashboard. Combining Cognos Analytics with Watson Discovery, clients will:

  • Get early warning of trends based on customer feedback.
  • Address escalating customer interactions with early intervention.
  • Target the right customers with the right products and the right marketing.
  • Know where to invest to drive revenue and customer adoption.
  • Get to the root cause of churning customers.
  • Identify actions to increase NPS or other customer satisfaction metric.

The theme of this code pattern is data for a small coffee manufacturer that sells products in local markets. The data will consist of reviews and ratings for its different coffee flavors.

Flow

Flow diagram

  1. Product review data is loaded into Watson Discovery for enrichment. Results include sentiment analysis and keyword discovery.
  2. User runs Cognos Analytics.
  3. Data files are loaded directly into Cognos Analytics.

Instructions

Find the detailed steps for this pattern in the README file. The steps will show you how to:

  1. Clone the repository.
  2. Create your Watson Discovery service.
  3. Configure Watson Discovery.
  4. Add service credentials to the environment file.
  5. Run scripts to generate the data.
  6. Build a data module in Cognos Analytics.
  7. Create a Cognos Analytics dashboard.
  8. Add visualizations to the dashboard.
  9. Update the data module.
  10. Visualize the impact that product reviews have on sales.

Use this pattern along with the Create a Cognos Analytics Dashboard for sales data and inventory levels pattern to work through the complete Analyze unstructured data with AI to gain product performance analysis solution.