Monday, July 17, 2017

Add Predictive Analytics on Your Dataset in 3 Steps

Knowi Predictive Analytics brings machine learning capabilities to every Data Engineer.

Add Predictive Analytics on Your Datasets
Integrate machine learning into your analytics workflows and drive data directed actions.

The platform provides two options:
  • Out-of-the-box predictive analytics capabilities that test a dataset against a variety of forecasting models to determine the model best suited to the data,  with the least Sum of Absolute Errors (SAE).  
  • Built-in Predictive and Machine Learning algorithms that can be plugged into data workflows.
This post focuses on the first option above that takes a hands-on look at how it works.  We'll take monthly stock prices for Amazon to determine predicted values over a three month period starting in July in a few simple steps. No signup is required to follow along.  

Models used include:
  • Simple Exponential, Double Exponential, Triple Exponential Smoothing Models
  • Moving Averages and Weighted Moving Averages
  • Naive Forecasting Model
  • Regression and Polynomial Regression Model
  • Multiple Linear Regression Model

The monthly stock prices looks like this:

Date, Price
06/01/16, 719.14
05/01/16, 683.85
04/01/16, 598.00
03/01/16, 579.00
02/01/16, 574.81
01/05/16, 633.79
12/01/15, 679.36
11/2/15, 628.35
10/1/15, 625.90
9/1/15, 511.89
8/3/15, 512.89
7/1/15, 536.15
6/1/15, 434.09
5/1/15, 429.23
4/1/15, 421.78
3/2/15, 372.10
2/2/15, 380.16
1/2/15, 354.53

Steps:

1. Copy and paste the above dataset into https://www.knowi.com/csv-json-files-analytics.



2. Click on Show me. The data will be parsed and visualized immediately. 

3. To perform predictions:
   i. Click on Analyze from the menu of the time series chart. This opens up an Analysis mode.
  ii. Drag date into the Grouping field. 
  iii. Click on 'Add a derived Field' option. Enter a name ("Predictions", for example) and in the operation, enter predict(price,date,07/01/2016,1m,3). This will choose the best model based on historical accuracy of the model to determine the projected prices over a three month period, on a monthly basis. 




That's it! In a few simple steps, you can apply predictive analytics on any of your own datasets. Enjoy!

Get started with Knowi Predictive Analytics at https://knowi.com.  Try it out free.

Additional Machine Learning Resources:
Predictive Analysis docs: https://docs.knowi.com/hc/en-us/articles/115006493407-Predictive-Analytics-Forecasting
Advanced Machine Learning (AI) Capabilities: https://knowi.com/adaptive-intelligence-machine-learning
All Documentation: https://docs.knowi.com





0 comments:

Post a Comment

Please share your thoughts. If you have a question, please reference our docs section at https://docs.knowi.com.