HR Data Analysis Automation

The Okanagan Good Food Company is seeking to streamline its Human Resources data management by automating data extraction and analysis using Excel programming. The current manual process is time-consuming and prone to errors, impacting the efficiency of HR operations. The goal of this project is to develop an Excel-based solution that automates the pulling and processing of HR data, enabling quicker and more accurate insights into employee metrics, attendance, and performance. This project will provide learners with the opportunity to apply their knowledge of Excel programming, data analysis, and automation techniques. The tasks involved include understanding the existing data structure, designing an automated data extraction process, and creating user-friendly dashboards for data visualization. The project is designed to be completed by a team of learners from a business or computer science program, focusing on practical application of Excel skills in a real-world business context.

Meeting Management System Implementation

The Okanagan Good Food Company seeks to enhance its organizational efficiency by establishing a structured meeting management system following the EOS Traction Structure. The goal is to create a streamlined process for scheduling, conducting, and documenting weekly, monthly, quarterly, and annual meetings. This project will allow learners to apply their knowledge of organizational behaviour, communication, and project management. By developing a comprehensive meeting framework, the company aims to improve collaboration, ensure timely decision-making, and maintain consistent communication across all levels. The project will involve researching best practices, designing templates, and implementing tools that facilitate effective meeting management. Learners will focus on creating a user-friendly system that aligns with the company's operational needs and culture.

Meeting System Implementation for Okanagan Good Food Company

The Okanagan Good Food Company is seeking to enhance its internal communication and strategic planning by implementing structured meeting systems based on the Traction EOS Model. The goal is to assist the Chief of Staff in establishing efficient and effective systems for conducting weekly, monthly, quarterly, and annual general meetings. This project will allow learners to apply their organizational and strategic planning skills, gained from their academic program, to a real-world business setting. The project involves understanding the Traction EOS Model, analyzing current meeting practices, and designing a streamlined process that aligns with the company's objectives. The learners will work closely with the Chief of Staff to ensure the new systems are practical and sustainable, ultimately improving the company's operational efficiency and strategic alignment.

Lease Renewal Management System Development

The McMurray Group is seeking to enhance its lease management process by developing a comprehensive lease renewal tracking system using SharePoint and Power Automate. The current challenge involves managing over 50 property leases, which are currently tracked manually, leading to inefficiencies and potential oversights in renewal dates. The project aims to digitize old lease documents, create a centralized data sheet for all properties, and implement automated workflows to streamline lease management. By automating renewal notifications and document management, the system will ensure timely alerts for management, provide easy access to lease documents, and improve overall efficiency in handling lease renewals. This project offers learners an opportunity to apply their knowledge of SharePoint and Power Automate in a real-world scenario, enhancing their skills in digital transformation and process automation.