Data Integration Blog

May 12, 2008

Enriching Customer Information

Filed under: Apatar, CDYNE, Data Integration, Data Quality — Tags: , — Alena Semeshko @ 9:15 pm

In one of my previous posts I briefly mentioned the possibility of integrating the data received from CDYNE Demographics web service with your customer database and thus extending your customer information. Well, this is now officially possible with CDYNE Demographics connector for the Apatar Open Source Data Integration toolset. The new connector delivers statistical data about customers and allows organizations to identify the ethnic and socio-economic makeup of their current customer base or purchased marketing lists. Aside from that, the connector can be used with any contacts database to determine the age, race, income, as well as type of residence, median income, median house value, or median number of vehicles, all without coding.

Ideal for data modeling and marketing
Whether you need to build customized marketing campaigns and determine ethnic or socio-economic information, this new data quality service from Apatar and CDYNE can be used to tweak your product offerings or advertising messages to reach your desired target market. Non-profit organizations or companies relying on donor support can use this data to match other groups or geographic areas to these traits in order to expand membership base and increase donations and support.

The CDYNE Demographics Web service can help companies better select target groups and learn more about their customers. With Apatar’s visual drag-and-drop interface, this source of useful socio-economic information can be integrated with your database or CRM system in minutes.

You can learn more over here.

May 8, 2008

Case for data quality

Filed under: Data Quality — Alena Semeshko @ 5:25 am

I wrote a lot about data cleansing and data quality as a one-time procedure and as a repeated practice. But here’s a catch, when do you usually think of and/or worry about the quality of your data? When migrating and integrating it? When using it in marketing? When building your strategy based on it? Has it ever crossed your mind that the quality of data needs to be thought through before it’s actually gathered? That’s new and you don’t see too many companies thinking of it…yet. We don’t quite realize that even at the early stages of preparing for data gathering and while obtaining it, data quality aleady plays an important role in the future of your company. It is the early stages that make a difference in how your data turns out and if. If approached properly from the very beginning, your data will surely pay off when you get to sharing and maintaining it, and especially when applying it.

Cost-wise, this approach is rather efficient too. Although I always say that corporate data is not the thing to save up on and it might not sound quite like me =), but investing in data quality from the very beginning would save up a lot when it comes to verification, cleansing and usage. Cleansing, as a matter of fact, may very well become redundant. Sweet?

May 6, 2008

“SOA is the Enabler”

Filed under: Business Intelligence, Data Integration, SOA, data mashup — Alena Semeshko @ 11:46 pm

A recent article in InformationWeek discusses 8 current trends in IT that companies should pay close attention to is they don’t want to lagger behind.

Here are the 8 trends with my highlights and comments to some:One: Cloud computing.

Two: Light systems.
That is, application mashups. “The difference between spreadsheets and mashups, he says, is that the data used in a mashup is live, and by using it in a mashup you publish it as an application, so other people can use it, extend it, etc.” Mashups drive the progress, yep.

Three: Business intelligence.
SOA is referred to as a savior in allowing businesses to get their hands on data and applications in just the way they need. SOA (service-oriented architecture) “provides a lot of agility for putting together systems at the back end,” he says, “SOA makes the plumbing easier. It’s the enabler.” I couldn’t agree more.

Four: The always-connected user.
“My professional and my personal lives are no longer separate.” As with most of these trends, security is the biggest holdback. Companies will have to rethink security policies completely.

Five: Social networking.

Six: Dramatic growth in user-generated content.
Unstructured Web data represents new models in CRM. However if you think of services like CDYNE Demographics that gather statistical data on your customers and provide you with a whole set of information that you can use in your marketing, it’s obvious that this problem is already being taken care of. If tools like that are used wisely and integrated into your customer CRM (the type of integration Apatar will be offering shortly) this unstructured user data can become a global value for your company’s growth.

Seven: The “forever beta” approach to software.

Eight: Sustainability (a/k/a green computing).

May 2, 2008

Interop-Software 2008

Filed under: Apatar, Data Integration, events — Alena Semeshko @ 4:45 am

Apatar CEO Renat Khasanshyn is currently attending Interop-Software 2008 data integration conference in Las Vegas, NV. Hope you get a chance to meet him in person, if you happen to be there at the same time. If not, you can always check out Renat’s impressions of the conference in his blog.

And if you didn’t get to visit this Interop, you are just in time to register for the next one in Tokyo, Japan on 9-13 of June this year.

May 1, 2008

SugarCRM Delivers Enhanced Enterprise Reporting and Wireless Features

Filed under: Apatar, Data Integration, SugarCRM — Tags: — Alena Semeshko @ 2:21 am

SugarCRM launches new capabilities.

