TCD Training: Data Studio. Real application from Politeknika Ikastegia TXORIERRI in a multinational company

DCT Data Studio - Txorierri2


Within the TCD program, Technological Competence Development, during the first quarter of this academic year and over 3 sessions we have carried out the Data Studio training. First of all we have worked on its basic concepts, then we have applied them in a practical way in the training centers themselves within the FCT area, and finally, we have emphasized how to offer it in collaborative projects with companies.


Data Studio is a free tool that turns databases into visual reports through clear dashboards or dashboards, fully customizable and easy to consult and share.




Today we interview Begoña Villanueva, who is a member of the TKgune team of Politeknika Ikastegia TXORIERRI, and who thanks to the training received has developed a collaborative project in a company in the metallurgical sector.


Begoña Villanueva (right) with the representative of the company MOLYCOP, in a working meeting where they have laid the foundations to apply the DATA ANALYSIS in the company.



Role of coordination


– Tell us about your professional activity at the center and your relationship as a coordinator/member of the TKgune team.

– I have only been part of the TKgune team for a year, so I participate as much as I can in different collaboration projects with the companies in the environment. On the other hand, I also manage training courses for employment.


TCD Training


– Did you know the DATA STUDIO application before the training?

– No, I didn’t.
– How have you been able to receive this training?

– The management of the center gave me the opportunity to train and I signed up for the DCT – Data Studio training organized by Tknika for the members of the TKgune network. In addition, the management had been thinking about starting to work with data analysis programs for some time, so it was very good for us.
– What difficulties and advantages have you experienced in training?

– The main difficulty lies in thinking about how to apply the knowledge acquired with this new tool in companies from different sectors, since each of them handles specific information in their databases, so it must be studied in a very personalized way.

On the other hand, you have to convince them of its usefulness by being able to draw very valuable conclusions by analyzing only the databases available to the company, showing them the attractiveness of being able to achieve a plus in their productivity.

Among the advantages that this training brings me, I would cite discovering new applications unknown to me, being able to start quickly and practically to handle them, and showing me a new branch or way to continue working by opening new opportunities for my professional development.

– Have you managed to make this type of TKgune in any company?

– Yes. We offered this collaboration to the occupational risk prevention department of an American multinational company, which has a delegation in the Basque Country, and which is called MOLYCOP, and whose activity is forging, stamping, sausage, die-cutting, cutting and repulsing.




In this delegation located in the industrial estate of Abra, in the municipality of Abanto-Zierbena, occupational accidents occur and to register, evaluate and prevent them, the PRLs department submits monthly reports to the parent company with all the data collected.

The advantage that is achieved by implementing this type of solutions is that the reports they have to send are automatically generated from the information they enter daily through the forms that feed their databases.

– Did you have detected this type of needs for use, exploitation of data in the companies of the environment?

– Before doing the training we do not think about it. Firstly because of our ignorance of the existence of these programs along with their possibilities, and secondly because we are not aware of this type of need from companies.

Now, on the other hand, it seems to us an innovative resource in such a way that once a study of the specific needs of each sector has been carried out, it facilitates the analysis of large amounts of data in order to make relevant decisions in companies.


– Does it compensate for the energy spent on training compared to what it can offer you?

– Of course. Any new knowledge that makes it possible to offer an improvement in the daily functioning of the company is always worth it. The training received was an introductory first step to this world of data analysis, and I consider it necessary to continue learning and deepening in it to fully exploit its possibilities.



Project development


The fields of databases have been studied in detail with the company, and a series of indicators that add value to the company have been defined. With all this, a series of dashboards have been designed that show these indicators of the Occupational Risk Prevention area in a visual way, easy to understand and value.


EXAMPLES of Panels:


Dashboard 1:  INJURIES


This first board shows the different injuries that occur throughout the month and are updated daily. They are categorized by type: burn, projection, inflammation, lumbago, entrapment, blow and fracture and by location: head, ear / eyes, face, neck, back, arms, hands, feet and legs.

The objective of this panel is twofold:

First of all, inform workers through screens located in the company of the current situation of the accidents that have occurred, so it is a means of raising awareness as to the adoption of the appropriate safety measures.

On the other hand, at the end of the month the total calculation of incidents is recorded and a detailed report is sent to the parent company.


Dashboard 2:  ACCIDENT RATES


To systematically analyze the problem of occupational risks, the company manages a series of indicators or indices related to occupational accidents, among which are:

    • Incidence

    • Frequencies

    • Average duration

    • Gravity

Thus, this board shows several indexes simultaneously, and compares them between the years 2020 and 2021 on a monthly scale by drawing them on the same graph.




The last chart shown summarizes the value of the annual TRIF index that has been reached in the years 2020 and 2021.

This value combines several independent indicators into one by means of an appropriate weighting, and provides an overall reference of the accident rate in the company.

These values are referenced with the maximum limit or annual objective of the company previously established and that appears on the right.

In the graphs below, the left shows its monthly evolution and the right indicates the annual absolute values.
There is a noticeable improvement in its evolution between 2020 and 2021.


Other Dashboards used in the project: