Business Intelligence: more autonomy for Antara customers!

  • 2019/06/28
Business Intelligence: more autonomy for Antara customers!

For more than 80 years of history, Riba Guixà Spanish Tanner has been able to maintain the necessary quality standard in its products, thanks to a rigorous selection of the origin of the skins used, as well as the modernization of processes and facilities, which allowed a privileged position within the world of leather fashion in Europe, Asia and USA.

The fifth generation is already being prepared. Aleix Riba Baños has been visiting SystemHaus for 3 weeks, where he had the opportunity to meet our team and conduct a training. This training has broadened the knowledge of the client regarding the Antara database with the objective that they can generate their managerial analysis through the online access to the Antara database.

Getting to know Antara deeply and preparing data is the first step towards achieving this goal. In addition, appropriate techniques and tools must be used to ensure the integrity of the data. Before the construction of the BI vision, it is necessary to collect, process and analyze the data, transforming this amount of data into useful information and can really support management and decision making.

In Aleix`s opinion for building an efficient view of BI it is necessary to know beyond the business and the data structure of Antara, also the SQL (Structured Query Language) and the language of communication of database. He comments that knowing the SQL BI tool becomes something very easy to use.

Aleix also commented that:

"Training to learn how to extract data from Antara is essential. Knowing the database well is fundamental to working in BI`s. With the training I`ve received, you`ll be able to know the easy ways and ways to extract Antara data to build BI.”

Antara gathers data from tannery processes and BI collects, stores, organizes and treats these indicators. Aleix reports that by making important information available through dynamic and intuitive reports and graphs, it is possible to simplify the day-to-day business of the company by facilitating analysis and decision making. Through the tool it is possible to obtain the facility in the access and the crossing of data, mobility and, of course, much efficiency in the offered results.

Aleix concludes that after the training obtained, he will be able to work independently:

"I learned a lot, very constructive; I did not expect to learn all these. I understood a different logic in the subject of extracting and analyzing the data. I did not expect to change that design and it`s very good because it`s the basis for making efficient queries. In addition to this I learned that not only topics that I can apply in Riba but in other areas of work and that is great, I exceeded my expectations."

During these weeks of work some visions of BI were developed, but in Aleix`s opinion, the most important was training in knowing the Antara base, extracting data and developing queries so that it can now proceed independently by extracting data and generating their own visions of BI.

SystemHaus is a specialist in the leather market and dedicated to understanding the management and operational needs of tanneries of various sizes around the world. We have great appreciation for the results our customers obtain daily through Antara.

Since 2017, we are performing Business Intelligence projects in more than 15 tanneries and we are honored to know that in addition to user-friendly tool, our customers, where we develop this work, are satisfied with the results.


                                                                               Aleix Riba Baños and Dulce Debus

CSCB Tannery Fairs birthday Tannerie Chennai Nationality BI software for tannery Tanneries Brazil Sustainability customer ALL CHINA LEATHER EXHIBITION LINEAPELLE Award Business Intelligence Software #systemhaus SystemHaus

Related Posts

A. Bühler: 74 years of success
A. Bühler: 74 years of success

In 1945, Arminio Bühler, along with few partners, started a new company to tan and sell leather.Enterprise that went through decades with a lot of wo...

READ MORE
With the word our first international customer: LEFARC tannery
With the word our first international customer: LEFARC tannery

During Fimec fair in Brazil 2020, we received in our headquarters a visit of Mr. Luis Ernesto Collazo, CEO of our first international customer, LEFARC...

READ MORE

Eventos

0,02ms - Debug é instanciado.
0,03ms - Classe 'Erro' é instanciada.
0,03ms - Definindo configurações do aplicativo.
0,08ms - Classe 'Carregar' é instanciada.
0,11ms - Instanciada as constantes.
0,16ms - Classe 'Config' é instanciada.
0,23ms - Classe 'Arquivo' é instanciada.
0,24ms - Classe 'Criptografia' é instanciada.
0,25ms - Classe 'Entrada' é instanciada.
0,29ms - Classe 'DB' é instanciada.
0,32ms - Classe 'Mysql' é instanciada.
0,34ms - Iniciando carregamento do aplicativo.
0,38ms - Classe 'Rota' é instanciada.
0,78ms - Rota "/:sigla/lgpd/aceitar" sendo sobrescrita para o método "LgpdControle::aceitar"
0,79ms - Rota "/:sigla/lgpd/quadro" sendo sobrescrita para o método "LgpdControle::quadro"
0,79ms - Rota "/:sigla/lgpd/quadrodetalhado" sendo sobrescrita para o método "LgpdControle::quadroDetalhado"
0,79ms - Rota "/:sigla/lgpd/privacidade" sendo sobrescrita para o método "LgpdControle::pagina"
0,85ms - Classe 'Controle' é instanciada.
0,88ms - Classe 'Seo' é instanciada.
1,10ms - 2,57ms = [Tempo: 1,47ms] - Conexão com o banco 'localhost:sist8023_systemhaus'.
0,86ms - 4,05ms = [Tempo: 3,19ms] - Tempo para incluir o arquivo _Comum.php.
4,08ms - Classe 'BlogControle' é instanciada.
12,32ms - 18,20ms = [Tempo: 5,88ms] - Renderizando a página 'site/visual/html/modeloPadrao.php'.
4,08ms - 18,21ms = [Tempo: 14,13ms] - Metodo 'BlogControle::interna()' é executado.
18,22ms - Debug::mostrarDebug();


Sqls

2,59ms - 2,95ms = [Tempo: 0,36ms] - SELECT id FROM site_idioma WHERE 1=1 AND sigla = 'en'
2,99ms - 3,64ms = [Tempo: 0,66ms] - SELECT ttexto.identificador,tidioma.texto FROM site_textoestatico ttexto INNER JOIN site_textoestatico_idioma tidioma ON (ttexto.id=tidioma.id_textoestatico) WHERE tidioma.id_idioma=02
3,77ms - 4,00ms = [Tempo: 0,24ms] - SELECT * FROM site_configuracao WHERE id_idioma = 02
4,23ms - 4,68ms = [Tempo: 0,45ms] - SELECT tidioma.* FROM site_seo tseo INNER JOIN site_seo_idioma tidioma ON (tseo.id=tidioma.id_seo) WHERE tseo.pagina = 'blog' AND tidioma.id_idioma = 02
5,01ms - 6,14ms = [Tempo: 1,13ms] - SELECT COUNT(1) AS total FROM site_blogpost blog INNER JOIN site_blogcategoria categoria ON blog.id_blogcategoria=categoria.id WHERE blog.ativo=1 AND DATE(blog.data) <= NOW() AND blog.id_idioma = 02 AND categoria.ativo=01 ORDER BY data DESC
6,19ms - 6,85ms = [Tempo: 0,66ms] - SELECT blog.id, blog.titulo,blog.descricao, blog.data, blog.datadescritiva, blog.id_blogcategoria FROM site_blogpost blog INNER JOIN site_blogcategoria categoria ON blog.id_blogcategoria=categoria.id WHERE blog.ativo=1 AND DATE(blog.data) <= NOW() AND blog.id_idioma = 02 AND categoria.ativo=01 ORDER BY data DESC LIMIT 0,4
7,33ms - 7,69ms = [Tempo: 0,36ms] - UPDATE site_blogpost SET acesso = acesso+1 WHERE id = 021
7,73ms - 8,04ms = [Tempo: 0,31ms] - SELECT blog.id,blog.titulo,blog.descricao,blog.data, blog.datadescritiva,blog.id_blogcategoria,blog.seopalavrachave,blog.seodescricao,blog.tag FROM site_blogpost blog INNER JOIN site_blogcategoria categoria ON blog.id_blogcategoria=categoria.id WHERE blog.ativo=1 AND DATE(blog.data) <= NOW() AND blog.id_idioma = 02 AND blog.id=021
8,10ms - 9,84ms = [Tempo: 1,73ms] - SELECT DISTINCT ttag.tag, ttag.tagformatada FROM site_blogposttag ttag INNER JOIN site_blogpost tblog ON(tblog.id=ttag.id_blogpost) WHERE tblog.ativo = 1 AND ttag.id_idioma = 02 ORDER BY RAND() LIMIT 20
10,06ms - 10,35ms = [Tempo: 0,30ms] - SELECT id, nome FROM site_blogcategoria WHERE ativo = 1 AND id_idioma = 02 ORDER BY nome ASC
10,56ms - 11,10ms = [Tempo: 0,54ms] - SELECT COUNT(1) AS total FROM site_blogpost blog INNER JOIN site_blogcategoria categoria ON blog.id_blogcategoria=categoria.id WHERE blog.ativo=1 AND DATE(blog.data) <= NOW() AND blog.id_idioma = 02 AND blog.id_blogcategoria=022 AND blog.id NOT IN (21) AND categoria.ativo=01 ORDER BY RAND()
11,11ms - 12,18ms = [Tempo: 1,07ms] - SELECT blog.id, blog.titulo,blog.descricao, blog.data, blog.datadescritiva, blog.id_blogcategoria FROM site_blogpost blog INNER JOIN site_blogcategoria categoria ON blog.id_blogcategoria=categoria.id WHERE blog.ativo=1 AND DATE(blog.data) <= NOW() AND blog.id_idioma = 02 AND blog.id_blogcategoria=022 AND blog.id NOT IN (21) AND categoria.ativo=01 ORDER BY RAND() LIMIT 0,3
12,55ms - 13,22ms = [Tempo: 0,67ms] - SELECT * FROM site_menu WHERE ativo = 1 AND id_idioma = 02 ORDER BY id_menu ASC,ordem ASC
14,40ms - 14,72ms = [Tempo: 0,31ms] - SELECT * FROM site_menu WHERE ativo = 1 AND id_idioma = 02 AND link LIKE 'antara/%' ORDER BY id_menu ASC,ordem ASC
14,76ms - 14,96ms = [Tempo: 0,20ms] - SELECT id,sigla,nome FROM site_idioma WHERE 1=1 AND ativo = 1 ORDER BY ordem ASC,nome ASC
14,98ms - 15,96ms = [Tempo: 0,98ms] - SELECT tendereco.id,tendidioma.nome,tendidioma.descricao FROM site_endereco tendereco INNER JOIN site_endereco_idioma tendidioma ON (tendereco.id=tendidioma.id_endereco) WHERE tendereco.ativo = 1 AND tendidioma.id_idioma = 02 AND (tendidioma.nome IS NULL OR tendidioma.nome <> '') AND (tendidioma.descricao IS NULL OR tendidioma.descricao <> '') ORDER BY tendereco.ordem ASC,tendidioma.nome ASC
16,13ms - 16,50ms = [Tempo: 0,37ms] - SELECT id FROM site_imagem WHERE id_idioma = 02
17,38ms - 17,85ms = [Tempo: 0,46ms] - SELECT nome FROM lgpd_conteudo WHERE id_idioma = 2