Last articles - Atoti Community

Explore further with Atoti

What is DirectQuery?

Combine Atoti and Data Warehouses to enjoy the deep-diving capability of Atoti on top of your existing...

Querying with Atoti

In Atoti, we integrate data from different sources into an in-memory data cube. Without worrying about the...

Measuring Interest Rate Risk in the Banking Book (IRRBB) with Atoti

Manage and analyze large amounts of transactions and historical data Interest Rate Risk in the Banking Book...

Bucket Analysis with Atoti

Discovering trends in your data via bucket analysis is easier than ever Performing bucket analysis? What makes...

Security Changes in Atoti V0.8

Aligning and simplifying coding In case you haven’t noticed, we have one less plugin with Atoti Python...

Understanding conditional statements in Atoti

When do we use filter, where and switch statements? We know that we can perform aggregations and...

What’s New in Atoti Python 0.7.3?

Python 3.11 Compatibility, an Updated Way to Define Joins, Telemetry Changes Ahead. Hey Atoti Community! We’re super...

Monitoring Intraday Liquidity with Atoti CE

A clear understanding of your daily liquidity, so you know your daily reserves requirements With BCBS 248,...

Constraints straining your portfolio optimization?

See how we expanded our Atoti and external optimizer integration use case to include constraints. Perhaps your...

Contributing to Atoti notebook gallery

Share your Atoti use case with our community If you haven’t heard of Atoti, it is time...

Integrating an External Portfolio Optimizer with Atoti

Given a portfolio and an optimizer, can we find a ‘better’ portfolio using Atoti? It’s a classic...

Access control with Atoti+

Restrict viewing rights up to data level In this article, we explore the topic of access control...

What’s new in Atoti version 0.7.0?

As always, we’re working hard to deliver a great product. Check out our breaking updates in this...

Malek Zaidi: Making actual impact as an intern

Using Atoti instead of Excel for business analytics Most companies hiring interns assign them modest levels of...

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

Atoti: Your license has expired

Simply upgrade your Atoti library to continue using This article will address how to continue using Atoti...

IoT device traffic to demonstrate office personnel traffic

IoT, or internet of things, refers to the world of devices or objects which connect to other...

Everything you need to know about RDBMS vs. OLAP

This article will explore the two big players in the data processing game- OLAP and RDBMS. Different...

Exploring OLAP with Atoti and Pokemon

Analyzing Pokemon Fight Data — Which is the strongest Pokemon of them all? The Beginning My goal...

Do you know what changed in the latest version of Atoti?

We recently released Atoti 0.6.5. The latest version of Atoti comes with a whole lot of features...

Atoti v0.6.5: Make way for more intuitive programming

Comes with concise functional calls to improve your coding experience I remember when I first learned to...

Data Democratization

As a range of tools aimed at supporting data accessibility spring up, we explore data democratization within...

Data analytics: Importance of time from project inception to output

Piyumal: on the road to streamlining legacy operations with Atoti The Atoti community is full of individuals...

Collateral Modelling and Simulation Using Atoti and Machine Learning

See How we Use Atoti to simulate and Visualize ML-Based Collateral Shortfall Predictions. This article is derived...

Unravel price elasticity of demand with Atoti

In this article, we will use the price elasticity of the demand-based model built with Atoti to...

Dynamic Performance Analytics: Handling of non-linear aggregation

I am a quantitative analyst for ActiveViam. In this blog, I will provide an example of how...

Sales commission - Breaking down the variable cost

Benefits of using a multi-dimensional cube to track your sales payouts When we look at sales, it...

Credit card fraud detection with synthetic data and AutoML

Part 2: Fraud detection with Faker and PyCaret This article is the second part of my credit...

Credit card fraud detection with synthetic data and AutoML

Part 1: Investigating fraudulent transactions in real-time with Atoti Credit card fraud figures were boosted by the...

Understanding Climate Risk with Anne Gruz

Based on her expertise in financial risks and her commitment to climate action, Anne demonstrates how to...

Boost Your Digital Marketing Strategy with a Dashboard

Digital marketing is ubiquitous. Learn how you can get real and tangible results from your digital marketing...

Real-Time Masked Face Detection using Detectron2

Fine-Tuning a Detectron2 Model to Detect Faces Wearing a Covid Mask in Videos. In this post, I...

Customer 360: How it can be achieved with Atoti

Tearing down data silos to provide a unified view of the customer Customer 360 is aimed at...

Complementing RDBMS with multidimensional analysis

Create an OLAP cube from your relational database with minimal ETL effort You probably know what RDBMS...

Gopu Pillai: Shortest time to conclude PoC for Enterprise software

Discovering Atoti as a self-service BI tool Gopu Pillai is a Business Analytics and Insight Lead for...

