Skip to Content

Subject: Data Visualization using SAP BusinessObjects BI On Demand

Purpose: Data Representation

Target Users: Executives/Managers/Business Analysts who want to represent their data with graphics/charts/visualization without any IT help.

Data Source: Excel Sheet


Go to https://bi.ondemand.com/session/new

Enter Your User ID and Password.

1.PNG

Go to Add New –> Add Template

2.PNG

Enter Your Visualization Name and Description. Then click Next.

Here I am going to show Customer Analysis.

3.PNG

When It is asking for User Agreement, please select I Agree.

Here I am going to design a dashboard based on excel sheet you can find this excel sheet at

https://docs.google.com/spreadsheet/ccc?key=0Aju9jodYrDRPdGZ2a3BYVjdDMHdIWTZmWnd3SmVnbkE#gid=0



Now select as shown in snapshot

4.PNG

After Uploading Excel Sheet, you can have your data as shown below

5.PNG

Now Select Column Chart from Components.

6.PNG

  1. Now go to Data- -> By Range and Select Your Data Range from Sheet–> Ok

7.PNG

After that you will be having as below chart.

8.PNG

Now Perform below steps

  1. Go to Appearance in Property–> Layout–> Unselect Chart Background
  2. Go to Appearance in Property –> Axes –> Horizontal Gridlines –> Unselect Show Minor Gridlines
  3. Go to Appearance in Property –> Text –> Select Mouse Over Values -> Select Data Labels –> Select Series1
  4. You can change Text Format and Size from Format Selected Text.
  5. You can also change theme for your visualization by selecting Themes as shown below.

8.PNG

Select Open Preview

9.PNG

You can have your visualization in new tab.

Greetings !!!!!!

You have successfully created a data visualization/dashboard by your own.

Best Regards.



Training on Selectors:


In this blog, data visualization was covered now this training is more on visualization. In this we are using selectors for data selection in dashboard.


For this we will use an updated excel sheet available at here.


https://docs.google.com/spreadsheet/ccc?key=0Aju9jodYrDRPdHQxLU1kalVaRV91dlFJaGtoQktfb3c&usp=sharing


Log in to BI On Demand & Import New Excel Sheet as described in steps earlier in this training.


After importing a new excel sheet, you must be having following status at your end.

bi1.PNG


In previous session we have done visualization on Customer Analysis, we will do same but for selected State and City only. So here selection comes into picture.


We will use Selectors

bi2.PNG

Now Select two Combo Box from selectors and assign title as shown below.

bi3.PNG

Now set properties for “State” combo box as shown below.

bi4.PNG

Set properties for “City” combo box as shown below.

bi5.PNG

Now Select a Column Chart and set its properties as shown below.

bi6.PNG

Run your visualization and you can have following

bi7.PNG





To report this post you need to login first.

10 Comments

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

Leave a Reply