Quality-assured Data Management in an End-to-End Diagnosis Project

[vc_row el_class="container"][vc_column][vc_btn title="Succes stories" style="classic" shape="square" color="btn-light-orange-blue" i_icon_fontawesome="fa fa-angle-double-left" add_icon="true" link="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fsuccess-stories%2F|title:Succes%20stories||"][/vc_column][/vc_row][vc_row el_class="container reference-mobile" el_id="reference-detail-layout"][vc_column el_class="reference-detail-layout-left .reference-mobile-order-2" offset="vc_col-lg-8 vc_col-md-8"][vc_row_inner][vc_column_inner][vc_single_image image="4632" img_size="750x495" el_class="reference-detail-layout-left-image"][/vc_column_inner][/vc_row_inner][vc_tta_accordion shape="square" gap="20" c_position="right" active_section="1" el_class="reference-detail-left-accordion"][vc_tta_section title="The Challenge" tab_id="1508250369004-11fd70c1-c50a"][vc_column_text]The Deutsche Telekom AG is a global telecommunications company headquartered in Bonn. They provide the full range of modern telecommunications and information technology to millions of private and business customers: from mobile and landline communications to the Internet through to complex IT and telecommunications solutions. The company offers various product packages in the so-called triple play area. The term “triple play” describes the convergence of the three services telephony, TV and Internet access. Within the product package "T-Home Entertain" the customers of Deutsche Telekom receive a broadband connection, which offers the opportunity to use these services via an IP-based connection. To ensure the availability and quality of this product and its components, a solution to monitor and evaluate, and appropriate means to deduce necessary measures for improvement are needed.[/vc_column_text][/vc_tta_section][vc_tta_section title="The Solution" tab_id="1508250369051-4a626d72-344d"][vc_column_text]Within the project, an analysis and monitoring system with measurement points along the product chain in the field of IPTV products has been developed and implemented. As a prerequisite for the monitoring of the process and the measurement points respective operating numbers were defined, due to which qualitative improvements can be identified. The business intelligence software QlikView® was installed as a front-end and analytical tool for the metrics-driven end-to-end diagnosis of interferences at the customer’s product or at the systems. The databases of all relevant source systems were integrated into a data mart via a multi-stage ETL process. In this process specific mechanisms to ensure the data quality and thus to guarantee significant results were constructed. At this point, QlikView was deployed again, as a monitoring solution for indicators to safeguard the quality of the data. At the same time, a metadata model for the management and analysis of quality and process information has been integrated. The data integration and data quality management architecture was implemented on the basis of Informatica PowerCenter and Informatica Data Quality. The data storage and the design of data marts were carried out with Oracle 11g Enterprise.[/vc_column_text][/vc_tta_section][vc_tta_section title="The Result" tab_id="1508252697978-ef0a40d1-ea09"][vc_column_text]The realized measures allowed a complete end-to-end diagnosis of potential interferences of all systems and components, which are part of the production, through individual and mass analysis. With the evaluation of the diagnosis results the availability and quality of the product "T-Home Entertain" and its components can now be consistently monitored and possible deficiencies can be detected early. Thus, statements about existing vulnerabilities are possible and necessary measures can be initiated quickly and efficiently.[/vc_column_text][/vc_tta_section][/vc_tta_accordion][vc_row_inner el_class="reference-detail-left-heading"][vc_column_inner][vc_custom_heading text="Graphic" font_container="tag:h3|text_align:left|color:%23193d66" use_theme_fonts="yes"][/vc_column_inner][/vc_row_inner][vc_row_inner el_class="reference-detail-left-image-text"][vc_column_inner offset="vc_col-lg-3"][vc_single_image image="4635" img_size="165x165" onclick="link_image"][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_column_text]Grafik: Visualization of performance indicators per connection range within an area code[/vc_column_text][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][/vc_column_inner][/vc_row_inner][/vc_column][vc_column offset="vc_col-lg-4 vc_col-md-4" el_class=".reference-mobile-order-1"][vc_row_inner el_class="background-color-grey reference-detail-right-sidebar-one"][vc_column_inner][vc_column_text]PROJEKTOVERVIEW Customer Deutsche Telekom AG Customer Objective Complete end-to-end diagnosis of potential interferences Our Solution Conception and implementation of an analysis and monitoring system Customer Benefits Monitoring of the availability and quality of the product Early detection of defects Higher customer satisfaction Process optimization "Our longtime partner TIQ Solutions is equipped with profound professional and technical telecommunications-specific knowledge regarding processes, data and interfaces of network and IPTV systems, which contributed to the success of the project to a large extent." Ruben Señor-Megias, Senior Expert - Service & Demand Management IP Services, Deutsche Telekom[/vc_column_text][/vc_column_inner][/vc_row_inner][/vc_column][vc_column offset="vc_col-lg-4 vc_col-md-4" el_class="reference-mobile-order-3"][vc_row_inner el_class="reference-detail-right-sidebar-one-heading"][vc_column_inner][vc_custom_heading text="THESE SUCCESS STORIES MIGHT ALSO INTEREST YOU:" font_container="tag:h6|text_align:left|color:%23193d66" use_theme_fonts="yes"][/vc_column_inner][/vc_row_inner][vc_row_inner el_class="background-color-grey reference-detail-right-sidebar-two"][vc_column_inner][tiq_reference_link_box tiq_reference_link="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fsucces-stories%2Fintelligent-controlling-with-qlikview%2F|title:Intelligent%20Controlling%20with%20QlikView%C2%AE%20at%20the%20Karosseriewerke%20Dresden||"][tiq_reference_link_box tiq_reference_link="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fsucces-stories%2Fstate-analysis-platform-for-the-bi-support-of-an-automobile-manufacturer%2F|title:State%20Analysis%20Platform%20for%20the%20BI%20Support%20of%20an%20Automobile%20Manufacturer%20in%20Cooperation%20with%20T-Systems||"][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row el_class="container"][vc_column][tiq_start_service_boxes start_service_box_1_image="413" start_service_box_2_image="412" start_service_box_3_image="410" start_service_box_4_image="414" start_service_box_5_image="415" start_service_convert_as_slider="true" start_service_title="You might also be interested in these services" start_service_box_1_url="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fservices%2Fconsultancy%2F|title:Consultancy||" start_service_box_2_url="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fservices%2Fbusiness-intelligence%2F|title:Business%20Intelligence%20Solutions||" start_service_box_2_title="Business Intelligence" start_service_box_3_url="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fservices%2Fadvanced-analytics%2F|title:Advanced%20Analytics||" start_service_box_3_title="Advanced Analytics" start_service_box_4_url="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fservices%2Fgraph-data%2F|title:graph%20Data||" start_service_box_4_title="Graph Data" start_service_box_5_url="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fservices%2Ftraining%2F|title:Training||" start_service_box_5_title="Training" start_service_box_6_url="|||" start_service_box_1_title="Consultancy"][/vc_column][/vc_row] ...