BI On Demand Data Visualization – User Training

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.

Go to Add New –> Add Template

Enter Your Visualization Name and Description. Then click Next.

Here I am going to show Customer Analysis.

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

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

Now Select Column Chart from Components.

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

After that you will be having as below chart.

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.

Select Open Preview

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.

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

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

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

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

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

Run your visualization and you can have following