Buy or not / Predict from tabular data
Predict if a customer will buy or not based on earlier customers buying patterns
Money!! Understanding what makes a user willing to cash up and buy a product has always been key to businesses.
This tutorial will show you how you can build simple AI models using the spreadsheets that so many of us work with. You will use tabular data to solve a classification problem, and get advice on how you’d also solve a regression problem.
- Target audience: Beginners
- Tutorial type: Get started tutorial
- Estimated time: Setup - 5 minutes | Training - 10 minutes
- Problem type: Tabular classification
You will learn to
- Import and use tabular data onto the Peltarion Platform.
- Solve a binary classification problem - Will a customer buy, yes or no?
The problem - Unleash the power of the spreadsheet
Most of the data that businesses collect are tabular, that is, data that can be stored in a spreadsheet: numerical, categorical, binary, or any combination of those. You name it.
How do you use this data to make really good predictions? Well, there are many ways to make predictions using tabular data, and the Peltarion Platform is a great way to quickly and intuitively leverage your data to make valuable predictions.
Getting started - create a project
Let’s begin! First, navigate to the Projects view.
First, click New project in the Projects view and name it, so you know what kind of project it is.
Import dataset from Data library
In the Datasets view, click on Import free datasets and choose the Bank marketing dataset. This dataset is used to solve a binary classification problem for a propensity to buy use case.
After you have reviewed the information about the dataset, click on Accept and import to accept the terms of the dataset’s license and import it into your project.
To teach a model to predict results, you need examples of input features coupled with the target historical result.
We will use the feature purchased as the target feature, that is, the outcome that the AI model will learn to predict from the input features. purchased contains info about whether or not the client historically subscribed to a term deposit after the phone call.
The Encoding is Binary. That means it has only two possible values:
1 for buying, set to Positive class.
0 for not buying.
Click Use in new experiment, and the Experiment wizard will pop up.
Build your model in the Experiment wizard
The Experiment wizard makes it really easy for you to set up an experiment. Let’s take a look and make sure that all presets are correct:
The Bank marketing dataset is selected.
Inputs / target tab
In the Inputs column, select everything except the purchased feature.
In the Target column, select purchased as the target feature.
The target is what the model will learn to predict.
Problem type tab
Given the inputs and target selected, the wizard recommends automatically selecting Tabular classification as Problem type.
The wizard has created a model that fits your tabular data. Every input feature has its own Input block.
All settings are pre-populated, and it’s time to train the model. Click Run.
In the Evaluation view, you will find several ways of analyzing how your model is performing. The specific metrics shown in the Evaluation view depend on your problem type and loss function.
Loss and metrics curves
minimize loss and error metrics
To identify which metrics are most important for your specific application, read more about loss and metrics.
Congratulations, you have completed this tabular data tutorial! In this tutorial, you have imported and used tabular data on the Peltarion Platform.
You’ve used this data to solve a binary classification problem, that is, a problem with only two categories. You’ve also quickly analyzed the performance of your model.
Learn how to improve a model that uses tabular data
The Improving your tabular data model tutorial gives you guidance on what types of settings and parameters to change when you try to improve your model.
Get started with tabular regression - price prediction
The tutorial Sales forecasting with spreadsheet integration shows you how to build a model that predicts daily sales revenue from many parameters. The platform lets you deploy this model for production, allowing you to directly integrate predictions in your Google Sheets or integrate predictions in your Microsoft Excel spreadsheets.