A ‘Sales Analytics’ product architecture series — Part III : Architecture for a ‘Sales Analytics’ product.

Part I : Customer Segmentation using sales data

Part II : Credit Risk analysis from ledger data (Tally output)

Three considerations that I kept in my mind while I wrote the code and designed the architecture for the product are:

1. Fast execution
2. The Output should have the potential for visualizing the story of each customer.
3. The code must be able to handle any Tally outputs, irrespective of the format.

The final dashboard is interactive and you can select customers from the ‘Customer ID’ drop-down to visualize the story of a particular customer (like in Fig 2). The ‘Customer Ids’ marked in green are recent customers.

Fig 2

Fig 2

This final part of the series will focus on packaging all that we discussed so far into a product.

I have designed a dashboard using Figma, click on this link to view.

Here we will be covering only the result creation part, visualization can be done using chart.js or any other frameworks.

Here’s the link to my Google Docs, there you can view the data architecture that I’m planning to do.