It’s not uncommon for there to be duplicate customer records within a database, but it’s far from ideal. Briefly how do they get there, what’s gone wrong? The biggest culprit is poor data entry, a customer service clerk who miss heard and didn’t verify the details, poor spelling and customer typo’s entering their details into [...]

How to implement market basket analysis?
If your business sells a mix of products to your customers, then it is essential to understand in what combination they make their purchases. Enter market basket analysis; the means to provide insight into product purchasing habits. A ’basket’ normally applies to a single order, but there is no reason why it should be restricted, a [...]

How to increase sales using data?
Why do customers buy one thing but not another? I find it fascinating and enjoy searching out their purchasing patterns. Have you ever wondered why a customer purchases one item but not another or perhaps buys a product but not an associated service? Chances are the data you need to provide this information is available within your [...]

How to retain more customers using sales data?
To retain more customers, you first need to measure your customer retention. A good place to start is to decide on who are your best customers, those you might be happy to see go and everyone else in between. Taking a classic retail approach, consider how recently they purchased products or services, how often they buy [...]