SugarCRM Inc., the worlds leading provider of commercial open source customer relationship management (CRM) software, announced the beta release of new reporting and wireless capabilities for SugarCRM. The new reporting and analytics engine provides SugarCRM users with improved insight into sales effectiveness and customer behavior. Revamped wireless capabilities deliver the feature-rich SugarCRM user experience on mobile phones, including support for the popular BlackBerry® and iPhone mobile handsets.

Support for iPhone, huh? I can see a tendency… Everything and everyone goes “i” and mobile. Which isn’t bad, actually. The new wireless features include:

  • Improved User Interface provides navigation into edit, detail, and list views, as well as the ability to access employee directory, store preferences and view recent items.
  • Rich HTML Client delivers rich presentation of SugarCRM data through a standard Web browser.
  • Device Independent allows users to view SugarCRM data from any PDA or smart phone, including the BlackBerry and iPhone.
  • New Search Capabilities allow users to find information quickly with the press of a few buttons.

Come to think of it, with SugarCRM going wireless, and with Apatar  SugarCRM connector installed you can now have any of your database (SQL, Oracle) data up in SugarCRM and on your mobile device in practically no time. I love this integrated world!

April 29, 2008

Let’s talk data security

Filed under: Data Integration, Data Migration, Data Quality, data security — Alena Semeshko @ 11:49 pm

You are at the stage where you’ve already realized that your company lives and thrives on data (research, development data, customer private data, contact list, spreadsheets and tables etc.). You work so hard and do everything you can to keep your data clean and consolidated, and once you finally have the system that delivers quality at hand, you realize that your data isn’t exactly safe. Bummer! Today, when information is as valuable as it is and companies cannot afford having it stolen, lost or disclosed, information security becomes the critical element and basically the driving force in most business processes.

All potential threats can be divided into external or internal ones. External threats include unauthorized programs (such as worms, Trojan viruses, spy-programs, etc.), and there is really no universal solution that would protect your company from all types of threats, that’s why there are so many specialized tools taking care of each particular problem. These can be efficient, I’ll have to admit. However, it’s the internal threats that usually make companies most vulnerable. And two of the most probable scenarios of information security violation are 1) the deliberate theft of confidential data by authorized users (or so called insiders) and 2) unintentional leak that can be caused by a number of factors (lack of awareness about company’s security policies, for instance).

When creating an information security system, developers try to extend its functional to the maximum so as it would ensure extensive protection. Even operation systems today contain security functions designed to increase the enterprise’s safety level. But this “universality” is unacceptable when speaking of valuable data. A universal security system becomes useless in corporate networks where internal threats (whether intentional or not) prevail.

A recent Forrester survey of 305 security and email professionals revealed some scary but realistic statistics:
1 in 3 companies investigated a breach of confidential data last year.
1 in 4 companies experienced an “embarrassing” leak of confidential information.
1 in 5 emails contains a legal, financial or regulatory risk.

Ways out? Again, a global approach. This article on EbizQ.net suggests Data Loss Prevention (DLP) technologies as a way of securing your most valuable asset and creating transparency by enabling companies to monitor and track the whole data flow. Transparency is good. Transparency is good everywhere actually. Come to think of it, transparency is the key to creating a healthy and productive environment. Even in data integration systems, transparency is a neccessity, allowing you to see where your sensitive data is going, how it’s being transformed and saved and howsecure it is during these transactions. Transparency is another global asset that needs to be integrated into the corporate system o values. You could say, of course, that transparency is just another vague notion (like total security and clean data), perfection hard to achieve, especially for the old market players with set processes. Hard, yes, but not impossible. It’s something to go for. In the end, when your transparency efforts deliver security, it’s your company that will benefit.

So, looks like get transparency equals get security.

p.s. keep in mind, like with anything that has to do with data cleansing, integration and migration, technology usually comes in more handy and much cheaper than employees’ training!

April 28, 2008

Salesforce Professional Network on LinkedIn

Filed under: Salesforce — Alena Semeshko @ 10:03 pm

Did you know Salesforce.com has a LinkedIn group that you can join? The group already has over 1,000 members and only continues to grow. You can join Salesforce Professional Network over here. LinkedIn is after all THE proven old-school professional social network. =)

The Salesforce.com Professional Network connects former and present salesforce.com users, administrators and employees, allowing them to expand their professional development, exchange ideas, network and continue to be a part of the Salesforce.com community.

As a group member, you’ll have the option to make your profile available to other group members. You’ll also have a Salesforce Professional Network badge on your LinkedIn profile.

April 27, 2008

DIG 2008: Decisions, Information and Governance

Filed under: events — Alena Semeshko @ 10:23 pm
If your organization cannot answer “yes we do”
to any of these following three questions, welcome to DIG 2008!
Decisions – Do you have a key management competency that enables you to make good decisions and drive breakthrough performance?
Information – Do you analyze massive amounts of data to find Aha! insights against the backdrop of one version of the truth?
Governance – Do you have a management rhythm that ensures that the best minds are looking at the best information to accurately forecast performance and allocate resources?

