Analyze Data in Charts and Tables
- How to analyze difference between segments within charts
- How to drill down on specific segments
- How to sort data in charts
- How to rank data in charts
- You have access to an SAP Analytics Cloud account
You’ve now gained a solid understanding of stories and learned how to interact with a story through filters. Now, go through some analytical features within SAP Analytics Cloud stories.
- Step 1
When analyzing data, you will often need to compare values between different data points. To quickly see the difference between two data points, you can click to select the first data point then hover over the second data point.
The difference is then displayed in absolute value and percentage. If you would like to see the difference longer, you can simply click the second data point instead of hovering.
- Step 2
Next, let’s look at how you can drill up and down the data in the charts. If hierarchical dimensions are included in a chart, you can drill up or down through dimensions to explore the data at different levels.
As an example, let’s say you want to dig deeper into the average gross margin of the Cities within Nevada to understand why Nevada has the lowest gross margin. Here, you can drill down into the Nevada location dimension.
Consequently, you can see the average gross margin for the cities within the Nevada state.
Date hierarchies may look like Year > Month > Day while Geo hierarchies may look like Country > Region > City.
- Step 3
Next, is the ability to sort your data. You can specify the sort order for data in your chart for measures and dimensions: alphabetical ascending or descending, highest to lowest, and so on. Simply right click the chart and select sort, then choose the measure or dimension you want to sort by and the sort direction.
In the example above, the chart is immediately updated and shows the Locations sorted from the Highest to Lowest Gross Margin % within each Product group.
You can also sort dimension and measure values within tables. Sorting your tables can give you a better understanding of your data and intuitively provides a rank of your data. Within the table of the Sales Manager Overview page, right click the 2016 column > Sort Options > Sort Descending.
- Step 4
In addition to sorting, you may also want to show your data ranked from top to bottom, or vice versa, for your analysis. The Rank feature allows you to choose rank options such as Top 5, Bottom 5, or Top N (any number) in your charts and tables. Let’s look at how this works with an example.
You can apply the same ranking to All Dimensions or you can select one dimension and apply ranking to it. The ranking options available are:
- Top 5
- Bottom 5
- Top N Options:
- Mode - Top or bottom
- Value - used as the number of values you want to include in the filters
- Dimension - Select all dimensions or a specific dimensions
- Cross Calculation
- Step 5
Lastly, let’s explore a few more useful features that are included in SAP Analytics Cloud stories.
Compound Growth Rate (Represented as CGR)
CGR is a measure of the average rate of growth experienced over a multi-year period. It is often used to evaluate and compare how different projects, investments, or categories have performed over time. Here, SAP Analytics Cloud provides an easy way to add CGR evaluations into your visualizations.
In the Chart Action Menu of the chart, select + Add > CGR.
Pin to Home
Pin to Home allows you to pin visualizations to your home screen for easier access to monitor your key metrics. The pinned visualization keeps the original context and data connectivity so that the latest data is always displayed.
To pin a chart to your homepage, select the Chart Action Menu > Pin to Home.
Consequently, the chart you pinned will show up on your Home page.
Export Chart Data
Lastly, you might want to export data from certain charts and view them through a Comma Separated Value (CSV) data sheet. This is possible and simple to execute. Select Chart Action Menu > Export.
In the “Export as CSV” window, you can specify the Name of the file download, select to Include Formatting, and change the field separator of the CSV through the CSV Delimiter.
- Step 6
In the question area below, pick one multiple choice answer and then click Submit Answer.
What is the percentage difference between Gross Margin % of Alcohol in California and Juices in Nevada?