Calculate a mean Profit across Order Year and Order Priority using a pivot table. Insert the Select Columns widget and choose: Data analysis Report, JCU, Singapore

Task 1

Calculate a mean Profit across Order Year and Order Priority using a pivot table. Insert the Select Columns widget and choose the column for High as the target variable and Order Year as the only Feature. Use the As Timeseries widget and create a Vector Auto-Regressive model, set optimize Auto-Regressive model as ‘None’ and Add the trend vector as ‘Constant and Linear’.  Add a Line chart widget after the VAR model and notice the forecasted values. Connect from As Timeseries widget as Time series to the line chart widget and from the VAR model widget to Line Chart as Forecast.

Task 2

Identify relationships between profit & loss & shipping cost and derive business insights from the data, by describing outliers, clusters, and patterns you observe.

Task 3

Address one dilemma or challenge faced related to the business