I recently watched Todd Sampson's redesign my brain series on ABC1 and I found it really cool how we all use so little of our brain and that with a little training we can increase our performance dramatically. It is fair to say that it was the opportunity and the gains to be made through some training that could result in a real impact that was most impressive to me. I guess the reason it struck a chord with me was my long held view of a similar ilk that we use only a little of the vast array of data within our companies' datamarts and warehouses and that with a little exploration and perhaps a bit of training a lot of value can be gained.
So where is it?
Largely this untapped data is contained in the transactional data that is collected every time a customer has an interaction with your company. This might be logging in online, updating information, it might be a late payment, a call into your service centre, it could be their payment timings; it could be a range of things. The key is that they are stored in transactional tables and by definition measure a behaviour of sorts.
So how can I use it?
Typically the way data modellers use the data in this sense is to link it back to the account table and rationalise the data into a flat file. This is done by aggregating the transactional data into a measure. For instance it could be the number of logins in the last 90 days, or calls into to the service centre in the last month or a yes/no flag as to whether they have made a late payment in a given time period.
From there it is about what you are looking to achieve. Is it to reduce churn? Is it about increasing sales? Is it about targeting people who are most likely to purchase? All of this data is typically held in the average data warehouse and it's about getting in touch with the right people who can give access to these tables.
I'm interested to hear about peoples experience with using data from strange sources to achieve a measurable outcome - please share if you can and any challenges faced!
So where is it?
Largely this untapped data is contained in the transactional data that is collected every time a customer has an interaction with your company. This might be logging in online, updating information, it might be a late payment, a call into your service centre, it could be their payment timings; it could be a range of things. The key is that they are stored in transactional tables and by definition measure a behaviour of sorts.
So how can I use it?
Typically the way data modellers use the data in this sense is to link it back to the account table and rationalise the data into a flat file. This is done by aggregating the transactional data into a measure. For instance it could be the number of logins in the last 90 days, or calls into to the service centre in the last month or a yes/no flag as to whether they have made a late payment in a given time period.
From there it is about what you are looking to achieve. Is it to reduce churn? Is it about increasing sales? Is it about targeting people who are most likely to purchase? All of this data is typically held in the average data warehouse and it's about getting in touch with the right people who can give access to these tables.
I'm interested to hear about peoples experience with using data from strange sources to achieve a measurable outcome - please share if you can and any challenges faced!
No comments:
Post a Comment