You now have access to a live sample database with over 1 million records.
0
Drive sales performance to the next level with SAP HANA
- Instantly analyze vast amounts of sales pipeline data
- Identify and respond to pipeline issues in real-time
- Access complete, up-to-date data on any device
1
The Challenge
Your company is a diversified multi-national organization with a revenue of $5 billion. Your job is to keep track of the sales pipeline and increase the performance of your sales team.
Use SAP Sales Pipeline Analysis to do real-time analysis and draw the deep insights needed to accelerate sales. Choose a level to begin.
Senior Director, Sales
Vice President, Sales
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.
Terminology: Revenue for future dates means opportunity value weighted by chance of success based on pipeline stage, also known as Weighted Expected Revenue. Planned Revenue includes all opportunities without any probabilty of success weighting.
You will be scored on accuracy and time.
3
What was the revenue for all opportunities in 2011?
Less than $2B
Between $2B and $3B
Between $3B and $4B
Between $4B and $5B
More than $5B
0
0
Click or mouse over the appropriate 2011 column in the upper left panel.
The revenue for 2011 was $2.93B.
The revenue for 2011 was $2.93B.
You were able to search and summarize 1.5 million records in seconds.
Click or mouse over the Revenue column for 2011 in the upper left panel to see the Revenue for 2011.
Which country had the highest revenue in the two year period 2011-2012?
CN - China
DE - Germany
GB - Great Britain
JP - Japan
US - United States of America
0
1
Look at the Revenue pie chart in the upper right panel. Mouse over each wedge to see values and percentage for each wedge.
Great Britain had the most revenue for those two years.
Great Britain had the most revenue for those two years.
With Sales Pipeline Analysis, powered by SAP HANA, easily configured dashboard views can be saved to provide answers at the speed of thought.
Look at the Revenue pie chart in the upper right panel. Mouse over each wedge to see values and percentage for each wedge.
What was the revenue for 2011 in Great Britain?
Approximately $1.57B
Approximately $.70B
Approximately $.87B
Approximately $2.16B
0
2
Narrow your data to just 2011 by selecting the "Year" facet at the left. Where can you see the total revenue for just Great Britain?
In 2011, the revenue for Great Britain was a little over $.70B
In 2011, the revenue for Great Britain was a little over $.70B
Did you narrow the data to just 2011 by selecting the "Year" facet at the left? The dollar value for Great Britain opportunities can be seen by passing your mouse over the GB pie segement in the upper right panel.
Which sales channel generated the most revenue in 2011?
Campaign
External Partner
Incoming Call
Internet
Roadshow
0
3
Narrow your data to just 2011 by selecting the "Year" facet at the left. Where can you see the revenue from each channel?
Incoming call had $.56B in expected weighted revenue in 2011
Incoming call had $.56B in expected weighted revenue in 2011
Narrow your data to just 2011 by selecting in the "Year" facet at the left. The barchart in the lower left panel shows Revenue by Sales Channel.
What is the revenue in Japan for Notebook Basic 15 in 2012?
Approximately $316M
Approximately $108M
Approximately $4.8B
Approximately $2.0B
0
4
You will need to narrow your selection by two facets on the left.
In 2012, the Revenue for Notebook basic 15 is approximately $108M
In 2012, the Revenue for Notebook basic 15 is approximately $108M
Remember to narrow your selection by both "Year" and "Country" facets. Revenue by Product is shown in the lower right panel.
For these more detailed questions, Click <Home> and <Pipeline> to explorer the complete pipeline information space.
What is the top revenue product in Europe for 2011?
Notebook Professional 17
Notebook Professional 15
Notebook Basic 17
Notebook Basic 15
1
0
Choose "2011" and "Europe" as narrowing facets. Then, display "Products".
Notebook Professional 17 is the top revenue product in Europe for 2011
Notebook Professional 17 is the top revenue product in Europe for 2011
Choose "2011" and "Europe" as narrowing facets. Then, display "Products".
What is the product order quantity for Notebook Professional 17 for Quarter 1 of 2011?
29,944
1,782,643
459,311
451,524
1
1
Choose "Product Order Quantity" as the measure. Use "20111" and "Notebook Professional 17" as narrowing facets.
Quarter 1 of 2011 had product orders totaling 451,524.
Quarter 1 of 2011 had product orders totaling 451,524.
Choose "Product Order Quantity" as the measure and two narrowing facets: "20111" for the Quarter and "Notebook Professional 17" for the Product.
You are a global player with strong presence in the USA, Japan, China, Germany and GB.
What is the country that had the lowest performance in selling Notebook Professional 17 in the last 2 years?
CN - China
DE - Germany
GB - Great Britain
JP - Japan
US - United States of America
1
2
What measure should you use? What facets? How do you compane countries?
China only had approximately $244M in Revenue.
China only had approximately $244M in Revenue.
Choose "Revenue" as the measure, "Notebook Professional 17" as a narrowing facet, and display Countries in the barchart.
Who do we expect will buy the most Notebook Professional 17 in 2012?
China Electronics
Ketiv Technologies
Media Store London
Media Store East
West Japan Computers
1
3
"Product", "Year", and "Customer"
We expect Media Store London will buy the most Notebook Professional 17
We expect Media Store London will buy the most Notebook Professional 17
Choose "Revenue" as the measure, "2012" and "Notebook Professional 17" as narrowing facets, and display "Customer" in the barchart.
Identify the largest single 2012 opportunity with the status of "In-Process". Who is the customer we are trying to sell to?
Media Store North East
International Japan Computers
Tetro AG
Meier AG
1
4
Note that this is any opportunity. Not just a weighted value. Find the opportunity, then using the opportunity ID as the narrowing facet to determine the name of the customer.
International Japan Computers is the customer for the largest opportunity, with a Planned Revenue value of $199,000
International Japan Computers is the customer for the largest opportunity, with a Planned Revenue value of $199,000
Choose "Planned Revenue" as the measure, "2012", and "In Process" as narrowing facets to find the single highest opportunity. Then, add that single opportunity as a facet to identify the customer.
