Submit your answers to the questions in the Chapter 1 Exercise 1 document (see attached). When submitting answers be certain to restate the question so as to make it clear what question is being answered. Create a single word document with the answers and include graphs and tables where appropriate to support your answers.Access SAP Business Objects via the following link: http://munich.cob.csuchico.edu:8080/BOE/BIthe link below is the assignment with questions 12-21 but only do 18-21. Thanks.
chapter_1_exercise_1.pdf
Unformatted Attachment Preview
SAP BusinessObjects Explorer
CHAPTER 1: EXERCISE 1
DATA EXPLORATION WITH SAP EXPLORER
NITIN K ALÉ, U NIVERSITY O F S OUTHERN C ALIFORNIA
NANCY J ONES, S AN D IEGO S TATE U NIVERSITY
OBJECTIVE
Self-service data exploration with SAP BusinessObjects Explorer. Explore GBI sales data to find top
customers and products.
ACTIVITIES
§?
Load sales data
§?
Explore data with charts and tables
§?
Filter, sort, and rank
SOFTWARE PREREQUISITES
?
Web browser
UCC PRODUCTS REQUIRED
1 Practical Analytics by Nitin Kale & Nancy Jones © 2015
SAP BusinessObjects Explorer
?
SAP BusinessObjects Explorer
DATA REQUIRED
?
GBI dataset is available in GBI_Data_E1_1.xlsx
SCENARIO
Kumar is a new intern at GBI. He is working in the sales department with Nina Kane. On the first day at
work, he is given a dataset for GBI historical sales. He has been asked to explore these data to
understand some of the trends of GBI customers and products.
EXERCISE
1. Login to SAP BusinessObjects Explorer
2. Open SAP BusinessObjects Explorer using this icon.
3. In the SAP BusinessObjects Explorer app, load the file GBI_Data_E1_1.xlsx
4. Click Preview and Configure
5. In the Preview screen, you will see Figure 1
6. You can make changes here if you want. Explorer automatically categorizes the data in the Excel
file as label or number etc. based on the data it finds in each column.
7. Click OK
8. Explorer presents its initial data visualization.
9. You can filter, sort, and rank the fields as you like.
2 Practical Analytics by Nitin Kale & Nancy Jones © 2015
SAP BusinessObjects Explorer
10. Several charting options are also available.
11. Being a self-service application, Explorer is easy to use. Help Kumar answer the following
questions
Figure 1: Explorer preview
12. What is the revenue for Germany?
13. What is the revenue for 2008 in US?
14. What product has the highest revenue?
15. Show the revenue trend over years.
16. Show the revenue trend for US and Germany over years.
17. What is the total sales quantity for the top 5 customers?
18. What is the highest percentage of revenue provided by a bike (no accessories) in
Germany?
19. Using a Tag Cloud, show what product has the highest revenue.
20. Is there seasonality in sales quantity? Which month has the highest sales quantity?
21. What day of the month brings in the highest revenue?
3 Practical Analytics by Nitin Kale & Nancy Jones © 2015
…
Purchase answer to see full
attachment
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more