O'Reilly logo

SAP Lumira Essentials by Dmitry Anoshin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Preparing data

Usually, there is raw data in the data source and we want to analyse it from another view. However, sometimes it is not formatted consistently. As a result, it is not easily interpreted by business users. Before creating reports and visualizations, it is often necessary to clean up the data so that it is presentable and understandable.

Cleaning and editing a dataset

Say we want to exclude Shipping City from our dataset in order to analyse the revenue and quantity of items by category. In addition, we want to reduce the dataset and improve performance. This can be done easily with the following steps:

  1. Click on Data->Edit Data Source or press Ctrl+Shift+E; the Edit Data Source window will appear:
  2. Uncheck Shipping City and click on OK ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required