Category: Success Stories

Graph analysis and dashboards to conflicts in the Congo for the UN

[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:https%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fsuccess-stories%2F|title:Success%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="8723" 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 Qlik Hackathon 2017 focused on the development of insights and tools for the UN to support their peacekeeping work in the Democratic Republic of Congo. The team of TIQ Solutions developed an application in cooperation with Akquinet to visualize and predict complex relationships between actors in the Republic of Congo. The tools developed included: Dashboards to visualize and explore the relationship and dependence of the main conflict dimensions. Graph analysis to explore the relationships between actors (alliances) during events in the Democratic Republic of Congo and neighbouring countries and how these evolve over time. Conflict prediction system for predicting events [/vc_column_text][/vc_tta_section][vc_tta_section title="The Solution" tab_id="1508250369051-4a626d72-344d"][vc_column_text] Dashboard to visualize and explore the relation and dependency of the main conflict dimensions Graph Analysis to explore relations between actors (alliances) during events in DRC and neighboring countries and how these evolve over time. Prediction of Conflicts to predicting the number of fatalities [/vc_column_text][/vc_tta_section][vc_tta_section title="The Result" tab_id="1508252697978-ef0a40d1-ea09"][vc_column_text] Categorization of conflicts affecting the population Determination of the parties involved and their relations with each other Early warning system for the prevention of violent escalations More information about the project can be found here.[/vc_column_text][/vc_tta_section][/vc_tta_accordion][vc_row_inner el_class="reference-detail-right-sidebar-one-heading"][vc_column_inner][vc_custom_heading text="Grafics to success story" font_container="tag:h3|text_align:left|color:%23193d66" use_theme_fonts="yes"][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner offset="vc_col-lg-3"][vc_single_image image="8760" onclick="link_image"][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_column_text]Conflict Dashboard showing DRC Events in 2014[/vc_column_text][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_single_image image="8828" onclick="link_image"][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_column_text]Graph analysis of Actor Alliances in 2014 (left side the year before, right side the year after).[/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-1"][vc_row_inner el_class="background-color-grey reference-detail-right-sidebar-one"][vc_column_inner][vc_column_text] PROJEKT INFORMATION Occasion Qlik Hackathon 2017 - Support for peacekeeping work in the Democratic Republic for the UN Use Case Development of an application for visualization and prediction of complex relationships of actors Technology Qlik Sense®, Qlik Extensions for Map, Ogma, Vizlib table, NPGeoMap, ACLED Dataset[/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:https%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fsuccess-stories%2Fbig-data-for-digital-television-and-telephony-at-deutsche-telekom%2F|title:Big%20data%20for%20digital%20television%20and%20telephony%20at%20Deutsche%20Telekom||"][tiq_reference_link_box tiq_reference_link="url:https%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fsuccess-stories%2Fpredictive-maintenance-in-car-body-manufacture%2F|title:Predictive%20maintenance%20in%20car%20body%20manufacture||"][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row] ...

Predictive maintenance in car body manufacture

[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="4122" 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 "Smart Factory" plays a major role in the future project Industry 4. 0. It describes the vision of self-organizing manufacturing facilities. Already today, robots are being used throughout the automotive industry. In the course of production, malfunctions occur time and again that lead to downtimes or even production stoppages. Unexpected and unnecessary additional costs and delivery delays are the result. Static maintenance at fixed intervals only helps to a limited extent and leads to further unnecessary downtimes and consumption of spare parts. Therefore, our customer was looking for a software solution to minimize future failures and time losses in its production for car bodies. This solution should analyze the behavior of the welding robots used as automatically as possible in order to be able to detect and predict faults at an early stage (predictive maintenance).[/vc_column_text][/vc_tta_section][vc_tta_section title="The Solution" tab_id="1508250369051-4a626d72-344d"][vc_column_text]Predictive maintenance is based on the analysis of historical plant data using statistical methods and advanced methods of machine learning. The mathematical models developed here are used to predict the future behavior of the system and help to identify critical plant conditions in good time. The basis was the creation of a temporally synchronous history of the status information and fault messages. Subsequently, the characteristic behavioral patterns of the individual production cycles of body manufacturing were identified and transferred to normalized states. Together with the department, practical misconduct was determined and the relevant production cycles examined for possible sources of error and dependencies. Using non-linear classification algorithms, the relationships between the behavior patterns and fault messages could be modeled within the production cycles. In the future, forecasts will be made regarding the probability of failure of individual devices and potential causes of failure will be investigated. The models were trained in a Hadoop cluster. Distributed processing with Spark will streamline and accelerate the analysis.[/vc_column_text][/vc_tta_section][vc_tta_section title="The Result" tab_id="1508252697978-ef0a40d1-ea09"][vc_column_text]A system has been developed to continuously analyze the behavior of industrial robots and connected components and to predict events in the future. Behavior models were used to create a kind of fingerprint for each robot. Based on prediction models make allow to determine the probability of failure of individual devices and production sections. The malfunctions predicted in this way are displayed to the customer. As a result, those responsible can intervene preventively even before a fault occurs. This not only avoids operational stoppages, but also reduces the consumption of wear and machine parts. This means that robot-based processes can be maintained in line with requirements and the causes of faults can be traced. This lowers production costs and leads to successive process optimization.[/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" 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="5672" img_size="165x165" onclick="link_image"][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_column_text]Time course of measured status information, which individually record the activity of a production system.[/vc_column_text][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_single_image image="5670" img_size="165x165"][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_column_text]Normalized representation of the pre-processed condition information, allows comparability of different production cycles.[/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-1"][vc_row_inner el_class="background-color-grey reference-detail-right-sidebar-one"][vc_column_inner][vc_column_text]Project Overview Customer Car manufacturer Case of applicatione Predictive maintenance for welding robots in body construction Tasks Synchronizing and harmonizing data over time Automatic recording of the behavior patterns for each robot Modelling the interrelataionships Forecasting of failures Aim Avoidance of downtimes Maintenance according to requirements Customer Benefits Maintenance intervals as required Reduction of downtimes Reduction in the consumption of spare parts Minimization of unplanned production losses Increased transparency of the technical connections Technology R, Python, Hive, Impala, Spark, Hadoop[/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%2Fsuccess-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||"][tiq_reference_link_box tiq_reference_link="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fsuccess-stories%2Fintelligent-controlling-with-qlikview%2F|title:Intelligent%20Controlling%20with%20QlikView%C2%AE%20at%20the%20Karosseriewerke%20Dresden||"][/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] ...

Big Data platform for the evaluation of streaming technologies

[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="4179" 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]With the advent of digitization into mobility, the car has become an information and communication platform. New challenges arise in data processing and data transmission, within the framework of this paradigm shift from driver to autopilot with the goal of fully automated and networked driving. The modern car collects information on location, speed, road users and traffic signs, among other things. In order to process this high volume of data and to play back analysis results in the car, an almost real-time system is necessary. Therefore, the technical solution space for such an analysis system should be evaluated and implemented in the project. The goal was to identify the most powerful stream processor and design a virtualizable environment that simplifies deployment of stream processors and optimizes their resource utilization in the Hadoop cluster.[/vc_column_text][/vc_tta_section][vc_tta_section title="The Solution" tab_id="1508250369051-4a626d72-344d"][vc_column_text]To identify the most suitable stream processor, a local environment was set up in the first step, which allows the different stream processors to be configured and scaled. The individual process steps of data processing were implemented as independent, reusable components. The advantage is that the stream processors can be used unchanged and thus remain comparable. Appropriate performance indicators (KPI) and user stories were defined as prerequisites for the evaluation. The KPIs refer to customer-specific requirements, such as latency, throughput or functionality in monitoring and the provision of streaming tasks. The user stories also cover the "soft skills" of the stream processors. The subsequent evaluation provided information on weak points and possibilities for optimizing data processing with the various stream processors and their individual components. In the next step, the developed proof-of-concept was established on the customer's own Hadoop cluster. TIQ Solutions implemented this on the basis of a virtualized environment using containers and an easily scalable big data architecture.[/vc_column_text][/vc_tta_section][vc_tta_section title="The Result" tab_id="1508252697978-ef0a40d1-ea09"][vc_column_text]A big data platform was provided to test and analyze stream processors. After completion of the evaluation, the customer received a concrete recommendation for the most suitable stream processor and the optimal configuration of the streaming data processing path. Our customer can now independently create and test data processing lines between his vehicles and the analysis system according to the application. In particular, it is possible to configure and scale the process steps with regard to validation, transformation and process flow (dispatching). By virtualizing the individual components with Docker, the user can easily create new test routes or copy and modify existing routes.[/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" 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="4181" img_size="165x165" onclick="link_image"][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_column_text]autonomous vehicles à Hadoop cluster and container environment à external services and analysis system[/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]Project Overview Customer German Car manufacturer Customer Objective Data processing of vehicle and traffic data Tasks Developing a big data platform Virtualizing the platform environment Comparing and evaluating the stream processors Aim Streaming route comparison and operation system Customer Benefits Independent creation and optimization of streaming routes Easy provisioning of streaming components by containers Scalability through big data architecture Optimal use of cluster resources Transparent evaluation of the efficiency of streaming Technology Spark, Samza, Storm, Docker, Kafka, Hadoop, HDFS, YARN, ZooKeeper[/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%2Fsuccess-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||"][tiq_reference_link_box tiq_reference_link="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fsuccess-stories%2Fintelligent-controlling-with-qlikview%2F|title:Intelligent%20Controlling%20with%20QlikView%C2%AE%20at%20the%20Karosseriewerke%20Dresden||"][/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] ...

Big Data for digital television and telephony at Deutsche Telekom

[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="4131" 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]Digitization is well advanced in communications services. Today, landline telephony, television and internet are being offered from a single source via the same network infrastructure (triple play). Sound, image and data are transmitted IP-based via data packets. Telekom Deutschland has a nationwide, complex communication network. As a result of digital progress, new technologies and hardware manufacturers are constantly being introduced into the existing network. In order to keep pace with this dynamic, Deutsche Telekom uses a software system to analyze the quality and availability of its services and to monitor the utilization of the network infrastructure. In addition, Deutsche Telekom also planned to further expand the scope and sound quality of its HD programs and the functionalities of its services. The resulting increase in data volume would no longer have been controllable for the existing analysis system. TIQ Solutions, as a long-term consultant for the existing solution, therefore recommended switching to a new big data system.[/vc_column_text][/vc_tta_section][vc_tta_section title="The Solution" tab_id="1508250369051-4a626d72-344d"][vc_column_text]The architecture of the new big data system and its technological implementation were developed in workshops lasting several days together with the IT and the specialist department. For the first time, big data's powerful processing mechanisms made it possible to separate the technical data model from technical barriers during loading. TIQ Solutions also specified the necessary applications, their rights and the routing between the nodes in the cluster and the external QlikView server providing the visualization. The Oracle database has been replaced by Hive. Here, TIQ Solutions developed a generator that creates the various Hive table objects including their attributes for the more than 30 heterogeneous data sources, thus generating the database semi-automatically. Data processing was implemented with the Oozie Workflow Scheduler and replaced Informatica. For the Hadoop cluster, a rights and roles concept based on Kerberos was then designed and implemented. The historical data was initially migrated to the Hadoop cluster. For the business users, the usual access to the raw data via SQL statements was established via the HUE web frontend hue. During the migration of the business intelligence application QlikView®, TIQ Solutions primarily advised on optimizing the loading logic.[/vc_column_text][/vc_tta_section][vc_tta_section title="The Result" tab_id="1508252697978-ef0a40d1-ea09"][vc_column_text]The existing classic, purely relational database system was successfully transferred to a big data system. The new options eliminate aggregations and filters for limiting data volumes. This greatly increased the resolution of the data (granularity), the scope of the history and the consistency of the observable periods. This gives Deutsche Telekom a more precise picture of the state of its network and the current quality of the IPTV and VoIP services offered (Quality of Service). The resulting long-term observations are now more comprehensive and help to detect creeping state changes. The distributed processing in the cluster has made it possible to increase the load of raw data during the day and gives the department a quicker overview of the current transaction data. The use of the Cloudera Hadoop distribution and the integrated applications for data integration and data retrieval provided a consistent system. The operating costs of the software solution and the hardware could thus be reduced many times over.[/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" 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="4134" img_size="165x165" onclick="link_image"][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_column_text]Migration of a relational database system (RDBMS) to a big data management and analysis system[/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]Project Overview Customer Telekom Deutschland GmbH / T-Systems International GmbH Case of application Migration of an analysis system for monitoring the image and sound quality of IPTV and VoIP on a big data platform Tasks Conception of the new system architecture Implementation of PoC Migration of business logic Migration of historical data Implementation of the security concept Aim Processing of large amounts of data More up-to-date, flexible and broadened view of the data Improved analysis possibilities on historical data Reduction of operating costs Generic processing processes More efficient data analysis Customer Benefits Reduce subscription costs Reduction of costs for data storage Improved informative value of the analyses Minimum expansion effort Efficiency for growing data volumes Technology Hadoop, Cloudera, Hive, HDFS, YARN, ZooKeeper, Oozie, Hue, Parquet, Kerberos, individual extensions with Java, Bash Scripting, Enterprise Architect, QlikView®[/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%2Fsuccess-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||"][tiq_reference_link_box tiq_reference_link="url:http%3A%2F%2Fwww.tiq-solutions.de%2Fen%2Fsuccess-stories%2Fintelligent-controlling-with-qlikview%2F|title:Intelligent%20Controlling%20with%20QlikView%C2%AE%20at%20the%20Karosseriewerke%20Dresden||"][/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] ...

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] ...

Intelligent Social Media Analysis at the Leipzig Tourismus und Marketing GmbH

[vc_row el_class="container"][vc_column][vc_btn title="Success 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="4149" 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]Social media is a quite important topic these days and is taking on even greater significance. It involves social networks as well as other data sources. Leipzig Tourismus und Marketing GmbH (LTM) is responsible for the tourism, location and local business marketing of the city of Leipzig and the surrounding region. Social media offers an enormous economic potential for the company, since it can draw attention to the city as well as to the region in an easy and inexpensive manner and can also promote it touristically and economically. Through Social Media, LTM can reach many of its multipliers and target audiences. However, it is a challenge to keep all the channels continuously in view. The complete acquisition of the actual dissemination of their corporate content on the web as well as customer and user interests goes with a lot of effort. Furthermore, trends might be easily missed due to the fast-moving nature of social media.[/vc_column_text][/vc_tta_section][vc_tta_section title="The Solution" tab_id="1508250369051-4a626d72-344d"][vc_column_text]According to the company’s needs, individually adapted social media solutions from TIQ Solutions are now being applied at Leipzig Tourismus und Marketing GmbH. Our “TIQ Social Observer”, which is based on QlikView® and QVSource, is performing a social media monitoring and analytics, in which the Facebook and Twitter accounts as well as the company’s YouTube channel are being analyzed. In this way the latest information about own activities and respective user responses are ensured. Operational evaluations, such as “When are users active” or “Which are my top posts” are being available through this application. Long-term analyses, such as the development of actions and reactions over time, are also included. Thus, the opinion about the company as well as respective key issues are noticeable. TIQ Solutions guarantees a solution constantly based on the customer’s needs through regular joint workshops with LTM. With the use of “TIQ Social Observer” thematic analyses of these platforms will be carried out from now on. In addition to statistical analyses, the opinion on a specific topic is being collected and edited. “GAparazzo”, a solution developed by TIQ Solutions, was also implemented. This analysis tool monitors the blog of LTM. Due to “GAparazzo” it is possible to evaluate hits on the blog and to analyse visitor trends of the page in that way. Through an integration of it with “TIQ Social Observer” interactions of the users with other channels are also  visible.[/vc_column_text][/vc_tta_section][vc_tta_section title="The Result" tab_id="1508252697978-ef0a40d1-ea09"][vc_column_text]The social media analysis and monitoring with „TIQ Social Observer“ and „GAparazzo“ provides an integrated overall view of the performance of its channels to LTM. The information they obtain that way, can now be used optimally on a temporal and textual level. As a result, LTM can create evaluations for customers, partners and investors with little effort and respond purposefully to trends and developments. With these applications, the company can determine the needs of the target audiences and then review and adjust its marketing efforts. Thanks to regular monitoring of the social media activities on the internet, critical issues can be quickly identified and be handled appropriately to avoid crises. Because of these applications, LTM is capable to analyze and evaluate their activities. Objectives can be checked and the success of their actions can be measured.[/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="Graphics" font_container="tag:h3|text_align:left" 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="4150" img_size="165x165" onclick="link_image"][/vc_column_inner][vc_column_inner offset="vc_col-lg-3"][vc_single_image image="4151" img_size="165x165" onclick="link_image"][/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]Project Overview   Customer Leipzig Tourismus und Marketing GmbH Customer Objective Overview of all corporate content on the web Our Solution Customized Social Media Solutions to analyze all platforms of LTM GmbH Technologie QlikView® Customer Benefits Overview of own activities and user reactions Long-term as well as thematic analysis Recognition of opinions Monitoring of visitor trends Fast compilation of reports "Through our cooperation with TIQ Solutions, we have found a competent partner, with whom we could develop a social media monitoring process, which is adjusted to our individual needs in tourism and city marketing, within a very short time." Jamina Jahnel,Social Media Manager, LTM[/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%2Fsuccess-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||"][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||"][/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] ...