Skip to content

Latest commit

 

History

History
83 lines (43 loc) · 3.33 KB

README.md

File metadata and controls

83 lines (43 loc) · 3.33 KB
Raw

Exercise 20 - Identify Top-Performing Sales Managers with Just Ask

📝 Note: This is an OPTIONAL exercise.

🔰 Detour: SAP Analytic Cloud - Just Ask

Just Ask is the natural language query feature powered by artificial intelligence in SAP Analytics Cloud. It offers an easy and efficient way to ask questions about your data and provides fact-based answers in the form of tables and charts.

End of Detour

Start of Exercise

In this exercise, we will utilize Just Ask to query our data model by asking questions in everyday English. Our goal is to identify the best sales managers in our company.

  1. Access the SAP Analytics Cloud tenant you got access to as part of the basic trial.

💡 Note: The system may ask you to sign in again. Use the same user name and password for SAC as for Datasphere.

  1. Select the menu Just Ask in the header.

  2. Close the welcome guide, if opens.

  3. Click the model icon left to the search bar and select "Add Model to Search".

  4. Select DSP as the connection on the left panel, choose your space, and click on the previously created Analytic Model Sales__Analytic_Model.

  5. The Successfully Added message will appear with the information that this model will only be available during the current sessions. Click OK.

  6. Now enter your question into the search bar: Who is the best sales manager based on revenue?

    To run the search, press enter or click on the magnifying glass symbol.

  7. The search result is displayed as a card under the search field.

    Kiran Raj is identified as the sales manager generating the most revenue. You can review the automatically applied settings, such as sorting and ranking, in addition to the correctly identified attribute and measure.

  8. Compare him with the other sales managers. This time, the result should be displayed as a pie chart. Enter the following in the search bar on the top and search: Show revenue by sales manager as a pie chart .

  9. The pie chart below is displayed. Kiran Raj is responsible for 20% of the generated revenue.

  10. Can we see peaks for the revenue generated by Kiran Raj? Enter Revenue of Kiran Raj by month and search.

  11. The chart visualizes the change of generated revenue. A filter is defined for sales manager and the drill level for the transaction date was adjusted to display months.

  12. If you prefer to view the query result in a table format, you can change the display mode to a table.

Summary

Just Ask simplified and accelerated the process of finding answers to your reporting questions. Using the data model exposed by SAP Datasphere, you were able to obtain answers quickly without requiring any preconfigured data report.

You can continue with one of the optional exercises: