The Cerealto Siro Group aims to develop a first use case of advanced analytics, based on the analysis of absenteeism in its production centers, as the first concrete application of its Big Data strategy that will serve as a driver of a global strategy in this area.
To achieve this, a robust and scalable architecture will be defined to drive the Group's digital transformation and, more specifically, decision making based on data analysis.
Data integrating the project and architecture:
Data:
Job characterization data
Data on employees' transfer transactions
Contextual data by work center
Absenteeism historical data
Architecture:
Virtual machine in Azure cloud environment (Microsoft)
Postgresql DB
Power BI Visualization (Microsoft)
The determination of the variables that influence absenteeism is a process that has matured in different studies of classical industrial sociology. The aim of advanced analytics is to establish the main determining variables and the optimal way to reduce absenteeism with the minimum possible impact on operational processes and the work environment.
Methodologically, we initiated an RFM analysis that provides us with an initial classification of employees into different groups according to 3 variables:
The analysis of the Group's historical absence data allows us to distribute the entire employee base into a classification of 27 groups, according to the 3 variables analyzed, scoring employees with a value from 1 to 3 according to their frequency of absence, recency and amount.
As a complement to the RFM analysis, we will evaluate the weight of the different variables that characterize each employee in the practice of absenteeism. This diagnostic analysis assigns a weight to these variables so that the data and the algorithms applied to the data can detect patterns of common characteristics among the employees who practice absenteeism.
Prior to the development of the use case itself and according to Smartup's methodology in the development of projects in the field of Big Data, it will be necessary to undertake a series of common tasks as well as the definition and development of a scalable infrastructure that allows modeling and analysis for this first use case and beyond:
After the project, the Cerealto Siro Group has the capacity to develop strategies for the reduction of absenteeism from multiple internal actions, for which a tool for internal and external use is enabled through which it can transfer knowledge about this specific behavior over time.
Globally, with this initiative, the company is carrying out the necessary tasks to coordinate internally the path towards a data-driven company with which to manage the evolution of its production teams.
"*" indicates required fields
Get insights for your business from the data provided by advanced web analytics. Know your users' behavior, optimize strategies and make decisions for sustainable growth.
We help define the profiles of your ideal customers and understand their sharing patterns to achieve a more effective and personalized communication, generating stronger connections and more meaningful conversions.
Know how your brand is perceived online. We monitor conversations, opinions, trends and feedback on social networks and platforms to provide you with valuable information to adjust your strategies, improve your online reputation and boost your audience's engagement.
We design strategies in Google Ads, Bing Ads, Social Ads and Amazon ads based on the achievement of measurable results. We work from the constant optimization to obtain the ROAS that allows a tangible and quantifiable growth.
With more than 15 years of SEO experience, at Smartup we know the keys to grow your business through organic search engine optimization.
We create attractive and relevant content, manage your profiles and execute advertising campaigns aimed at increasing the interaction and visibility of your brand on key platforms for your business. What are you waiting for to boost your presence on social networks?
Mejoramos el conversion rate de tu negocio aplicando técnicas y tecnología user experience y A/B testing.
We generate personalized ads based on the user's behavior so that your brand remains in the TOP of Mind of your potential customer.
We apply lead nurturing and lead scoring strategies, through process automation, to improve the lifetime value of your business customers through micro-segmentation of email campaigns.
Properly managing customer relationships is essential. We help you keep an organized record of your customers' interactions and preferences allowing for effective and personalized communication, increasing customer satisfaction and strengthening loyalty.
We foster customer loyalty through an approach that encompasses the management of feedback, reviews and comments. We build trust and credibility, helping you maintain a positive online image.
Turn your customers into your own brand ambassadors through the implementation of effective member get member strategies.