8 … Solution Cross-sectional forecastingAssume similar behavior of some groups of time seriesUse transitions over months from a set of time seriesTrain model on transitions of several time seriesUse last known period as input to calculate forecasts1st year2nd year3rd yearLiebherr KT 1434Bosch KSl 20s53SEG MS210 A…ModelReport calculationon previous periodKomplexpraktikum Datenbank-Anwendungen

9 Attribute hierarchiesMany different ways to partition the dataDifferent forecast error on different forecast targetsResearch goalWhat is the best partition for which forecast target?channelXno_frostchannelno_frostoutletitemoutletitemESPTSSYESNOoutletitemoutletitemESP-YESNOTSSAll x itemFIRA / SIS

11 Phases of prediction approachPrediction phaseFetch all necessary data for model trainingTransitions of all time series covered by the attribute valueTrain the modelFetch data from the pre periodCalculate predictionsEvaluation phaseFetch data of predicted periodJoin with predicted dataCalculate forecast errorModelModelerrorKomplexpraktikum Datenbank-Anwendungen