Setting up your Infer account
The first thing to do is to setup an account with Infer.
Assuming you have an Infer account either ask the account admin of your organisation, or your Infer account executive, for a login. If your organisation does not have an Infer subscription contact Sales at https://www.getinfer.io to find out more about how to subscribe to Infer.
Once you have a login simply head to https://app.getinfer.io and enter your login details.
The first time you login we will ask you a few questions about your motivations and needs for using the app. Please fill these out 🙏 this really helps us make the app the best it can be for you.
Now you are logged in and ready to infer!
The first time you login you will see a set of demo projects - each of these illustrating different use cases and types of analysis.
Churn Analysis: This example illustrates how to do churn analysis on a customer data set using the
EXPLAIN commands to both predict churn and understand what drives churn.
It also shows how to aggregate and group outputs to estimate expected loss in the near term,
based on the prediction of churn.
Customer Lifetime Value: Illustrates how to define a Customer Lifetime Value using an ecommerce data set and how
to use it to predict and understand what drives the lifetime value of customers.
It also shows how to use
SHAP to build a more detailed picture of what drives the LTV for geographical segmentations.
Customer Feedback: Uses the text analysis components of SQL-inf, in particular the
SENTIMENT command, to show
how you can use SQL-inf to understand customer reviews. It also shows how to combine
PREDICT to understand what customer behaviors drive certain sentiments
Uploading your first data set
To get started with your own analysis the first thing you need to do is connect or upload your data. Currently the only method supported is to upload data as CSV files.
If you don't have a dataset at hand try this one. It is a nice dataset of red wine quality scores coming from this this paper.
We will soon offer the ability to connect your Infer account directly to your data warehouse, but for now you need to prepare your data externally via another tool and upload it as a single table, in the form of a csv.
Running your analysis
Now it is time to run your first piece of analysis.
First, select your data set in the left dataset menu. Then go to the codebox in the middle and run an SQL-inf query.
If you used the above red wine data set then simply copy-pasting the following command into the codebox and click the "Run" button.
SELECT * FROM winequality_red PREDICT(quality, model='reg')
Another way would be to use the template "Predict" from the template code-box dropdown.
You can then select
quality as the prediction field, set the
model='reg' option and click "Run".
Volia! You have run your first SQL-inf command!
You can learn a lot more about this example and how to explain and better understand the prediction by going through the Prediction tutorial.
You can view the selected dataset before running the analysis by clicking the "Input Data" tab in the result section below the codebox.
Analysing your data
Once you have run your analysis you can view and explore the results.
Note that each SQL-inf command run is saved and can be accessed in the query bar next to the code-box. Here you can also pin, rename and delete previously analysis.
Below the codebox, you will see the results panel. The results panel displays a visualisation dependent on the type of analysis run - in the case of a prediction it will show the prediction plotted against an input column. You can plot different columns against the prediction by clicking on the column headers in the results table or by using the arrows in the top-right corner of the result panel.
Below the visualisation you will see the output of the analysis in table form. This is the raw output of the SQL-inf command.
Exporting your data
Once you have iterated on your analysis and found something interesting you probably want to export it to another platform for further exploration or dashboarding
To do this simply click on the "Export Results" button above the results table. The result set will then be downloaded as a csv-file.
You can also click on the "Download Graph" button above the graph to download the visualisation as an image file.