Rezka’s Italian Classes

At a Glance

Industry: Education

Location: Slovenia

Organization: 1 employee

Challenge:

• Manual research data extraction from 2 years of email communications was time-consuming and error-prone
• Risk of compromising data integrity

Solution: Comprehensive automation for email data extraction, processing, and visualization

Results:

• Research data extracted and processed in less than 1 hour
• 85 hours of manual data processing saved
• 100% elimination of human error
• Centralized research data for easy access and analysis

Customer Background

Rezka’s Italian Classes is a Slovenia-based company providing resources for teachers teaching Italian classes. The founder, also a university professor and academic researcher at the University of Ljubljana, teaches Italian literature, grammar, and didactics.

Problem

The founder of Rezka’s Italian Classes needed to review two years of email correspondence to extract key data from emails sent by her students. Key tasks included identifying the language of each message, recording, and processing critical email data, such as the main topic of the email and grammatical errors. This manual process was extremely time-consuming, taking over 2 hours to review just 25 emails, with nearly 1000 emails requiring evaluation. The estimated total time for this review was 85 hours. Manual processing also posed a high risk of errors, including duplicate entries, omissions, and the need for rework, which could compromise the integrity of the research data.

Solution

Our solution enabled Rezka’s Italian Classes to streamline and speed up the research data processing and eliminate any possibility of human error. We developed an automation that seamlessly sifted through extensive Outlook email archives in less than 30 minutes, extracting nearly 1000 potential candidates, mapping them and their key metadata to Google Sheets, and cleaning up the data to extract only emails relevant to the study (502 emails). The automated and AI-driven solution autonomously identified the language and topic of each email, directly addressing key research parameters and eliminating any margin for error. Using Google Sheets' native functionalities, we designed three pivot tables for Rezka, summarizing key research information, allowing them to visualize it easily.

Results

The results of the were transformative, unlocking a new level of efficiency and precision in academic research. Our solution saved Rezka approximately 85 hours of manual data review and processing, dramatically accelerating the research process. The automation guaranteed flawless extraction and processing of research data, eradicating the risk of errors, duplicates, or omissions. By centralizing all key research data in Google Sheets, we’ve allowed our client to easily access, analyze, and visualize data in a single well-organized location, optimized for data comparison and analysis.

Conclusion

Rezka’s Italian Classes has achieved a remarkable transformation in academic research efficiency through our tailored automation solution. By automating the extraction, processing, and visualization of research data from over 1000 emails in under an hour, we not only saved approximately 85 hours of manual effort but also ensured 100% accuracy and integrity in data handling. This streamlined approach has empowered Rezka to focus more on research analysis rather than data processing, significantly accelerating their research timelines.

If you are looking for creative solutions to grow your company and streamline your operations with custom apps and automation just like Rezka’s Italian Classes, schedule a discovery call with us.