The conference will take place on May 13-15, 2008 in Las Vegas

April 25, 2008

Good Customer Data is a Must-Have

Filed under: Data Cleansing, Data Integration, Data Quality, ETL — Alena Semeshko @ 12:58 am

Making the most out of your customer database and relations management solution is what every company wants. No doubt about that. Nonetheless, a huge number of CRM approaches prove insufficient and inefficient.

Here are the six aspects of CRM deployment that Richard Boardman in his recent article calls essential:

1. Poorly defined requirements
2. The availability of internal staff
3. Sign offs
4. Data Good systems require good data, and, if the new system is to be populated with existing data, it’s important that the quality of that data is high. Many organisations are surprised at how many data sources they possess and how poor the data quality is. The cleansing of data and reconciliation of different versions of the same record in multiple data sources can be very time consuming. While there are tools that can help, this process tends to be very manual, and is not something that can be fully outsourced as it requires considerable input from the data owners.
5. User acceptance testing
6. User adoption

I still think data is the key element in this. It’s how you approach, structure and work with your data that makes a difference in your company’s progress. I’d break number four into more precise items like
1. Well-defined data requirements
2. Customer Data Integration & Data Quality (including ETL, data cleansing and everything related to it)
3. Data management, that among other includes following through with your requirements and cleansing procedures rather than adopting a once-in-a-lifetime/lifecycle (whatever you wanna call it) scheme.

But I agree with Richard, you still need to be “realistic about the demands these projects will place on the organisation and manage expectations accordingly. Too often CRM projects are deemed failures because they failed to meet impossibly demanding and often self-inflicted deadlines. A better review of what’s involved and a more analytical appraisal of the availability of resources to meet those demands will go a long way to ensure project success.

April 22, 2008

Data Quality At Large

Filed under: Data Cleansing, Data Quality — Alena Semeshko @ 10:35 pm

What’s data quality for you? Right customer contact information in your CRM? Think again? Data quality is more than that, much more than that. Product numbers, associated descriptions, part numbers, units of measure, medical procedure codes and patient identification numbers, telephone numbers, email addresses, commodity codes, vendor numbers and vehicle identification numbers, the list goes on.

This article in CXO describes some consequesnes of poor data quality:

For the CEO, whose ultimate responsibility is to increase customer retention and loyalty, the effects of poor data can have long-term, devastating consequences. For example, the inability to eliminate redundant name and address records results in additional mail-order campaign costs. Recipients of duplicate mailings are also likely to become frustrated and question the firm’s overall operating efficiency. If these redundant mailings each consistently misspell the individual’s name or address, the frustration level is likely to approach alienation or even a legal concern – especially if the recipient had previously made a request to the mailer that they be removed from the vendor’s mailing list or asked to be placed on an industry-wide, do-not-mail list.Add to this the cost of the catalogs or merchandise delivered to the wrong address and the real magnitude of the problem only just begins to surface. If a single customer is included in a company’s database multiple times, each time with a different value for the customer identifier, the company will be unable to determine the true volume of this customer’s purchases. It could even be placed in the embarrassing situation of attempting to sell the customer an item that he or she has already purchased. Poor data quality can negatively influence how a company is perceived in the marketplace and damage brand equity.

These data inefficiencies can also result in missed up-sell and cross-sell opportunities. Without a single view of the customer across the enterprise, it’s impossible to aggregate information to make decisions. This makes it impossible to distinguish between single-product and multi-product buyers, or between new and existing customers

For the CFO – who is in charge of regulatory compliance, managing security risk and other methods of limiting exposure – poor data can result in the company facing public embarrassment, loss of credibility, significant fines and even lawsuits. A forward-thinking organization should include data quality as a part of its everyday operations. While this may not happen overnight, recent regulatory and Homeland Security initiatives such as the U.S. Department of Treasury’s Office of Foreign Assets Control (OFAC), Sarbanes-Oxley, the U.S. Patriot Act, and the Health Insurance Portability and Accountability Act (HIPAA) can quickly spur a company to establish a solid data foundation.

[…]

For the CIO, who spends his days striving to achieve peak operational efficiency, inferior data quality can lead to missed opportunities to negotiate better rates with suppliers. Large companies can have thousands, or even millions, of suppliers. Unless you have precise data on how much total business you are conducting with a single vendor across all divisions, you are likely to pay too much for their service.

So what do you do to improve? The article suggests the following:

First,  conduct a Data Quality Assessment to help you recognize the severity of data quality issues.

Second,  adopt a well-defined Data Governance Plan across your organization. That is, define who owns the data, who is authorized to access the data, and which specific standards should apply to the data.

Third, choose a technology to serve as the backbone for the intelligent use and preparation of relevant customer data.

Sounds short and sweet, but try following it through. Will take a while, but you won’t regret it.

Older Posts »

Powered by WordPress