A simple example of converting your analytics into any referenced currency Today we are going to look at an exciting new function in atoti v0.7.1 called lookup! What’s a lookup? We look up words we don’t know in a dictionary, and we look up news on the internet, etc. So,...
Different authentication mechanisms to secure your atoti session
Leverage your existing authentication provider with Atoti+ This article is part of a series that explains how we can implement secured and managed access in atoti through the Atoti+ plugin. In this article, we introduce various supported authentication mechanisms in atoti such as: Basic authentication Lightweight Directory Access Protocol (LDAP)...
Guide to Auth0 setup for Security implementation with Atoti+
Add user roles to the ID token with custom action I have always presented different use cases for the atoti Community Edition. After experiencing and being satisfied with the Python BI analytics platform, some users ask for authentication and access management. This can easily be accomplished with the use of...
Weighted averages with atoti
Sometimes, the 'standard' average doesn't take into account the scale or importance between the things being averaged. Enter weighted averages. Consider the following situations: a vendor sets the price for their wares as 10.00USD per unit for 9 or fewer units, 9.50USD per unit for 10-99 units, and 8 USD...
Currency conversion with atoti
Currency conversion is important. In an ever increasingly globalized world, businesses are more likely to record transactions in multiple currencies: a freelancer may charge according to the local currency of their latest project; a sales firm might send a team to potential clients in another country, and have to reimburse...
How to: Percentage of Parent in atoti
In the post “How to explain non-additive measures” we talked about how data scientists can use “parent” and “child” data relationships in atoti to analyze data and implement on-the-fly allocation rules. Today let’s make use of these atoti functions to define the percentage of parent calculation. Percentage of Parent I’m...
Building Rollup Hierarchies in Python with Treelib and atoti
A product catalogue example In this atoti tutorial, I will walk you through how you can create a hierarchy - aka parent child data structure - to interactively aggregate and drill down using python libraries Treelib and atoti. The example I’ll be using is an e-commerce product catalog, and the...
Happy Data Scientist: How to Build a Business Intelligence App with 10 Lines of Python Code
In this post, I’d like to show how to quickly build a Tableau-like BI application on top of your data in a Jupyter Notebook using the atoti python module. It can give your users an easy way to: explore the data produced by your model with an interactive UI, play...
Implementing real-time sources with atoti
Watching for file updates, appending the stores and listening to Apache Kafka UPDATE: The GIFs and code snippets in this article are based on versions prior to atoti 0.7.0. They may have evolved or become obsolete. Check out the atoti documentation for the latest features. With atoti, it’s possible to plug onto...