Fuzzy Matching And Data Cleansing
You certainly do not look forward to manually match two lists of physicians or two lists of facilities that don't have a common ID. While the eye can easily tell "Dr. Jean-Patrick Tsang" and "J. P. Tsang, PhD" are the same person, "4709 Golf Road" and "4709 East Golf, Suite 803", are the same street address, or that "Skockie, Ilinnois 60076" has a few typos and should be spelled "Skokie, Illinois 60076", the eye gets strained well before a thousand matches. The other problem with the eye is it may not catch the fact that 60066 is a bogus zip code or that the only valid zip codes for Skokie are 60076 or 60077.
At Bayser, we developed a Fuzzy Matcher tool based on Artificial Intelligence principles. The Fuzzy Matcher uses fuzzy logic and abstraction techniques on one hand and a host of dictionaries pertaining to people's names, facility names, states, cities, zip codes, area codes on the other, to automate the matching process. The Fuzzy Matcher matches databases that don't have common ids, spots errors, suggests fixes, and eliminates fuzzy duplicates.
If you are consolidating multiple data sources to set up a target list, to assess the physician/facility overlap, or for whatever reason, you now have a time- and cost-efficient alternative: the Fuzzy Matcher. Not only will you save time and money, the results will be far more accurate. You don't even have to learn how to use our Fuzzy Matcher - just email your files to us and you'll get the results back to you by e-mail along with a cleansing/matching report.
Bayser can help you
in many ways. Here are some examples.
1. Provide up-to-date physician profile databases: address, specialty, phone number, hospital affiliation, data agent ids, etc.
Build bridge files across several ids (e.g. ME#, DEA, License
Id, UPIN, etc.). This may also involve identifying prescribers (MDs,
DOs, NPs, PAs, NMs, Pods, etc.) that for some reason have missing
Third, scrub and match physician files. This can be done on an
Over the years, we
have become experts at identifying and assessing data sources in
addition to performing analyses. Our inspiration: great chefs are
experts not only at cooking but also in the ingredients that go in the
dishes they prepare. We have in our tool chest a slew of databases and
pointers to great data sources that help us address a multitude of
issues for our clients. The newest toy in the chest is a cool Fuzzy
Matcher that we developed leveraging AI. We just wrote an article on the
subject that appeared in October 2002 issue of the Journal of Data
Warehousing. If you are interested, well be glad to send you an
e-copy. In a nutshell, the Fuzzy Matcher allows us to match with great
accuracy a large numbers of physician records in a short amount of time.
Some people say God is in the details. Others say it is the devil. Whats sure, its hell to work your way up from poor or bad data. Give us a call at (847) 679-8400 or email us at firstname.lastname@example.org for a free consultation. Wed love to hear from you.
One of the brightest individuals that I've met in my career. JP has an incredible skill regarding simplifying issues, and preparing presentations for senior management." -- Director, Large Pharmaceutical Company
brilliant and gets it right away.
and I are a great team. I get all kinds of ideas and he gets them
does quality work.
amount of knowledge that they bought, not only about their tools but about
the industry & tool applications.
am very pleased with Baysers work.
real guru at Excel. Taught me everything I know about spreadsheets.
to a demo of Baysers Rx Tracker:
am having an out-of-body experience right now. --VP,
Large Pharmaceutical Company
am having an out-of-body experience right now.
--VP, Large Pharmaceutical Company
All contents copyright 2002 Bayser Consulting, (847) 920-1000