DQP - Data Quality Profiler Product and Services
Financial Products and Services
For one large financial institution, DQP maintains a digital signature of all incoming customer accounts from its transactional system. Because of an annual upgrade to the system, the customer region code format changed. DQP determined that the sudden change in region code format would result in a massive number of new accounts being created - and therefore hundreds of millions of duplicate records would be inserted to the data warehouse. DQP prevented massive confusion among the bank's business community over key performance indicators such as number of customers, or the size of customer accounts. The data warehousing group was also spared from spending a large amount of time correcting the problem, therefore meeting its service level agreements, and retaining credibility with its business customers.
KETL™ Open Source Product
Internet Information Provider
In the market there are a variety of commercial ETL tools to move complex data. This global online network company wanted to save money by self-sufficiently move their own data. With Kinetic Networks' KETL™ Open Source solution, the client was able to adapt the technology in their business to process high volume, complex data incorporating lots of data movement and business rules and to continue to meet business demand.
E-Commerce
After heavy investments in business intelligence tools, this eCommerce company was reticent to purchase another tool. The client selected the KETL™ Open Source tool sponsored by Kinetic Networks to complete click-stream processing and scheduling.
The KETL™ platform allowed the company to manage complex manipulation of data while leveraging the affordability of an open source data integration platform. Rather than developing custom logic that is difficult to debug, monitor and maintain; KETL™ offers a metadata-driven solution that adds robustness and functionality. The final solution included over 1000 transformations and provided the professional services needed to implement the warehouse on time and on budget.
Entertainment and Communications
This entertainment and communications company needed a way to quickly and reliably disseminate sales and web traffic information to its business groups. After making heavy investments in OLAP tool licenses, purchasing commercial applications for click-stream analysis would have been extremely expensive due to the volume of data being analyzed. In addition, the client was reticent to purchase costly database & ETL software as well. By using Kinetic Networks' KETL™ solution, this client has improved measuring and quantifying their online advertising campaigns as well as simplifying and reducing administration costs. |
