Creating Insights Using Live Data

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Analyze live data in a simple interface

Use Data Analyzer to Create an Insight

Data analyzer is a predefined ready-to-run service for SAP Business Warehouse (SAP BW) queries, SAP HANA Live views, SAP Datasphere models, and SAP Analytics Cloud models for ad hoc analysis. All SAP BW queries, SAP HANA Live views, and SAP Datasphere models can be accessed directly in the Select Data Source dialog, and no additional model is created.

Data Analyzer - User Interface

Data analyzer provides a tabular view of your data, a filter area, and a builder panel with drag-and-drop capabilities to add and remove dimensions and measures from the table. In addition, you have a menu bar with a Refresh option and an Edit Prompts dialog (if your data source is designed for setting prompts).

Table formulas are available but calculated measures are not.

After you have drilled down to the data details according to your needs and analyzed your data, you might want to save this insight. For this, choose Save in the upper left corner of data analyzer. In the Save Insight dialog, select the file location for your insight and enter a name and description for it.

Create an Insight Using the Data Analyzer

Task 1: Create a Data Analyzer Insight Using SAP Business Warehouse Cloud

Business Scenario

You have been asked by your team to create an insight accessing data from SAP Business Warehouse without performing a data import. You use the data analyzer, as a quick and easy way to access data via live connections.

Task Flow

In this practice exercise, you will:

  • Create a new insight from a SAP Business Warehouse data source
  • Configure the insight using the Designer pane

Task 2: Create a Data Analyzer Insight Using SAP HANA Data

Business Scenario

You have been asked by your team to create an insight accessing data from SAP HANA without performing a data import.

Task Flow

In this practice exercise, you will:

  • Create a new insight from a SAP HANA data source
  • Configure the insight using the Designer pane

Log in to track your progress & complete quizzes