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...
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 is not as straightforward as taking the cost price away from retail price to derive the margin. There are many variables that may affect the final profits. One of these variables is the...
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 card fraud detection series. I attempted to create a real-time credit card fraud detection application with the below three Python libraries. I’ll be focusing a lot more on my experience with PyCaret,...
Understanding Climate Risk with Anne Gruz
Based on her expertise in financial risks and her commitment to climate action, Anne demonstrates how to include climate risk in financial models and how rerouting flows towards the funding of emerging technologies can make a difference. I had the pleasure of speaking with Anne Gruz, founder of Iggaak on...
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 integrating customer data from disparate sources for an organization. We explore Customer 360 with a typical service provider scenario. A customer can have multiple engagements with an organization. Each engagement may be handled...
Complementing RDBMS with multidimensional analysis
Create an OLAP cube from your relational database with minimal ETL effort You probably know what RDBMS is since you are reading this article. Most probably, you have also dealt with some reporting tools that are backed by relational databases. So, what do you know about multidimensional analysis? In order...
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 the IBOR Transition programme for Standard Chartered Bank. With the cessation of LIBOR (London Inter-Bank Offered Rate) by the end of December 2021, Gopu and his team faced increasing requests from the various...
California wildfires and solar irradiance
California wildfires are increasingly intense. Understanding how these wildfires impact everything from air quality to solar irradiance is crucial. In January 2020, California mandated solar panel usage in new construction. Even before 2020, and certainly since, solar panel adoption increased year after year. But at the same time, California experienced...