ADVANCED ANALYTICS AND OPTIMIZATION

Scanning through data row by row to check that everything is OK can be reliable when you have a couple of rows to check. But when you have real company data, you inevitably have large datasets with missing values, different units of measurement, and different orders of magnitude. Plotting the data helps a little but to quickly process large amounts of data with reliability, you should use advanced algorithms.

Outlier detection algorithms automatically detect suspicious values for you. They learn patterns from historical data and alert the user when some values do not fit into these patterns. They can tell you whether the value 142 for last year’s December is within the normal limits or not. They can also tell you if a value 0 in February seems like someone forgot to input the value or if it is a legitimate value.

To check your data for suspicious values you can use a visualization of outlier detection algorithm results. For example, you could have different costs organized by the significance of the suspicious values. This allows you to go through the potential errors in data starting from those with the most dramatic effect. Instead of going through all values manually, you can concentrate only on those graphs that the algorithm has flagged as requiring inspection.

Creating forecasts manually is often either laborious or based on very rough estimates. Sometimes these are no better than a copy-paste from the previous values. At other times, a professional adjusts the values here and there to consider some foreseeable changes. However, forecasting can be made both more accurate and automatic.

With predictive analytics algorithms, several forecasts can be created in seconds by pressing a button. These algorithms dig into historical data, uncovering trends and seasonal behavior. The algorithms learn the behavior hidden in the data and create intelligent forecasts.

The user can provide the algorithm with additional information to further enhance the forecast. For example, when forecasting the electricity consumption of a factory, the user can provide information on planned production volumes. The algorithm will then consider historical data and its correlation with historical production volumes. Based on this, it will forecast the electricity consumption taking into account the planned production volumes.

The professional no longer needs to create forecasts by hand. Instead, they inspect the results given by the algorithms and provide additional input when available. This allows them to use their time on more productive work, such as creating scenarios and considering the implications of the forecasts.