California wildfires and solar irradiance

California wildfires are increasingly intense. Understanding how these wildfires impact everything from air quality to solar irradiance...

Using Deep Learning for Covid-19 Infection Risk Assessment

See How We use an AI-based Solution to Detect Masked Faces in Videos, Calculate the Risk of...

Secure dashboards with access control on the data: Atoti to Atoti+

Going beyond multidimensional analysis with Python While many data scientists or analysts are excited about doing their...

OLAP’s promising path forward

Much has been said about the longevity of OLAP. Here’s how ActiveViam proved it is here to...

Interactive xVA analytics with Python and Atoti

Hello, I’m a quantitative analyst at ActiveViam and in this blog, I’d like to illustrate how to...

Why do we need multidimensional analysis?

Multidimensional analysis gives the ability to view data from different viewpoints. This is especially critical for business....

Meghana and Gauri: Explaining OLAP concepts with practical examples

Why Atoti is a good fit for their needs I came across the presentation from Meghana Kshirsagar and...

“I was able to do everything in the same Jupyter notebook just using Atoti” - Tasneem Ahmed

Faced with creating an NLP text to query exploration of storm data from a spider dataset requiring...

How to leverage BI tools to communicate effectively with tech and business users alike

As business or data analysts, there are times when we are presented with a set of data...

Introductory guide to Atoti BI web application

How often were you tasked to turn over a functional, self-service dashboard to the business management team?...

Viewing AI from an artistic perspective with Li Xiao'an

Art is a better way to experience something mathematical AI in the music industry is nothing new....

Li Xiao'an: Strategizing AI solutions in the music industry

The need for non-technical subject matter experts in data science Known as Xiao’an — Composer, Life Science Husband on LinkedIn,...

Upgrade Notebooks to Atoti v0.6.0

The latest version of Atoti is big, with many breaking changes. This upgrade guide will help you...

Raising up the next generation of Data Scientists with Ayodele Odubela

Ayodele is very up front about how she made her journey, and is committed to helping others...

What’s new in Atoti v0.6.0: Improved Simulations

Measure simulations and scenarios have been streamlined, allowing for greater flexibility As part of v0.6.0, we are...

What's New in Atoti v0.6.0: Performance Upgrades

Expect many changes as part of the latest upgrade in Atoti, including enhanced performance and improved visuals As...

Dismantling bias in ML/AI with Ayodele Odubela

Machines are learning our biases and she is on a mission to fix it. Plus, how Hollywood...

Synthetic data generation: test your proof of concept, without the data!

In this article, learn one of the sought out skills for data scientists -how to generate random...

Getting a voice heard: Ravit Jain

Influencing data science without data science By trade, he’s not a data scientist, nor is he a machine...

Building a Sales Cube in Atoti

We build a sales cube on top of automobile Data from the U.S. In this article, learn...

Pratham Prasoon: Adapting to a new way of learning

Sharing the readily available online resources that allow for self-learning Like everyone else, Google is my best...

Pratham Prasoon: Age is only a number when it comes to Data Science

Sharing his journey to point others in the right direction A lot of us from the ‘older...

"Open Source is a win-win for everyone" - Philip Vollet

‘One of the benefits of growing an open-source product is the community around it. They contribute to...

The How-tos of Atoti Dashboards

To the Big Tech out there: Africa needs knowledge development, not just 'another job'

Exploring ways to improve Africa’s digital landscape with Mabu Manaileng As the old Chinese saying goes: Give...

Mabu Manaileng: Setting trends with AI and ML in Africa with Datawizzards

Envisioning a level playing field for all Many African’s leave the country to obtain a more ‘global’ platform...

Serious business between the spreadsheets: Susan Walsh

How to build and grow a business around data When times get tough: Susan Walsh shares her...

Fixing ‘dirty data’ with Susan Walsh, the Classification Guru

Data classification gives visibility that uncovers fraud, rook spending or mismatched data 2021 is a year of...

Christina Stathopoulos: How an introvert became a great public speaker

Challenge your own weaknesses If you haven’t seen Christina Stathopoulos speak, here’s one of my favourites: Given...

Everything from the #bookaweekchallenge to the #IamRemarkable initiative: Christina Stathopoulos speaks out

Always supporting initiatives to build a more inclusive community The definition of a bibliophile is a person...

Topic Modeling On Twitter Using Sentence BERT

Follow along as we extract topics from Twitter data using a revisited version of BERTopic, a library...

Is ClickHouse really that fast? a friendly comparison with Atoti

A Value-at-Risk benchmark where Atoti appears consistently five times faster than ClickHouse for this use case. As...

A New Paradigm: Identifying and Managing Climate Risk in Loan Portfolios

Central banks have begun requiring the banks they regulate to perform stress tests that account for and...

