Advanced Analytics - Upcoming forecast demand dashboard
Updated
by
Daniel Sjögren
Upcoming forecast demand
This dashboard provides a forward-looking view of projected demand over the next defined period based on historical sales data. The dashboard visualizes total forecasted items with potential variances and highlights outliers, enabling quick action for more precise demand planning.
The Upcoming forecast demand dashboard is designed to give you a clear and actionable visualization of projected demand over the next time period based on historical sales data from previous periods. It offers an intuitive representation of the total number of items expected to be sold, allowing you to anticipate future trends and adjust your planning accordingly. In addition to providing an overview of expected demand, this dashboard also visualizes potential variances, making it easier to spot where actual outcomes may diverge from the forecast.
One of the key features of this dashboard is its ability to help identify outliers—data points that significantly deviate from established trends. These outliers may signal an anomaly or a need for further investigation, providing actionable insights that can be addressed quickly. By pinpointing these exceptions, you can take proactive steps to refine your forecast models, reducing errors and improving the overall accuracy of your demand projections. This makes the dashboard not just a tool for monitoring forecasts but also a critical asset for enhancing predictive precision and driving more informed decision-making across your organization.
Global controls and filters
Filter | Description | Options |
District Name | For either District or Unit name, you can select the group-based criteria by which you want to filter the results on the dashboard. By default, it shows all groups (that you have access to). Then, as an easy example, if you want to filter down to the district Stockholm the charts will automatically filter to show the results for the groups within that district. A more advanced example is that with the additional filter options, you could also exclude individual groups from the view. This means that if you have identified a potential outlier, you could purposely exclude that specific group from the results so that you can see the impact of that change and (hopefully) see an improvement in the overall results. |
|
Variable | With this filter, you can select which variables you want to filter the dashboard results by. By default, it shows all available variables, with which Quinyx aggregates the information presented in the dashboards. From here, you can select as many variables as you would like to, to better drill down into the insights for the variables you care about. |
|
Start of time range (inclusive) | Use this filter to select the start date for your dashboard to define the time range for your dashboard in conjunction with the Time range length field (as described below). | Note: you have to set this field first, in order to populate the dashboards |
End of time range (exclusive) | Use this filter to select the end date for your dashboard to define the time range for your dashboard in conjunction with the Time range length field (as described below). | Note: you have to set this field first, in order to populate the dashboards |
Time range length | With this filter, you can select how many days in the future you’d like to view the forecast data. |
 |
Forecasted demand (Totals)
Insight | Description |
Total Forecasted Demand | The Total forecasted demand shows the aggregate total for your exact forecast based on the selected groups, variables, and time period. The Forecast range shows any potential variance from that total. Showing the lowest scenario and highest scenario (each calculated as 90% variance from the baseline). |
Forecasted Confidence Range | The Daily forecasted demand with likely range is a visual representation of this same information, illustrating how this is predicted to change over time. The center line shows the Forecast Total, while the north and south line shows the confidence intervals. That being the 90% confidence variance from that central line (5% above and 5% below). |
Forecasted demand (by variable)
Insight | Description |
Forecasted demand by variable | The Forecasted demand by variable panel uses this same data, but then slices it by variable. Designed as a table graph it provides a simple visualization of the high performers and low performers, organized by variable. |
Daily forecasted demand by variable | This line graph visualizes this Daily forecasted demand by variable over time. That is - showing the performance of each variable over time, to allow for easy comparison of the selected variables. |
Forecasted demand (by District and Unit)
Insight | Description | Details & Calculations |
Forecasted demand by district | With the Forecasted demand by district and unit dashboards you get a simple view of all the groups within your organization to provide a comprehensive overview of how each district and unit is performing. | Everything here is clickable, so if you select any district or unit (in either the table or scatterplot graph the results will automatically be filtered to that group, allowing you to drill deeper to identify any discrepancies. |
Forecasted demand by unit | With the Forecasted demand by district and unit dashboards, you get a simple view of all the groups within your organization to provide a comprehensive overview of how each district and unit is performing. | Everything here is clickable, so if you select any district or unit (in either the table or scatterplot graph the results will automatically be filtered to that group, allowing you to drill deeper to identify any discrepancies. |
Forecasted demand and expected change by district | With the scatter plot graphs accompanying them, you can get a visual representation of this same insight. Designed to help you easily identify outliers, here you can quickly differentiate between top performers, bottom performers and any district or unit performing outside the norm so that you can take actionable insight where needed. | Everything here is clickable, so if you select any district or unit (in either the table or scatterplot graph the results will automatically be filtered to that group, allowing you to drill deeper to identify any discrepancies. |
Forecasted demand and expected change by unit | With the scatter plot graphs accompanying them, you can get a visual representation of this same insight. Designed to help you easily identify outliers, here you can quickly differentiate between top performers, bottom performers and any district or unit performing outside the norm so that you can take actionable insight where needed. | Everything here is clickable, so if you select any district or unit (in either the table or scatterplot graph the results will automatically be filtered to that group, allowing you to drill deeper to identify any discrepancies. |
