Project Description

A leading digital imaging solutions client wanted to achieve a more complete understanding of their most valuable customers and prospects based on traceable behavior patterns. The client supports multiple point-solutions; however, they were unable to obtain a suitable unified view across these and had no means of consolidating their customers’ data.

The client, a leader in digital imaging solutions, wanted to achieve a more complete understanding of their most valuable customers and prospects based on traceable behavior patterns. The client supports multiple point-solutions, including Oracle, Salesforce.com, FileMakerPro, and IBM WebSphere, most of which manage different classes of data well. However, they were unable to obtain a suitable unified view across these and had no means of consolidating their customers’ data. The client would spend months trying to analyze this data, only to belatedly deliver findings, which were now irrelevant to the current business objectives. They needed a solution that would provide an actionable, timely view of customer data from independent source systems, both internal and external.
The client turned to Chateaux for strategic and technical guidance because of Chateaux’s stable base of senior technologists and expertise with Enterprise Analytics and Data Management. Chateaux recommended and implemented SAP BusinessObjects Data Services with Data Quality to integrate data from seven different source systems and provide the client with the optimal solution.

During the first phase of the project, Chateaux’s senior architects and business analysts conducted interviews with the client’s executives to gain a comprehensive understanding of their business. This enabled Chateaux to accurately model the components of the company from the business perspective so that information could be provided in an intuitive way for the business users.

Chateaux took feedback from the client to create a high-level logical design connecting the different components of the business. When the client approved the theoretical design, Chateaux’s developers then created a physical design meeting the technical requirements to place the client’s data into a framework, making the design become a reality. Chateaux’s ETL developers worked with the client to map all of the source systems, design the ETL framework, profile data sources, and create master data consolidation logic.

Once the framework was set in place, Chateaux created the code that satisfied all the design requirements to implement the solution. The solution incorporates technical features such as data cleansing, incremental data movement, and additional system integration (e.g., enterprise scheduling tools, email notifications, etc.). Chateaux used an agile development approach to show value to the client as quickly as possible via a rapid development platform. This method allows Chateaux to show value incrementally rather than having to wait until the entire project is completed to gauge results. Getting feedback from users along the way gave business managers confidence as the project progressed and helped ensure the end result was just what the client requested.

The solution implemented by Chateaux allows business users to explore their data with repeatable ease and accelerate performance for many operational and analytical initiatives. The comprehensive solution gave them a trusted and agile data foundation which can rapidly respond to the information demands of operational and analytical processes and systems.

The project’s results enable the business users, comprised of the sales, marketing, and product development teams, to make more informed decisions on how to target marketing messages and where to focus resources for research and development. The client is now able to identify and analyze their highest-valued end-users by pinpointing underlying trends and purchasing behavior. From these insights, target markets for their new premium line can be quickly identified and delineated, giving them a huge competitive advantage in the marketplace.