Interview with Danny Ma Part 2: building a data science community from scratch

Mentoring the next generation of data science mentors I always thought Danny had been an influencer for...

Interview with Danny Ma Part 1: how to get into data science

Follow Danny on his self-taught data science journey If you want to get into data science but...

How to reduce machine learning bias

Machine learning and artificial intelligence are becoming more and more ubiquitous and an integral part of our...

A starter kit to dockerize a Business Intelligence Project

Customize Atoti Dockerfile for quick deployment Docker is one of the leading open-source DevOps containerization tools. It enables...

Storing your own Docker image on the cloud with Amazon ECR

Managing container images for cloud deployment Docker image is like a process template that we run to...

The Ultimate deployment guide for Atoti on AWS with Amazon EC2

How to run and share your Atoti BI app UPDATE: The GIFs and code snippets in this...

How to Deploy Docker image for BI Dashboards in AWS

Deploy containerized Business Intelligence web application using Amazon ECS UPDATE: This article is based on an older...

Why Machine Learning models might fail in production

This article shall be covering methodologies to do a quality check on the predictions from a machine...

IFRS 9 Data Viz: ECL, PD Analytics and the Vintage Matrix

IFRS 9 portfolio analytics with Python and Atoti In this post I would like to present examples...

Tutorial: How to build an IFRS 9 solution with Python and Atoti

IFRS 9 portfolio analytics with Atoti This blog provides a guide on how to address daily credit...

The creative value of automation with James Briggs

Automation doesn’t take people’s jobs. It helps people focus on the more creative bits of their jobs,...

Top Twitter Topics by Data Scientists #1: Free Resources, AI Threats & Capitol Riots

Every week we analyze the most discussed topics on Twitter by Data Science influencers. The following topics,...

When to perform a Feature Scaling?

In this article, we shall discuss one of the ubiquitous steps in the machine learning pipeline —...

“Ladies, speak up for yourself!” Parul Pandey on women in data science

I want to encourage women to compete in a field that is predominantly dominated by menI want...

Time-series forecasting with a deep learning model

Perform probabilistic time series forecast from a deep learning model and perform what-if analysis on the forecast....

How to solve the zero-frequency problem in Naive Bayes?

Question: I’m trying to implement a Naive Bayes model following the Bayes’ theorem. The problem I face...

Why put your ML results into a dashboard

Naïve question from a novice While trying to perform a time-series analysis, there are many things to...

A novel approach to inventory management

In this article, we will explore a method to tackle the issue of optimizing inventory management thanks...

Using Twitter to forecast cryptocurrency returns #3 - A time series analysis using VAR

Find out which features can forecast the returns with Granger Causality Test If you have followed my...

Using Twitter to forecast cryptocurrency returns #2 - Mining Cryptocurrency with CoinGecko API

Gearing up for returns forecasting with VAR Caption: Screen grab from CoinGecko After going through Tweets mining...

Using Twitter to forecast cryptocurrency returns #1 - How to scrape Twitter for sentiment analysis

80/20 data science dilemma: tough working on Twitter sentiment When my manager brought up the idea of...

23 times faster than Qlik: Simulating a Market Price Index in the Tyre Industry

Being able to elaborate a dynamic Market Price Index, to monitor over time your price levels compared...

What is data leakage? And how to mitigate it?

‘Data leakage’ is a ubiquitous term associated with predictive modeling and is a prevalent occurrence in most...

Faster Algorithm for FRTB SBM Risk Aggregation

Building regulatory risk application with Python and Atoti In this post, I want to discuss a faster...

How to explain non-additive measures, Part 3: order-statistics decomposition

Interactive decomposition with Atoti This article is a part of a series. Check also: Part 1: Pro-rata...

Top count in Jupyter notebook: Atoti vs Pandas + Matplotlib

How frequently do you perform a top count while doing some data analysis? In this article, we...

How Atoti saved us a lot of time and made it possible to implement Stress VaR Calibration

Interview with Dalcon Hai – Senior Business Analyst Atoti team: Could you tell us a bit more...

How to explain non-additive measures, Part 1: Pro-rata allocation

Interactive decomposition with Atoti This article is the first part of a series of tutorials about interactive...

How to explain non-additive measures, Part 2: Incremental contribution

Interactive decomposition with Atoti This article is the second part of a series of tutorials about interactive...

SA-CCR with python and Atoti

Counterparty credit risk analytics and what-if In this post, I will show how you can implement an...

Reddit data analytics trilogy #1 — Data scraping with PRAW

I was inspired by an article about creating a Data Table using Data from Reddit and I...

Reddit data analytics trilogy #2 — NLP with spaCy

This is the second article of my Reddit trilogy and in case you haven’t read the first...