Skip to Content

Recently I came across to a documentation from other BI vendor on how to create a Box Plot chart using their tools. Many steps taken just to create a Box Plot chart, so I’m curious how’s the workflow for creating Box Plot chart using SAP Visual Intelligence.

So I will be using stock data from my property developer in Indonesia with stock ticker ASRI using the data sent monthly by my securities company.

As I am using stock data so please don’t confuse between OHLC (Open High Low Closed) chart and Box Plot chart. Details explanation you could find on Wiki Page here

http://en.wikipedia.org/wiki/Open-high-low-close_chart (OHLC)

http://en.wikipedia.org/wiki/Box_plot (Box Plot)

Step 1 – Prepare MS Excel Data

– Using the data from 2007 to current 2012 (1202 records) this is what I’ve got in MS Excel format that will be used as my data source

/wp-content/uploads/2012/11/1_160067.png

Step 2 – Acquire MS Excel Data

– Open Visual Intelligence and choose MS Excel as my data source and browse to the Excel file I saved before and click on Acquire button

/wp-content/uploads/2012/11/2_160068.png

Step 3 – Enrich Semantic Elements

– After the data being Acquired there’s 9 semantic elements detected and I just click Enrich All button

/wp-content/uploads/2012/11/3_160069.png

– After Enriching, SAP Visual Intelligence know my field that contain date and make Time hierarchy based on that field

/wp-content/uploads/2012/11/4_160070.png

Step 4 – Creating the Visualizations

– Click on the Visualize button and choose Box Plot chart

/wp-content/uploads/2012/11/5_160071.png

– Adding Open measures to Y Axis 1 and Time hierarchy to X Axis

/wp-content/uploads/2012/11/6_160072.png

– As above image shown there’s no whisker for the Box Plot, it’s easily set by choosing from Year to Quarter, Month or Day. As shown below using Month as selection

/wp-content/uploads/2012/11/7_160076.png

– By adding more measure such as Close, Low and High, I could achieve the following nice Box Plot chart for the Visualization

/wp-content/uploads/2012/11/8_160077.png

Conclusion

Using SAP Visual Intelligence the workflow is much less with just 4 steps from Raw Data to Great Visualizations

To report this post you need to login first.

1 Comment

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

Leave a Reply