Success stories
Read some of the successful examples that have been created during the previous seasons of Demola Latvia
The Team teachable
Maxima Latvia
Graphical user interfaces (GUIs)
Challenge:
In order to ensure the availability of a full range of products on stores shelves, the daily processing and analysis of large amounts of initial data need to be carried out. It is necessary to develop a "user-friendly" data processing tool to perform this work effectively.
Solution:
A new user interface (GUI) was developed for the file in which MAXIMA employees perform data analysis, and it was automated. VBA code was created that updates the data in an excel file without user assistance, as well as new panels / pages were created that summarized previously scattered information and presented in a more attractive and interactive way.
Ventspils Nafta Termināls
A tool for preventive forecasting of the spread of petroleum product odors
Challenge:
VNT terminal handles and stores petroleum products. Some of the products are with a distinctive smell due to high content of benzene, H2S, mercaptan and other substances, thus their smell can spread to surrounding areas. The task given to students was to develop a tool that would help to forecast possible concentration of emission cloud and its direction. The company would like to perform necessary handling and storing of petroleum products when according to weather forecast the smell is not spreading to populated places.
Solution:
A WEB application was created that displays real-time weather conditions in the VNT territory. It is possible to enter the intended action and see how the odor cloud will spread by performing the specific action at that time.
Entrepreneur Oskars Priede
Don't live single
Challenge:
This DEMOLA challenge was set by entrepreneur Oskars Priede. Oskars is one of the most recognizable presentation skills coaches in Latvia, who consults companies and individuals on a daily basis about creating influential and effective presentations and public speaking. According to him, a significant proportion of the population aged 30+ lives in solitude, although this is contrary to their life goals and aspirations. These people want a life partner. Some have tried dating platforms but find them ineffective. The task of the students was to study the market and create a prototype of the dating platform at the minimum product level.
Solution:
The Zephir brand, website, and mobile application were created as a new dating solution, and the advertising campaign attracted about 100 people willing to use this solution.
T2T
Stay With Us
Challenge:
In a big company with increasing employee rotation, long hiring processes and a lack of face-to-face contact, it is impossible to predict when an employee chooses to change a job. How might such events be predicted in order to proactively retain existing employees in the company?
Solution:
The student team developed interviews for different levels, as well as created two-stage employee evaluation questionnaires for new and existing employees with coefficients to anticipate and identify the specific situation and areas for improvement.
Conexus Baltic Grid
Gas consumption forecasting case in Latvia
Challenge:
Gas consumption is influenced by a variety of factors (outdoor temperature, gas consumption structure, entry-point ratio, etc.). From what the planned gas consumption will be in the near future, it is possible to calculate the day-to-day adequacy of gas sources. The method utilized by the company provided insufficient precision on forecasted demand for natural gas in Latvia for the next 14 days.
Solution:
Opportunities, situations, and influencing factors were studied. A unique excel file for gas consumption forecasting was developed.
JSC Fertilizer Group
Tree Ash Fertilizer development and granulation
Challenge:
The task of the student team was to create a new product - organic mineral fertilizer, which is based on tree ash.
Solution:
A tool was developed to calculate the mass of fertilizer ingredients and additives, as well as the cost of fertilizers, taking into account the desired proportions of chemical elements for different plants, raw material prices, EU-regulated restrictions on heavy metals in fertilizers and obtaining the best raw material ratio.