InetSoft Product Information: Trend Analysis

Trending and forecasting analysis displays trends over time for measures such as product sales, market share or average selling price. Trends are typically observed by plotting historical data over time on a chart display. This can be easily accomplished using InetSoft’s Style Intelligence.

Sales Trend (Historical data)

A prevalent use of trend analysis is to determine if the current value of a measure is an exception to the expected trend. To do this manually requires the observer to review the data on a regular basis that is inefficient and time-consuming. InetSoft Scorecard with alert notification eliminates the need for this manual process by automating the data review efforts and will send an alert notification to the relevant people when an exception is detected.

Sales Trend Analysis
gallery icon
View the gallery of examples of dashboards and visualizations.

sales forecasting

Forecasting (seasonal effect accounted)

seasonally adjusted sales

A natural extension of trend analysis is to extrapolate the trend into the future for forecasting analysis. As the extrapolation may depend on parameters unique to each individual industry, it has been observed that a general forecasting engine is usually not suitable and could extrapolate incorrect trends when these parameters are not taken into account.

Forecasting (using Least Squares method)

To overcome this limitation, InetSoft provides the forecasting analysis through our flexible Data Block technology where the unique parameters required can be individually built into the extrapolation formula. As shown below, the forecast_seasonal line is more accurate and accounts for the bi-yearly Winter Olympics sales effect when compared to the forecast based on the Least Squares (LS) regression forecast model.

demo icon
View a 6-minute Flash demo of InetSoft's easy, agile, and robust BI software.

Forecasting with InetSoft Data Block:

The linear Least Squares (LS) regression is based on y = a + bx. To determine the constants a and b, we can make use of the following formulas:

least squares regression

To use the least squares regression formula, create the SalesData data block for the sales data collected. To obtain the desired values, group by the Sales Date, aggregate the total sales revenue (y) and obtain the sales quarter(x).

sales forecast formula

To determine the values of a and b, build the LS data block on top of the SalesData data block to calculate the required values (i.e. xy, x2, y2) per the stated formulas.

least squares formula

Read more about InetSoft's data mashup technology to learn how it makes BI asset delivery and maintenance more efficient than traditional BI solutions.

The Forecast data block below uses the LS data block to calculate the sales forecast based on the LS regression method y = a + bx. The values are tabulated in the Calculated_forecast table (i.e. y1).

sales forecast modeling

Based on current market research, the sales revenue for this industry has peaks and valleys based on the Winter Olympics bi-yearly schedule. To accommodate for this sales pattern, we incorporated an offset formula into the LS forecast values to provide the values in the y1_season column.

The Forecast table gathers the actual sales data, the LS forecast and the modified LS forecast to be used as the dataset for the chart. As demonstrated, you can easily add more parameters or complex calculations to your data block in order to obtain a more accurate forecast for your particular needs.

With this approach to the forecasting analysis, InetSoft provides a necessary tool for forecasting analysis so that the extrapolated trend is suitable and accurate for each unique case. Typical extrapolation formulas can be built using the Data Block technology for general forecasting analysis and then expanded or modified to account for unique parameters in the monitored measure to provide a more accurate forecast.