Create a Python web application with a few clicks

Experience multi-dimensional data analytics with atoti in Binder

I’m extremely excited to share how we can easily spin up a simple web application in Python with a few clicks! Before I go into the details, check out the following GIF:

Get started

It is as simple as:

1. Uploading a CSV file

To better experience the benefit of multidimensional analytics, I would advise you to choose a dataset with a fair number of numeric and non-numeric columns, e.g. Data Science Job Salaries dataset from Kaggle. This is because of the default way atoti handles data:

non-numerical columns are translated into hierarchies
a SUM and a MEAN measure will be automatically created for non-numeric columns (non-key columns)

2. Select keys that will give unique data rows (optional)

Applying keys to the table is akin to applying indices in an RDBMS database. Doing so helps to optimize the querying.

However, it is important to note that non-unique keys will result in a smaller dataset getting loaded. Only the last occurrence of the duplicates will be loaded into the cube. So if you’re unsure, leave the key(s) selection to “None”. In this case, the whole dataset will be loaded (unless you have duplicated rows ٩(͡๏̯͡๏)۶).

3. Launch the web application

If you’re running the notebook on your local machine, the program will automatically open up a browser tab with the application URL-http://localhost:9090.

Program launches atoti web application automatically in a browser. Alternatively, click on the session link to launch it manually.

However, if you are running the notebook from a server on e.g. the cloud, the URL depends on the domain or IP address of your instance. This can be seen from the screen capture above, where the web application URL is not localhost.

4. Build your dashboard

Finally, you can now start building your dashboard interactively from the web application! Refer to the GIF at the beginning of the article if you’re not sure how to do so.

You can easily restart with a new dataset simply by uploading a new CSV!

Technologies behind the scenes: atoti & ipywidget

Use atoti to create a BI analytics platform

The program revolves around atoti, a free Python library that allows users to spin up an in-memory data cube, and perform complex aggregations and visualizations. It also comes with a web application that allows users to build and share dashboards.

This program demonstrates the simplest way to use atoti, i.e. creating a single table data cube. All it takes is the following steps to spin up a cube:

import atoti as tt

# instant atoti session with a fixed port
session = tt.Session(port=9090)

# read CSV and create an atoti table
tbl = session.read_csv("ds_salaries.csv", table_name="table", keys=keys)

# create data cube with the above table
cube = session.create_cube(tbl)

# optional - print schema of the data cube
cube.schema

# access web application via the returned URL
session.link()

Use ipywidget to trigger atoti cube creation

The main purpose of this program is for users to quickly create a BI analytics platform. In order to make things easier, I used ipywidget to wrap around atoti for an interactive experience.

For instance, I’ve used the following:

FileUpload: Users can interactively select CSV from the explorer.
SelectMultiple: Users can select the keys for the table to be created.
FloatProgress: To show the progress towards application launch

“Upload file upload” will trigger the instantiation of atoti.Session and the subsequent steps. Refer to the notebook to see how it’s integrated together with atoti.

Now, users can create a BI analytics platform without any coding!

Experience atoti with Binder

I have always wanted to try Binder and here’s my chance!

The Binder Project is an open community that creates BinderHub, where we can create shareable, interactive and reproducible environments. So, now you can open the notebooks from atoti notebook gallery in an executable environment!

For atoti to work in Binder, we have added some files in our GitHub repository:

apt.txt: List the dependencies required for Graphviz

graphviz
libgraphviz-dev
pkg-config

requirements.txt: List dependencies required for atoti and Graphviz, specifically `atoti-jupyterlab` is necessary for Binder to include the JupyterLab extension for atoti in the build.

atoti[jupyterlab,aws,kafka,azure,gcp]>=0.6.6
jupyter-server-proxy
pygraphviz

runtime.txt: Define the version of Python to use. atoti requires minimally version Python 3.8.

python-3.8

Refer to the binder user guide for more information if you wish to use Binder for your own repository.

Build and launch atoti repository

Now we can spin up a JupyterLab instance with Binder simply by providing the URL of the GitHub repository: https://github.com/atoti/notebooks.

Build and launch the atoti notebook gallery in Binder to start playing with the atoti use cases.

Click the launch button and Binder will start building the environment. Subsequently, a JupyterLab instance launch automatically in the browser. You could also copy the URL and share the Binder with others.

Try atoti automatic cube creation in Binder

In the JupyterLab, navigate to notebooks > auto-cube and launch the main.ipynb to start playing around atoti with your own data!

Upload your own CSV to create your own atoti web application in the binder instance.

To access the web application, simply click on the displayed URL as shown below:

Run session.link() to obtain atoti web application URL

Have fun! But remember, each Binder instance is allocated 1 to 2 GB of RAM. So, do choose a smaller dataset if you want to give it a try. Otherwise, install atoti on your local machine for greater control and flexibility!

Latest posts

Understanding Logs in Atoti

From the default log to how to configure additional logging Application logs are extremely important in any system! Most commonly, they are used to troubleshoot any issue that users may encounter while using an application. For instance, developers use them for debugging and the production support crew uses them to investigate outages. Not just that, in production, they are used to monitor an application’s performance and health. For instance, monitoring tools can pick up certain keywords to identify events such as “server down” or “system out of memory”. It can also serve as an audit trail to track user activity...

Atoti: Working with dates in Python

What is the most problematic data type you have ever dealt with when working with data? I would say dates! Depending on the locale, dates come in different formats such as YYYY-mm-dd, d/m/YYYY, d-mmm-yy etc. Not to mention, sometimes it comes with timestamps and time zones! We can let programs infer the date format or explicitly cast the data to date with a specific format e.g. in Python with Pandas DataFrame: What if we open the CSV file in Microsoft Excel, update it, and try to read it again? The above code snippet will throw out exceptions such as this:...

Understanding conditional statements in Atoti

When do we use filter, where and switch statements? We know that we can perform aggregations and multi-dimensional analysis with Atoti. Aggregation is not always as simple as 1 + 2. Sometimes we end up in an “if…else” situation, and that is where conditional statements come in. Let’s explore some examples with the XVA use case from the Atoti CE Notebook Gallery. Some definitions before moving on: Measures – we refer to metrics or quantifiable data that measure certain aspects of our goals. In the code snippets below, they are represented by measure[<name of metrics>]. Members of a level –...