BI analytics. Boosted.

atoti is a free Python BI analytics platform for Quants, Data Analysts, Data Scientists & Business Users to collaborate better, analyze faster and translate their data into business KPIs

Powered by ActiveViam

atoti highlights


Analyze millions of rows on your laptop and up to several terabytes in the cloud

Create what-if scenarios and compare them side by side

Enable multi-dimensional analysis with OLAP cubes


Visualize data in interactive widgets without coding from Jupyter notebook

Share results with peers and partners

Explore data from atoti’s dashboarding web application or Excel

What users say:

Atoti quotes
Atoti quotes
Great python lib for exploratory data analysis, kinda your own small #Tableau right within #Jupyter notebook. Very serious backend behind, efficient RAM management (in-memory cube).

Julien Laugel | Chief Data Scientist


Join the Community

Register to receive the atoti newsletter.
We will not share your contact with any third party.


Use cases

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 –...


Logs: the unsung heroes of your #Atoti python library. 🦸

We've got a new guide that'll help you get to know them better, from the default log location to configuring additional logging!

Check it out here👉

#pythonprogramming #dataanalytics

Wondering the best way to optimize your portfolio?

Follow these steps and connect a portfolio optimizer with #Atoti to perform a benchmarking comparison on your equities portfolio. 🐍 📈


#python #datamodeling #portfoliomanagement

Why did pi fail its driving test?
It didn’t know when to stop 🤭

For #PiDay, we estimated its value using a Monte Carlo method. Watch its accuracy improve in real time and appreciate the beauty of math. 😁


#Atoti #MonteCarloSimulation #python


atoti works with

atoti leverages several technologies such as PythonJavaJavascript and uses Conda for distribution. It works with all major notebooks, with enhanced features for Jupyter and SageMaker. Run it on your laptop, server or in any cloud environment.