Visualizing the sales forecasts

Now that predictions have been generated, create a simple analytics app to view and analyze the sales forecasts.

Do the following:

1. Go to the Create page of the Analytics activity center and select Analytics app.

2. Enter a name for your app, for example, Sales forecasting.

3. Choose a space for your app.

4. Click Create.

5. Under Get started adding data to your app, click Data catalog.

6. Find and select the ML - Sales predictions_Prediction.parquet prediction dataset you just generated.

7. Click Next.

8. Under Select fields, click Select all. Click Next, and then Load into app.

9. In sheet view, add a Straight table to the sheet.

10. Add the following dimensions to the straight table:

    • date

    • store_nbr

    • family

11. Add the following measure to the straight table: Sum (sales)

12. Expand the properties for the measure. Under Number formatting, select Money.

The table should contain forecasts starting three days after the end of the historical data, which was August 15, 2017. There should be seven unique dates in the table, with the Sum (sales) column containing the forecasts.

Thank you!

You have reached the end of this tutorial. We hope that you have learned a few things about time series forecasting in Qlik Predict.