Skip to Content

It is my pleasure to participate Data Geek Challenge, I am not the Data Geek, but through this challenge I just tried. 🙂

Introduction

Due to my interest on traveling, I choose the travel & tourism data for analysis.

Most of the statistical data we received from Singapore Tourism Board https://app.stb.gov.sg/asp/index.asp , some of them shared by fellow sap mentor Clint, few from my manager. Now I am getting into the challenge with my small and big data.

How did we prepare for the data?

Since we get the data from multiple data sources, most of them are RAW data. Raw data doesn’t mean from txt format, for a change we downloaded the PDF version of statistical data and try to go.

/wp-content/uploads/2012/11/dg1_155245.jpg

We copied the raw data into txt file, later moved to excel by using Text Import

/wp-content/uploads/2012/11/dg2_155292.jpg

Text import feature in Excel and the other data manipulation options in SAPVisi, finally given kind of meaning full source data for analysis. Now the data ready for analysis.

/wp-content/uploads/2012/11/dg3_155293.jpg

What did we analyze and manipulate the data using SAPVisi?

As I understood SAPVisi is a column based tool. So when giving a raw data source you need to make sure whether the data is properly aligned for analysis.

For instance in our case, we would like to analyse

  1. Compare Number of visitors arrived last year by air and by land? (based on year)
  2. Compare the visitors between the countries and find out country from more visitors ( based on country)

But the input data are same, for this we need to change the row and column of the excel sheet accordingly using Text transpose, and Merge option in SAP Visi.

Comparison of Number of visitors arrived on last year by air/By Land

/wp-content/uploads/2012/11/dg4_155294.jpg

Compare visitors in the country and identify the highest country

/wp-content/uploads/2012/11/dg5_155295.jpg

What are the SAPVisi features we used?

Since the scenario has country included we use “Create Geography Hierarchy”.

/wp-content/uploads/2012/11/dg6_155296.jpg

For using this we get the analysis report in the geographical chart

/wp-content/uploads/2012/11/dg7_155300.jpg

When I merged two data sets, I used lots of manipulation function (Rename column name, remove column name, replace the value in the column) to bring the data appearance in the meaning full way.

/wp-content/uploads/2012/11/dg8_155301.jpg

Grouping the countries into South part/Northern Part and also grouping the month into Quarter

/wp-content/uploads/2012/11/dg9_155302.jpg

This helps to give the quarterly report as here

/wp-content/uploads/2012/11/dg10_155306.jpg

Merge two data sets. This helps us to provide compare air visitors and land visitors.

/wp-content/uploads/2012/11/dg11_155309.jpg

We almost used with all kind of Chart Types. For instance, below shows the delayed, on time and canceled airline code using bubble chart.

/wp-content/uploads/2012/11/dg12_155310.jpg

We used almost all the filtering option, below are Filtering the flight using airport code.

/wp-content/uploads/2012/11/dg13_155312.jpg

Filter option with the stacked column value provide the detail list of criticality in ticket processing data shared by my manager.

/wp-content/uploads/2012/11/dg14_155311.jpg

There are lots of pre built available as like in excel, we used only year function to return the year from the date.

/wp-content/uploads/2012/11/dg15_155313.jpg

Share” , this is the other feature which I used to share with my manager.

/wp-content/uploads/2012/11/dg16_155314.jpg

Edit display color using preferences

dg17'.jpg

What Business questions did we answer?

Using SAPVisi, we could easily answer

  1. Analyze monthly statistics for tourists visit in Singapore?
  2. How much the hotel revenue in the year 2011 by the tourists visit?
  3. Flight requirement and delay statistics?
  4. Analyze Male and female including age group tourist visitors in Singapore?

More analysis shared in the video here

Once again Thanks a lot for all who had given such a wonderful opportunity to me.

To report this post you need to login first.

1 Comment

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

  1. Alexandra Carvalho

    Hi Jansi,

    Great demonstration of SAP VISI. It’s good to see the data cleansing and manipulation functionality being used!

    Thanks for sharing with us.

    Cheers,

    Alexandra

    (0) 

Leave a Reply