Building Stories Using Files as Data Sources

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Build stories from files

Build a Story from a File

You can use a file as the data source for your story. While a model is the most common data source to use, having the option to use a file can help enhance your story with specific data that may be unique to your business unit, cost center, customers, etc.

When building a story using a file as the data source, you automatically create an embedded dataset. In the Data Preparation area you can make changes directly to the data:

  • Modify the name of the dataset: Select Edit to the right of the current dataset name in the Dataset Overview pane on the right side of the interface.
  • Resolve warnings regarding the data quality in your dataset: Typically, these data quality issues involve missing data, measures containing non-numeric characters, or dimensions assigned a mismatched data type. Issues are displayed as links within the impacted column entries. Select the links to view more detailed information listed under Validation in the Navigate to Details panel of the Dataset Overview pane.
  • Manage measures and dimensions: You may need to delete or rename entities, add geo-enriched data, define level-based hierarchies, change the data type, set up the default aggregation type for your measures, etc. You use the Navigate to Details pane for these manipulations.
  • Define transforms in cells, rows or columns: You may need to filter or replace values, or concatenate or split columns. 

You can use one of two transformation options to manipulate the data:

  • Transform Bar
  • Custom Expression Editor

The Transform Bar lists suggested transformations to apply to the column, such as replacing the value in a cell with a suggested value. You can also select Create a Transform and choose from the options listed under the transformation bar displayed above the grid.

The Custom Expression Editor accesses the Wrangling Expression Language (WEL) scripting editor to define your own transformations using predefined functions for specific wrangling capabilities. The following figure shows examples of the wrangling options you have.

Create a Story from a File and View the Imported Data

Task 1: Create a Story Based on a File

Business Example

You need to analyze some new sales data by creating a story.

The data is contained a CSV file, so you decide to use the create new story from file functionality in SAP Analytics Cloud.

What skills will you develop in this practice exercise?

In this practice exercises, you will:

  • Access stories from the vertical menu
  • Create a responsive page Classic Design Experience story
  • Add data to the story from a .CSV file

Task 2: View the Imported Data

Business Example

You have created your story and imported the data. Now, you need to navigate and view data for specific values before you finish building your story.

What skills will you develop in this practice exercise?

In this practice exercises, you will:

  • Access the Details panel for the data
  • Highlight values in the data table from the Details panel

Log in to track your progress & complete quizzes