Bell gains more accurate view of customer addresses
Working with Modern Analytics and SAS® DataFlux® technology, Canada's largest communications company eliminated more than 5 million duplicate records – and gained an accurate view of domestic dwellings.
BCE is Canada's largest communications company, providing a comprehensive and innovative suite of communication services to residential and business customers in Canada.
Like many companies, Bell manages customer data in multiple applications. To improve customer service and support initiatives, Bell wanted to gain a unified view of the services already in use at a specific address. It also needed to verify that each address was, in fact, unique and distinct.
To achieve this unified view, the company used a third-party vendor to combine internal customer profiles with multiple external sources to create a master list of Canadian dwellings. However, after examining more than 24 million records from this process, Bell found errors, duplications and variations in the data. Inaccurate and unreliable data hindered the company's ability to offer new services to potential customers.
An in-house solution
After assessing the scope of the problem, Modern Analytics recommended a tailored solution – with SAS DataFlux technology at the core – to provide a foundation for this customer data initiative.
"Our experience working with Modern Analytics and SAS DataFlux greatly exceeded our expectations," says Yves Lapierre, Associate Director of Bell's Customer Data Mart. "The team went beyond simply solving the problem; they gave us the information we needed to improve our business. We were expecting a company that could just help us properly deploy the technology, but Modern Analytics helped us understand what was required as well as preparing us for the future."
"SAS DataFlux provides a robust solution that allowed us to accomplish the tasks related to this project in a timely manner," says Matthias Gruber, Director of Engineering, Modern Analytics. "With its ease of installation, configuration and user interface, the SAS DataFlux technology is our preferred choice when timelines are tight and data quality is a key. The smooth integration into the existing architecture clearly illustrates the flexibility of the SAS DataFlux solution. The knowledge transfer to the Bell team was seamless and facilitated the ultimate success of the project."
"Turning to Modern Analytics and SAS DataFlux has proven to be a great improvement over outsourcing the process," says Lapierre. "The intuitive SAS DataFlux solution is helping us get better results at a much lower cost."
The results illustrated in this article are specific to the particular situations, business models, data input, and computing environments described herein. Each SAS customer’s experience is unique based on business and technical variables and all statements must be considered non-typical. Actual savings, results, and performance characteristics will vary depending on individual customer configurations and conditions. SAS does not guarantee or represent that every customer will achieve similar results. The only warranties for SAS products and services are those that are set forth in the express warranty statements in the written agreement for such products and services. Nothing herein should be construed as constituting an additional warranty. Customers have shared their successes with SAS as part of an agreed-upon contractual exchange or project success summarization following a successful implementation of SAS software. Brand and product names are trademarks of their respective companies.
Copyright © SAS Institute Inc. All Rights Reserved.
Gain a unified view of the services already in use at a specific address, verify that each is unique and distinct, offer new services to potential customers.
SAS® DataFlux® Data Management
Gained a more accurate master list of dwellings for extensive marketing campaigns, found and eliminated 5 million duplicate records, reconcile new data nightly to ensure quality remains high.
“"Our experience working with Modern Analytics and DataFlux greatly exceeded our expectations. The team went beyond simply solving the problem; they gave us the information we needed to improve our business."”
Associate Director of the Customer Data Mart