Setup

You will be needing AI-Lab and an Exasol database. You can choose the Docker DB that comes with AI-Lab or use Exasol SaaS and start with the free trial.

Once you have finished setting up with AI-Lab, we can proceed.

Beginner to AI-Lab

If this is your first time using AI-Lab, follow these steps:

  • Start with the main_config file.

  • Go through all of the cells in the main_config file.

  • You have multiple database options: Docker (recommended), SaaS, and On-Prem.

  • The last cell creates a schema for you and ensures that you are connected to a database.

  • We can now proceed with our demo.

Download the Sales Forecasting Demo File

  • Download the .zip file.

  • Extract the contents of the .zip file using your file explorer.

  • Create a folder inside the root folder of AI-Lab and name it “sales_forecasting”.

  • Upload the files inside extracted folder into the “sales_forecasting” folder. Using the import button on the top right.

  • Alternatively you can just upload the .zip file to JupyterLabs and unzip it using Unzip Files in JupyterLab.

  • Congratulations! You’re all set, and now we shall meet in AI-Lab.

  • The notebooks are numbered so you can know which one to visit first.

Unzip Files in JupyterLab

import zipfile as zf
files = zf.ZipFile("sales_forecasting.zip", 'r')
files.extractall('sales_forecasting')
files.close()