Customer Loyalty and 
Market Basket Analysis

Customer loyalty is an ongoing positive relationship between a customer and a business. It’s what drives repeat purchases and prompts existing customers to choose your company over a competitor offering similar benefits.

In the dashboard below we are checking this exact concept. We have an online shop with different type of products were we have a growth in quarter sales for the year 2019. But what about future? Is our company profitable enough to keep growing? We will analyse how old customers are perfoming and if their are repeatedly choosing to buy products from this shop. The best fits are those that should merchanised together in order to drive more profit to the company. So, let’s get into data talking. 

Goal

The purpose of this dashboard is to contact a customer loyalty analysis with an extensive market basket analysis for helping the online shop to have an overal overview about customers behavior and which products are mostly bought together.

Result

By using the dashboard below, you can have a clear view about the sales that the shop has for each quarter and if customers are keep buying from there or not. Which of them are the most loyal and which products they prefer to buy together to make a more targeted advertising.

Project Duration

On average, the development of a dashboard takes 3 weeks – 2 months. The development consists of three phases:
1. collecting and cleaning data
2. selection of KPI’s and design of the dashboard
3. dashboard development