openSAP ds1

Exercise Week 2 Unit 3

Data Manipulation
openSAP

TABLE OF CONTENTS
INTRODUCTION ............................................................................................................................................... 3
EXERCISE INSTRUCTIONS ............................................................................................................................ 4
Acquire Data ..................................................................................................................................................... 4
Visualize Room ................................................................................................................................................ 7
Prepare Room .................................................................................................................................................. 7
FURTHER READING ...................................................................................................................................... 15

2
openSAP EXERCISE WEEK 2 UNIT 3

INTRODUCTION
These exercises are designed to introduce you to some of the methods we can use to undertake data
manipulation using SAP BusinessObjects Predictive Analytics expert tool.

The data to be used is openSAP_STORES_US.csv.

This data set is a short list of US based retail stores.

The data set contains the following variables:

STORE (US City location of the store)
TURNOVER (annual sales for the previous 12 month period for each store $000000)
SIZE (size of retail floor space in 000s of sq. ft. for each store)
STAFF (number of staff members in 10s)
MARGIN (total gross margin per store $00000)

There are 5 columns of data and 150 rows. The columns represent the variables defined above, and the
rows represent the values for each of these variables for each individual store.

This exercise shows how to use a data manipulation in the expert tool to create new variables for analysis.

3
openSAP EXERCISE WEEK 2 UNIT 3

EXERCISE INSTRUCTIONS
Acquire Data

Open SAP BusinessObjects Predictive Analytics Select Expert Analytics:

Open Expert Analytics:

4
openSAP EXERCISE WEEK 2 UNIT 3

Select Acquire Data:

For this exercise, the data set we will be using is the openSAP_STORES_US.csv text data. Therefore,
select Text as the data source and then press Next.

5
openSAP EXERCISE WEEK 2 UNIT 3

Navigate to the folder where you have downloaded the data sets that accompany this training and select
openSAP_STORES_US.csv:

Press Open. The selected data will be read by SAP Predictive Analytics:

Press Create.

6
openSAP EXERCISE WEEK 2 UNIT 3

Visualize Room
The data set will be created and you will enter the Visualize Room:

Prepare Room
Navigate to the Prepare room.

Suppose we want to create a dimension calculates the turnover per sq ft of store. We will divide TURNOVER
/ SIZE.

7
openSAP EXERCISE WEEK 2 UNIT 3

Select the Calculation button, and select New Calculated Dimension.

In the New Calculated Dimension dialogue select the measure TURNOVER by double clicking.
Enter the divide function / in the Formula space.
Select the SIZE measure by double clicking.
Enter a Measure Name TURNOVER_PER_SQFT.

Press OK.

8
openSAP EXERCISE WEEK 2 UNIT 3

The new dimension is calculated:

This new dimension can now be used in your analysis. For example, you might want to visualize the
TURNOVER_PER_SQFT and compare it for the top 20 stores.

Go to the Visualize room:

You will see that the new dimension is listed. However, to create a bar chart we will need to create a new
measure from this new dimension.

9
openSAP EXERCISE WEEK 2 UNIT 3

Select the Options icon next to the TURNOVER_PER_SQFT dimension:

Select Create a Measure:

10
openSAP EXERCISE WEEK 2 UNIT 3

This will create the Measure:

A bar chart can now be created for the top 20 stores using the 123 radio button and selecting Top 20:

11
openSAP EXERCISE WEEK 2 UNIT 3

Other interesting ratios might be TURNOVER per head of staff, MARGIN per head of staff, and the number
of employees per sq ft.

You can repeat this exercise and visualize these ratios for the top 10 stores:

12
openSAP EXERCISE WEEK 2 UNIT 3

13
openSAP EXERCISE WEEK 2 UNIT 3

14
openSAP EXERCISE WEEK 2 UNIT 3

Other types of visualization and other ratios can be tested if you have time.

This completes the introductory exercise to Week 2 Unit 3 Data Manipulation.

FURTHER READING
Detailed instructions and a wide variety of other functionality for preparing data can be found in the user
guide pa31_expert_user_en.pdf.

15
openSAP EXERCISE WEEK 2 UNIT 3

Coding Samples
Any software coding or code lines/strings (Code) provided in this documentation are only examples and are
not intended for use in a production system environment. The Code is only intended to better explain and
visualize the syntax and phrasing rules for certain SAP coding. SAP does not warrant the correctness or
completeness of the Code provided herein and SAP shall not be liable for errors or damages cause by use of
the Code, except where such damages were caused by SAP with intent or with gross negligence.

16
www.sap.com

2016 SAP SE or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form
or for any purpose without the express permission of SAP SE or an SAP
affiliate company.
SAP and other SAP products and services mentioned herein as well as their
respective logos are trademarks or registered trademarks of SAP SE (or an
SAP affiliate company) in Germany and other countries. Please see
http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark for
additional trademark information and notices. Some software products
marketed by SAP SE and its distributors contain proprietary software
components of other software vendors.
National product specifications may vary.
These materials are provided by SAP SE or an SAP affiliate company for
informational purposes only, without representation or warranty of any kind,
and SAP SE or its affiliated companies shall not be liable for errors or
omissions with respect to the materials. The only warranties for SAP SE or
SAP affiliate company products and services are those that are set forth in
the express warranty statements accompanying such products and services,
if any. Nothing herein should be construed as constituting an additional
warranty.
In particular, SAP SE or its affiliated companies have no obligation to pursue
any course of business outlined in this document or any related presentation,
or to develop or release any functionality mentioned therein. This document,
or any related presentation, and SAP SEs or its affiliated companies
strategy and possible future developments, products, and/or platform
directions and functionality are all subject to change and may be changed by
SAP SE or its affiliated companies at any time for any reason without notice.
The information in this document is not a commitment, promise, or legal
obligation to deliver any material, code, or functionality. All forward-looking
statements are subject to various risks and uncertainties that could cause
actual results to differ materially from expectations. Readers are cautioned
not to place undue reliance on these forward-looking statements, which
speak only as of their dates, and they should not be relied upon in making
purchasing decisions.