Category Archives: Data Mining

Data Mining – Mining Model Prediction

Posted on September 27, 2019 by jhuythieu

Time Series Query SELECT ([DC Cust Product Model].[DC Cust Product Model]) as [ModelDCCustProduct], (PredictTimeSeries([DC Cust Product Model].[Revenue],3,18,EXTEND_MODEL_CASES)) as [PredictedRevenue], PredictTimeSeries([DC Cust Product Model].[Quantity],3,18,EXTEND_MODEL_CASES) as [PredictedQuantity], (SELECT $Time, PredictVariance([Revenue]) AS [VARIANCE_REV], PredictStdev([Revenue]) AS [STDEV_REV] FROM PredictTimeSeries([DC Cust Product Model].[Revenue],3,18,EXTEND_MODEL_CASES) AS t … Continue reading →

Posted in Data Mining, Machine Learning | Leave a comment