Beginner’s SAP Analytics Cloud Journey: Day1
Dear SAP Analytics Cloud beginners,
This is a blog post for beginners in SAP Analytics Cloud. I also started learning SAP Analytics Cloud from August 2021. I’d like to share my trial and error from a beginner’s point of view, and hope it helps you get started easily!
Day1: Time Series data
Time series data is a sequence taken at a successive equally spaced points in time and sequence of discrete-time data(reference: Wikipedia). Examples of time series data are weather forecasting, historical sales data and historical stock prices. Time series data analysis allows you to find factors that affect a particular variable over a given period of time.
Before create time series data chart in SAP Analytics Cloud, please refer to the pre-requisites as follows.
- Sign-in SAP Analytics Cloud using your email address and you can get the trial for free.
- The total usable time of the SAP Analytics Cloud free trial is 90 days
- Link to SAP Analytics Cloud
- Link to SAP Analytics Cloud Trial
Create chart using aggregated time series data
Step1: Create time series data in Excel.
Time series data in excel
Step2: Create new story
Step3: Add data
Step4: Click data uploaded from a file
There are three options to add data. (Please click the “data uploaded from a file”)
- Data uploaded from a file
- Data from a datasource
- Data from a existing dataset or model
Step 5: Select source file and click Import.
Step 6: Create Dataset from File
Step7: Check Measures and dimensions
When uploading the data, default Measures are as below. But, to analyze the data, it requires to transpose the data from columns to rows in the next step.
Step8: Transpose columns to rows
To analyze the Time Series data, the structure of data has to be transposed.
You can check the transposed dataset as below. Now, data is prepared and you can create chart!
Step9: Insert chart
Click insert chart and select the “Comparison: Combination stacked column & Line” and “Trend: Line” in this tutorial.
Step10: Create calculation
We can use calculated values as Column Axis. Please click the red box, “Create Calculation”. You can create the calculation using “Calculation Editor”.
In this tutorial, firstly, I create the “Type:Aggregation calculation” using SUM of value. The Aggregation dimension is by monthly.
Calculation: Sum of Value
In addition, I create the “Type:Aggregation calculation” using AVERAGE of value. The Aggregation dimension is by monthly.
You can check two comparison chart and two Trend chart as below.
Step11: Edit custom order
In this tutorial, the member order is not a monthly order, for example, Apr-Aug-Dec-Feb….
But you can edit Member order by monthly, please click the yellow box to edit/create custom order.
Please create custom order with “Add Custom Order”
You can drag and drop by monthly order as below.
You can also apply created Custom Order to the other chart.
You can check the finalized the two comparison chart and two Trend chart as below.
Create chart using non-aggregated time series data
Above example was creating chart using aggregated time series data by monthly. But, normally, we have time series dataset such as 01/Jul/2021, 02/Jul/2021, 30/Jul/2021 and others. In this section, we will create the chart using unaggregated time series data.
This is an example of a time series data set containing document numbers, dates, and quantities. The example data was generated using the Excel random between function. (If you’re working on a logistics area, the dataset will be familiar.)
Step1: Upload dataset
Step2: Check Measures and Dimensions
Step3: Create chart-Trend:Time series
You can create chart Trend:Time Series as follows.
Step3: Create chart-Trend:Line
You can also create trend chart with Line. But in the beginning, you will see a strange chart like below.
Step4: Set Hierarchy
You can set the date hierarchy by yearly, quarterly and monthly, and It’s useful.
If you can’t find the “Set Hierarchy”, please refer to Beginner’s SAP Analytics Cloud Journey: Day2- Datatype and data transform.
Now you can now create charts and analyze time series data in SAP Analytics Cloud👏👏👏!
As mentioned above, Time series data analysis allows you to find factors that affect a particular variable over a given period of time.
In my opinion, checking datatype and transform data are pre-required steps before creating charts and analyze data in SAP Analytics Cloud. If you’d like to learn more about charting and analyzing time series data? Please refer to my blog posting: Beginner’s SAP Analytics Cloud Journey: Day2
Following on Beginner’s SAP Analytics Cloud Journey: Day3 – How to insert Geo Map.