After consolidating the data from your company with public data, we want to visulaize the data. This means we will start the SAC and choose the dataset we just created. Next we will create a small visualization.
- Open the SAC. By clicking the menu in the left upper corner and choosing the SAP Analytics Cloud.
- Open the "Story App" clicking on the "Story"-symbol.
3.Create a new story by clicking on the icon. Choose a "Classic Design Experience". Right now this gives you the most features.
- To start creating your first visualization, lets have a look at the data. We do this by clicking on the "table"-icon.
- To use a dataset for the first time we have to load the model from the DWC once. If we want use it in the Story later we do not need to do that step again. Use "SAPDWC" as the connection. Choose your "GXXXXX" named Space and choose your "v_my_company_sales" analytical view.
- In our case we have to choose the "SAP Data Warehouse Cloud Analytical Dataset". And click on the "SAPDWC" connection. Now choose your space (G). And choose the v_company_sales.
- Add the "product" Dimension to have a look at the data.
Now instead of the Sales Data lets import the Perspective we created.
- Create a new table by clicking the table-icon. change the data source by clicking the pen-icon. Click ok, on the warning message (as we want to change the data source).
- Choose your perspective.
- Now click on the save-button and save your story.
- Click the x-Button on the Filter to show all your story.
- Lets choose the "brand" as a "Row".
- Now lets create a sample visualization. Click on the chart-icon.
- Choose "Marketshare" as a measure. Choose "brand" as a Row (expand "V_MY_COMPANY_PRODUCT" to see all possibilities).
- Next click on "Filter" and exclude "Null".
- Add a reference line to see how close your company is to its goal.
Now you have created a visualization for your company. This is how it looks:
