You now have access to a live sample database with hundreds of thousands of records.
SAP HANA
Real-time insight for a hyper-connected world
0
Customer Usage Analytics, Powered by SAP HANA
- Gain a granular view of customers consumption patterns
- Rapidly detect behavior shifts and unexpected trends
- Analyze the impact of revenue sharing models
1
The Game
You work for RapidComm - a mobile communications provider with annual revenue of $10B.
Your challenge is to grow the business and maximize profits in a highly competitive, fast changing environment.
Choose a department and see how fast you can win.
Finance
Marketing
Content
2
Playing The Game
1. Read the question in the sidebar on the right.
2. Use SAP BusinessObjects Explorer to select and segment data in real-time with SAP HANA.
3. When you are ready, choose your decision from the choices on the right. If you get stuck use the hint.
You will be scored on accuracy and time. All amounts are in the thousands of dollars ('000s)
3
What was the prepaid revenue generated in 2010?
Less than $2 billion
Between $2 billion - $3 billion
Between $3 billion - $3.5 billion
More than $4 billion
0
0
Clicking on "Prepaid Revenue" under "Measures" on the left. Then select "2010" in the "Year" column.
RapidComm had $3.47 billion in prepaid revenue in 2010.
RapidComm had $3.47 billion in prepaid revenue in 2010.
You were able to search through millions of records to find the answer in only XXXXX.
To find it, try clicking on "Pre-paid Revenue" under "Measures" on the left. Then select 2010 in the Year column.
What where the two main categories of postpaid revenue in 2011
Data & Voice
Messaging & Content
Voice & Messaging
0
1
Select "Postpaid Revenue" from the "Measures". Then click on "2011" under "Year" and display the "Category" bar chart.
Data & Voice contributed $9.96 billion in revenue to the company in 2011.
Data & Voice contributed more than than $9.96 billion in revenue in 2011.
You combined millions of records to find your answer in only XXXXX.
To find that answer, Select "Postpaid Revenue" from the "Measures". Then try clicking on "2011" under "Years" and look under the "Category" list.
Which percentage of the Postpaid Revenue, generated in Q3 of 2011 is still unpaid?
17.14%
25.52%
74.48%
0
2
Select "Postpaid Revenue" from the "Measures". Then click on "2011" under "Year" and "Q3" under "Quarter". Use the Percentage chart type and display the pie chart for "Paid or UnPaid"
The unpaid portion represents 25.52% of the Postpaid Revenue billed in Q3 of 2011.
The unpaid portion represents 25.52% of the Postpaid Revenue billed in Q3 of 2011.
You were able to search through millions of records to find the answer in only XXXXX.
To find this answer, Select "Postpaid Revenue" from the "Measures". Then click on "2011" under "Year" and then click on "Q3" under "Quarter", and sort by Paid or Unpaid.
Your skills are being noticed! You have been asked to help the Marketing team.
<
How many of the top 5 postpaid plans in Q4 2011 were data plans?
1
2
3
5
1
0
Try clicking on "Postpaid Revenue" under "Measures" on the left. Then select "2011" under "Year", Select "Q4" from "Quarter", and display the "Plan Name" bar chart.
2 Data Plans were in the Top 5 in Q4 2011. (75 MB and 100 MB Data Plans)
2 Data Plans were in the Top 5 in Q4 2011. (75 MB and 100 MB Data Plans)
You were able to search through millions of records to find the answer in only XXXXX.
To find this answer, Try clicking on "Postpaid Revenue" under "Measures" on the left. Then select "2011" under "Year", Select "Q4" from "Quarter", and sort by Plan Name.
Which age group particularly favored the postpaid 75MB Data plan in Q4 2011?
15-24
45-54
65-74
1
1
Try clicking on "Postpaid Revenue" under "Measures" on the left. Then, select "2011" under "Year" and "Q4" from "Quarter". Next, select "75MB Data Plan" under "Plan Name" and sort by "Age Group"
With over $72 million in revenue, the 45-54 age group was the largest adopter of the 75MB Data plan in Q4 2011.
With over $72 million in revenue, the 45-54 age group was the largest adopter of the 75MB Data plan in Q4 2011.
You found that answer in only XXXXX.
To find this answer, Try clicking on "Postpaid Revenue" under "Measures" on the left. Then select "2011" under "Year", Select "Q4" from "Quarter", select "75MB Data Plan" under Plan Name and sort by Age Group.
Which day of the week generated the most postpaid revenue for the 45-54 age group in Q4 of 2011?
Sunday
Monday
Tuesday
1
2
Choose "Postpaid revenue" under "Measures" on the left. Then, select "2011" under "Years" and "Q4" from "Quarter". Next, select "45-54" from "Age Group" and sort by "Day of the week".
Sunday was the highest revenue generating day for the 45-54 age group.
Sunday was the highest revenue generating day for the 45-54 age group.
You were able to search through millions of records to find the answer in only XXXXX.
To find this answer, choose "Postpaid revenue" under "Measures" on the left. Then, select "2011" under "Years" and "Q4" from "Quarter". Next, select "45-54" from "Age Group" and sort by "Day of the week".
The CEO has asked you to help the Content team analyze revenue sharing models!
How much cumulative revenue (postpaid and prepaid) was generated in the Content category for 2010 and 2011 combined?
Less than $50 million
$50 million - $100 million
More than $100 million
2
0
Choose "Postpaid Revenue" and "Prepaid revenue" from the list of measures. Then choose "2011" and "2010", under "Year". Finally Select "Content" under event "Category"
In 2010 & 2011, the revenue for Content was almost $102 million.
In 2010 & 2011, the revenue for Content was almost $102 million.
You were able to search through millions of records to find the answer in only XXXXX.
To find this answer, Choose "Postpaid Revenue" and "Prepaid revenue" from the list of measures. Then choose "2011" and "2010", under "Year". Finally Select "Content" under event "Category"
How much was paid (postpaid and prepaid) to partners in the Content category for 2011?
Less than $15 million
$15 million - $30 million
$30 million - $50 million
More than $50 million
2
1
Choose "Prepaid Payables" and "Postpaid Payables" from the list of measures. Then choose "2011" under "Year" and sort by "Category"
The amount paid to partners in 2011 for content consumption was $35.7 million.
The amount paid to partners in 2011 for content consumption was $35.7 million.
You found your answer in only XXXXX.
To find this answer, Choose "Prepaid Payables" and "Postpaid Payables" from the list of measures. Then choose "2011" under "Year". Then, sort by Event Class is "Content".
Which segment contributed the largest payments to Electronic Arts for the use of the "EA Madden Football" app in 2011?
Prepaid
Postpaid
2
2
Select "Prepaid Payables" and "Pospaid Payables" from the Measures. Select "2011" under "Year" and then sort by "Content Name"
More royalties were paid thanks to postpaid activities for the Gaming app EA Madden Football.
More royalties were paid thanks to postpaid activities for the Gaming app EA Madden Football.
You found your answer in only XXXXX.
To find this answer, Select "Prepaid Payables" and "Pospaid Payables" from the Measures. Select "2011" under "Year" and then sort by Content Name (use the explore button to filter the content name list).
