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.
After that you will be having as below chart.
Now Perform below steps
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |