Skip to Content

The preparation collocated in this post was followed for the creation of the “Greek Tourism Data – Creating Marketing Campaign” (you can see the whole analysis here: http://goo.gl/KLqlew). The data of the analysis were obtained from the Greek Statistical Authority (http://goo.gl/usdVk6) open databases and have been analyzed with SAP Lumira. More specifically, the dataset investigates Tourism per duration, gender, age, purpose and interior/exterior tourism.

This post follows a simple flow to prepare the data for the analysis on SAP Lumira. While there is no general, fixed procedure to be followed for every analysis, this post includes some basic steps that, are needed in the foresaid analysis, and will be useful in most cases.

In this post there is information on how to:

  1. Manipulate columns of the table
  2. Create Measures and Calculated Measures
  3. Add, create, add measures and attributes and save a Chart
  4. Create a Storyboard, add boards and charts, and customize them
  5. Share the dataset and storyboards through local Lumira or the cloud through the browser
  6. Extra links on tutorials and sources
  7. The table supplied by Greek Statistical Authority contains a number of columns stating the numbers of Purpose of travel, Year, Ages and Expenses differentiated by the age groups.

Preparation of Data

  1. The table supplied by Greek Statistical Authority contains a number of columns stating the numbers of Purpose of travel, Year, Ages and Expenses differentiated by the age groups.                         1. Lumira tech.png
  2. Every age group is separated by the source in 4 different categories. For example: a. “Age 0-14” refers to interior tourism for 1-3 nights, b.“Age 0-14 (2)” interior for 4+ nights, c. “Age 0-14 (3)” exterior for 1-3 nights, and d. “Age 0-14 (4)” exterior for 4+ nights. While the business scenario implied is located in Greece, the interest of this analysis lies in interior tourism. For the rest of the irrelevant data, there is an option to “Hide” or even “Delete” the appropriate columns.                                              2 Hide columns.png
  3. To make columns clearer, they can be renamed easily by clicking the wheel on their right, as shown in the picture. Then the clarified name is simply filled in.                                                                            3.a Rename.png3.b Rename.png
  4. To extract the sums of the remaining groups overall regardless the different attributes, a new column for each age group has been created, eg. Age 0-14 and Age 0-14 (4+ nights). The “Calculation” button on the upper right corner is selected and a “New Calculated Measure” is created.4.a Calculated Measure.png
  5. The Measure Name (“Ages xx-yy (all)”) and the Formula are filled in. To merge two columns the measures are selected from the list and connected with a “+” in between.                                                   4.b Calculated Measure.png
  6. Finally, there is the need to create some Measures that will sum the Expenses made by the groups to be used in the analysis. To do that the attribute of the table is spotted, and by selecting the wheel beside it, the measure is created.5.a Create a measure (total expenses).png
  7. The produced measure appears on the Measure list by a default name. It can be renamed as wished.5.b Create a measure (total expenses) 2.png

Visualization

  1. In order to conduct a visualized analysis for easy comprehension and clear information, the “Visualize” aspect on top of the screen is selected, and then the appropriate version of charts. Note that the chart may be changed again later on, as the analysis proceeds.6.a Visual - Chart.PNG
  2. To create the charts to conduct the analysis, attributes and measures are dragged to the appropriate positions (X axis, Y axis, Legend Colour etc) or are chosen after the “+” button is selected.               6.b Visual - Add.PNG
  3. During the analysis it is helpful for the different visualizations to be saved for future reference. To do this note to select the “Save” button on the down right corner. Also, the “+” sign is used to create a new chart, while a wheel on the miniature picture gives the option to duplicate the chart.6.c Visual - Save.PNG

Compose a Storyboard

  1. After the visualizations are prepared, it might be interesting to view them in a collective way, through a storyboard. Therefore, the “Compose” aspect is selected and a new story in created. One story may have a series of boards. To create a new board select the “+” sign in the right, bottom corner. To create a new story select the appropriate option the right, up corner.7.a Compose.PNG
  2. Every board can have one or more charts prepared in the “Visualize” aspect of Lumira. To create the board, the appropriate charts are dragged and placed.                                                                  7.b Compose.png
  3. Lumira gives the opportunity to customize the boards so they appear attractive and provide clear information. For more information on how to prepare a storyboard, an amazing tutorial can be found here: http://scn.sap.com/docs/DOC-47211 .

Share on Lumira Cloud

Firstly, an account needs to be created on Lumira Cloud. To do that, access the website (https://cloud.saplumira.com/landing-page.jsp) and Register a New Account. After that, the work can be published in two different ways.

1. Lumira Cloud.png

  1. Locally from Lumira application
    1. “Share” aspect on top of the screen is chosen and the appropriate storyboards are selected. After that “Publish to SAP Lumira Cloud” is selected.2.a Cloud.png
    2. The user needs to connect to his account. Note, that users cannot connect from the “Corporate Network”, and should swap to “SAP Internet” or another network.                                                 2.b Cloud.png
    3. The Dataset and Storyboard to be sent to Lumira Cloud are shown in the screen. If the files are being updated the system locates the ones on the cloud and asks the user to verify the change. Otherwise, new files are created on the cloud.2.c Cloud.png
  2. Logging on the account through the browser.
    1. “Upload” option is chosen and the “Browse” button is selected. By default the Lumira Documents are saved on MyComputer/C: /Users/UserxI/MyDocuments/SAPLumiraDocuments in the “.lums” format.3.a Local.png
    2. After that the system informs that the file is uploaded successfully.3.b Local.png
    3. To share, the wheel by the document is selected and the “Share” option is chosen.3.c Local.png
    4. The users can be invited either through email, where there are two user options for Viewers and Editors, or by copying the URL provided by the system.                                                           3.d Local.PNG

That were some easy steps followed for the Greek Tourism Data analysis. To see the deliverable of this analysis, please visit the following link: http://goo.gl/KLqlew. I hope you enjoyed it and that you will find it useful for your own analysis!

If, however, you need more information on how to use Lumira check the following posts:

  1. General walkthrough of the application http://scn.sap.com/docs/DOC-52764
  2. Full video on use of Lumira http://www.saphana.com/docs/DOC-4458
  3. Create Storyboards https://cloud.saplumira.com/landing-page.jsp
  4. Share Visualizations and Datasets http://scn.sap.com/docs/DOC-43011 
To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply