This is Anish's Typepad Profile.
Join Typepad and start following Anish's activity
Join Now!
Already a member? Sign In
Anish
Recent Activity
Image
Last week we looked at three charts most often requested by clients, charts that are very useful in managing your business’ data quality. If you didn’t get a chance to read Part 1, here’s a link 9 Most Popular Data Quality Charts (Part 1) In this second of three posts, we look at a further three charts that are essential for managing your data. When speaking about data quality, most of us focus on what’s wrong with our data, but there is another more important measure, namely, what data are we missing. Having data with errors is annoying and a... Continue reading
Posted Feb 23, 2017 at Acuate Data Quality
Image
I don’t know about you, but when I receive a lengthy business report I always have a feeling of ‘oh no!’ I’ll admit it, I love looking at charts and diagrams…I feel I can see the right questions to ask immediately…what the chart shows and what the chart doesn’t show. I can then decide to read the report or seek answers elsewhere. When you’re busy, this has to be the best way to see information. “A picture is worth a thousand words” is never truer when analysing data quality results. In this first of 3 posts, I’m going to briefly... Continue reading
Posted Feb 2, 2017 at Acuate Data Quality
Image
My nephew’s thinking of a career in sales. While researching on the internet he came across the infamous sales movie Glengarry Glen Ross starring Al Pacino, Jack Lemmon and Alec Baldwin. For all sales people out there, this is just ones of those movies you watch, whether you agree with the contents or not, but for some young sales people, the testosterone driven environment is really encouraging. One of the most famous scenes is where Blake (Alec Baldwin) is sent from the parent company to motivate an underperforming sales team by unleashing a torrent of verbal abuse. In that scene... Continue reading
Posted Jan 26, 2017 at Acuate Data Quality
Image
When you fancy a particular meal, sometimes going to the right restaurant is what you need, but if you know it’s home cooked, then it’s likely to taste so much better. Well, that’s my feeling about creating a targeted data set. Buying is sometimes right, but often, building your own is so much better. Before I start on the pro and cons, I have to say, for some target markets there are some very good niche data suppliers out there, in which case buying is a no brainer. However, there are many companies that are just not happy with the... Continue reading
Posted Dec 8, 2016 at Acuate Data Quality
Image
I recently came across a lovely Telemarketing company with a compelling proposition of guaranteeing good quality appointments for his clients for a fixed price and the client would get to determine the quality, a good deal all round! So, here is someone delivering what they promised, but their results are dependent on two key factors: The message The data As an experienced marketer, one can control the quality of a message until it gets the conversion rates you require. However, this company relies on the client providing their data as basis for the telemarketing campaign. If the quality of the... Continue reading
Posted Nov 24, 2016 at Acuate Data Quality
Image
“There is real magic in enthusiasm. It spells the difference between mediocrity and accomplishment” – Norman Vincent Peale For me this quote sums up why some companies have good data and why others have poor data. It’s their enthusiasm about data. When you’re not so enthusiastic about your data, then it’s likely your data will be mediocre or of poor quality, but if you’re enthusiastic about data then I’ll bet you have good quality data. So here are 5 suggestions that will move you from mediocrity to excellence: Having an Evangelist If you may have the overall responsibility for your... Continue reading
Posted Nov 17, 2016 at Acuate Data Quality
Image
Have you been through that experience where you procrastinated or had a fear about something, only then to overcome it and think to yourself ‘that was a lot easier than I thought and what took me so long to overcome it’. You then realise it’s all in your head. So you may be wondering how one can have a fear of cleaning data…it’s only data after all, but no need to mock it…you’ll be surprised how often this happens. Fear happens when you see a threat from danger, pain or harm. In our context, it’s the pain that triggers this... Continue reading
Posted Oct 28, 2016 at Acuate Data Quality
Image
Do you remember the time when you decorated a room or a house, and after many days of toil you looked at the final product only to see bits of your new wall not painted, or the paint on the skirting has edged over to the wall, and so on, and you keep on spotting tiny errors here and there. You then go through the process of tidying this up, and if you’re like me, you’re wondering how you missed all this, I was always sure I worked thoroughly. We’ll, we are only humans, and we are going to miss... Continue reading
Posted Sep 23, 2016 at Acuate Data Quality
Image
This is got to be one of the most frustrating aspects of helping companies achieve exceptional data quality; it’s the CRM’s inability to import cleansed data easily. For the larger CRM systems the task of re-importing cleansed data is not too onerous, but merging duplicate data can be a real challenge. Now it’s understandable that merging two entities in a CRM application is complicated, here are two good reasons why: (a) Because of all the linked information. For example, an account may have contacts, opportunities, orders, activities, tasks, etc. attached to it, so all of these have to be merged... Continue reading
Posted Sep 15, 2016 at Acuate Data Quality
Image
So here’s my take on how the majority of companies (not all) see data quality (admittedly some do not see data quality at all, but that’s another blog post.) Many see data quality as a percentage game – 80% good data is good enough – and there is plenty of merit to warrant this approach, but as I’ll try and explain taking data quality from maybe a 80/20 game to 95/5 game or 99/1 game or even 100/0 game is doable and the upside significant. I can hear people screaming about 100/0 game but for some companies this is an... Continue reading
Posted Mar 23, 2016 at Acuate Data Quality
Image
Imagine you’re 16 years old, it’s the first day of your public exams, it feels a little scary and certainly you’re apprehensive. Your life’s path could be defined by these very results. Even writing this now gives me a sense of past nervousness, so I can’t imagine how it feels for today’s students. Now rewind to a few months earlier when you’re in the midst of creating a revision plan. If your revision plan consisted of a single method of learning for all your subjects, then the likelihood of you doing well in all your subjects is far less than... Continue reading
Posted Mar 16, 2016 at Acuate Data Quality
Image
‘It would be really, really nice if all our clients’ data were in a similar format and of similar quality, then we could write simple automated routines to create excellent levels of data quality and not have to work too much.’ We’ll, I can keep on dreaming all I want, but the harsh reality is that data comes in as many variations as there are clients. This is not that surprising as data has its own personality primarily driven by the characteristics of the company or people managing it. (See a previous post on Data Personality to explain why.) If... Continue reading
Posted Jan 26, 2016 at Acuate Data Quality
Image
A few years ago I came across a story about a data migration for a new CRM application that can be classified in the ‘Oops’ category. The company in question had a rather large CRM application being deployed over several sites and hundreds of users. The responsibility fell with the IT team to make it happen smoothly. The IT team had a good reputation for project implementation and undertook all the necessary steps for a successful roll-out, apart from this one mistake. On go-live day, the system worked flawlessly, all users were trained with additional video training available via the... Continue reading
Posted Jan 19, 2016 at Acuate Data Quality
Image
Data Matching is one of those beautiful techniques that rears its head across lots of different applications. It involves complicated algorithms and can be a science as well as an art. But it is surprising how many times these techniques are required in so many business applications. Before we list some of these applications, let’s quickly review what we mean by Data Matching. Trying not to be too technical…it’s the process of comparing 2 or more data sets to see if records from either of the data sets are the same or similar. A special case of data matching is... Continue reading
Posted Dec 2, 2015 at Acuate Data Quality
Image
Recently, I attended a sales meeting with someone who didn’t get data quality. For some reason the topic seemed too bothersome or just not relevant to them. In this case, it was relevant to this person because they were responsible for the company’s data quality; admittedly it was their primary responsibility. I was surprised to hear them say that formatting name information didn’t matter much as their mailings got to the right people. He had been cleaning addresses, so the mailings were being delivered to the correct destination, but he was taking a risk in the name not being correctly... Continue reading
Posted Jul 6, 2015 at Acuate Data Quality
Image
Every time I’m interested in a particular website, I have no hesitation to give them my email because in return I’m getting some information that I want. There’s a trade here, an email address for something I value. This process of trading something you value to capture a potential prospect’s details is the best way to capture contact details. An attractive offer must be created that has enough value to be traded. In some cases a whitepaper is sufficient, or a video or some free software. What the offer is, will depend on your business and the value perceived by... Continue reading
Posted Jun 26, 2015 at Acuate Data Quality
Image
Have you every procrastinated on a task, knowing that you should do it, but for some reason it’s doesn’t seem relevant, not exciting enough or just too difficult; you go through that crazy loop of saying you should do it and then you don’t, you should do it and then you don’t, and the cycle continues. Until all of a sudden the task becomes the most important task ever! Perhaps a deadline is approaching or there are big consequences if you don’t do it – now you are motivated to move and complete the task. We’ll this is how it... Continue reading
Posted Jun 19, 2015 at Acuate Data Quality
Image
I get a lot of requests to find emails for clients and at times it seems like there’s a mad rush, a bit like the California Gold Rush of 1848, where at first, loose gold and gold nuggets could be picked up off the ground. 300,000 people from all over the world rushed over a 7 year period to find their fortune. The rush for emails is not that spectacular, but it's certainly immense. So, why is it a gold rush, well gold was scarce and precious so had a great value as many desired it; with email addresses, it’s... Continue reading
Posted Jun 12, 2015 at Acuate Data Quality
Image
Every now and then you come across a new service that seems highly useful, for me email validation falls into this category. Not only does it help you to identify business contacts that have moved (email no longer valid), but helps maintain a good quality email mailing list (with only valid emails), keeping you clear of any spam filters. (Related Post: Why business relationships are so important) It's worth knowing how the process works, then you'll be able to assess what the results are telling you and what you can expect. We’ve produced a short video about its importance and... Continue reading
Posted Jun 8, 2015 at Acuate Data Quality
Image
Imagine walking into a shop and buying an item without even seeing it, you probably wouldn’t do that, well that’s how it feels when I’m buying data. You sign up to an agreement, trust the data is ok, but you don’t really know what you have until you use the data. It’s a strange industry, what makes it worse, is that with many suppliers you can’t even return the data. If you could return the data, you would have a proportion of customers buying the data and then returning it for a full refund, but then continue to use the... Continue reading
Posted May 29, 2015 at Acuate Data Quality
Image
Data Migration can be fairly daunting at the best of times and having taken on many projects in the past I know how challenging it can be. To help you with your projects, I've compiled 17 Top Tips on Data Migration and practical steps for you to think about. With any data migration project you will need to consider activities before and after a migration, these tips will cover those stages too. By including these steps you will experience a smoother transition that will lead to a successful migration outcome. We've also created an infographic to give you a summary... Continue reading
Posted May 20, 2015 at Acuate Data Quality
Image
I was observing one of our Account Managers reviewing records in our salesforce.com system, occasionally he would come across an account with missing information. He naturally turns to the internet to find missing information such as telephone numbers, addresses, job titles or even an email ID. The Account Manager would look for information on individual contacts as well, or people that have moved jobs or changed roles, inevitably all the information is publicly available online. In the pre-internet days this wasn't possible, you would either call the company in question or flick through one of those rather large directories that... Continue reading
Posted May 12, 2015 at Acuate Data Quality
Image
Managing data can easily become overwhelming…so here are some quick simple steps you can take to improve data. 1. Cost Effective Email Validation Emails are so vital these days…but like most data, eventually an email can become redundant (particularly with company contacts having 22% of employees changing jogs yearly). One simple step is to validate every email! There are now many online email validation services out there…they allow you to upload an email file and they will ping the email to see if it’s valid. So what results can you expect from validating every email address? When you ping an... Continue reading
Posted May 6, 2015 at Acuate Data Quality
Image
Hi, its Anish Raivadera here, welcome to our blog. If you are involved in CRM, Marketing, Data Quality, Business Intelligence or anything related to corporate data then this blog is dedicated to you. What Every Manager Needs To Know About Data The 7 Dimensions Of Data Quality How To Master Data Cleansing Two Informative Guides We look to provide practical help in getting most out of your data. Whether you are migrating data, improving your target audience data or cleansing to improve campaign returns or meet regulations, you’ll find something here for you. My passion is for software and data,... Continue reading
Posted May 1, 2015 at Acuate Data Quality
Image
Do you remember the time when CRM systems first came to market? The excitement was at fever pitch with the notion of some great software would transform your business as relationships with prospects and customers can now easily be built, subsequently growing your revenues exponentially. 20 years later we can reflect on how well these projects delivered on the original vision. In reality, many projects failed to deliver the promise of Single Customer View, not because the concept was wrong, but because implementations are so much more than just software. It’s also about how your business engaged with customers, your... Continue reading
Posted Apr 14, 2015 at Acuate Data Quality