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 sales commission that varies between different salespeople and different sales items. …

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, an AutoML library that will allow me to predict…

Part 1: Investigating fraudulent transactions real-time with atoti — Credit card fraud figures were boosted by the COVID-19 pandemic, making it more vital than ever to be able to detect credit card fraud quickly and effectively. We split this article into two parts: Investigating fraudulent transactions from a business user’s point of view Behind the scene technical implementation of…

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 by one or more departments within the organization. For instance, there’s the…

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 to give you an idea of multidimensional analysis, think of the Pivot…

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 business streams on the IBOR (interbank offered…

Going beyond multidimensional analysis with Python — While many data scientists or analysts are excited about doing their analysis, the analysis itself constitutes only a portion of a full solution. Securing the system, for instance, is critical for most, if not all projects, especially those that involve sensitive data. atoti — Creating BI application with Python atoti is a free Python library that allows…

Multidimensional analysis gives the ability to view data from different viewpoints. — This is especially critical for business. Let’s take a quick look at the few visualizations below. We saw that with the same set of data, we are able to view the margin per shop, per product category, or for a specific brand or product, their margin getting broken down further…