平特五不中

Building a better business through data analytics

A Desautels Faculty of Management prof and students in the 平特五不中 Food Analytics Club are using data analytics to revolutionize the operations of Montreal food coop Santropol Roulant.

Call it providence. A medical issue forced Ali Dunn to drop a course last semester.

鈥淚n order to make up for the lost credits, my advisor recommended I pursue an independent study the following semester,鈥 said the 22-year-old who just graduated from the Desautels Faculty of Management鈥檚 marketing program, with a concentration in data analytics.

鈥淚鈥檇 taken one of Juan鈥檚 classes in the fall and absolutely loved it. I asked him if he鈥檇 be able to sponsor me for my independent study and he introduced me to this project!鈥

鈥淛uan鈥 is Juan Camilo Serpa, a professor at Desautels who teaches an introductory course on data analytics for business, and 鈥渢his project鈥 refers to a joint program developed with Santropol Roulant, a Montreal food security and services community group.

Serpa launched the 平特五不中 Food Analytics Club 鈥 McFac 鈥 18 months ago, in an attempt to use data analytics and AI 鈥 artificial intelligence 鈥 for social good.

鈥淏ig food companies have access to hundreds of thousands of dollars for big-time consultants to use data to make cheaper food,鈥 Serpa said. 鈥淏ut what about the small ethical farmers who grow organic sustainable food? They don鈥檛 have access to this data. That鈥檚 why you see organic foods that are so expensive whereas processed food is so cheap. Partly, this is because of better data analytics. So, the idea with this group was to use that knowledge to help sustainable food producers become more data driven, make better decisions to increase their efficiency and become more cost competitive.

鈥淪antropol is one of Montreal鈥檚 biggest coops centred on food, a very big program (that includes Meals on Wheels), so we really wanted to work with them,鈥 said Serpa.

Streamlining operations

Santropol was 鈥渧ery open-minded鈥 but dubious about how data analytics could help, either at their organic farm in Senneville or at their various Montreal operations.

The coop is heavily dependent on volunteers, whether for their agricultural program, for Meals on Wheels, in the kitchen or elsewhere, who sign up by paper or call in to a coordinator who signs them up by paper.

鈥淭hey have these big stacks of paper to process and decide which volunteer will work where exactly. It鈥檚 a very complicated system. So, we said 鈥榃hat if we try to build a detailed system where volunteers can sign up with an app we鈥檒l design and you automatically get a schedule that decides intelligently where to route the volunteers and that communicates with all your staff if you have to, say, cancel an agricultural program due to bad weather?鈥 It frees them up to be more efficient. That鈥檚 the transformation we began doing 鈥 creating this app that ultimately we hope to make into a very AI system to help them coordinate this program.鈥

Marie-Anne Viau, urban agriculture manager for Santropol Roulant, was effusive in her praise for the project and its creators.

鈥淵es, we were indeed a bit suspicious at first 鈥 we鈥檙e a big operation with many inter-connected programs, so it was very important that we maintain that core essence, that community spirit.

鈥淰olunteers are at the foundation of everything we do, and thanks to 平特五不中, we were able to improve further鈥 What was truly impressive was their ability to really understand us, who we are, what we do,鈥 said Viau.

鈥淚t was a gift for us.鈥

Building a digital database out of stacks of paper

One of Dunn鈥檚 jobs was converting the stacks of paper into digital files.

She and about 20 other Desautels students turned paper records and time-sheets into a digital database that now forms the core of the app 鈥 and eventually into a full-fledged AI system.

鈥淚 collected data about Santropol鈥檚 agricultural program,鈥 Dunn said, 鈥渁nd gave them information about how they could attract and retain more volunteers,鈥 cutting down on costly training of new recruits.

鈥淚 spotted some deficiencies and did a survey; I then put that info into an Excel file and ran some algorithms to decipher which variables have a greater influence on satisfaction.鈥

Viau said she was 鈥渧ery impressed with (Dunn鈥檚) report.鈥

Interestingly, Dunn found that there was a higher satisfaction rating among English-speaking volunteers than French-speaking ones. And volunteers with a background in education turned in a lower satisfaction rating. She recommended that Santropol hire more of the latter, whose exacting standards and expectations would propel the coop to greater heights.

Dunn also suggested hiring more students, who registered a higher level of satisfaction and return rate than the average. 鈥淧lus some courses at Concordia University and 平特五不中 require volunteer experience, so that works well.鈥

Another student, Anshul Manosha, created a mobile app that McFac will test over the summer to streamline Santropol's operation and 鈥渞evolutionize the way volunteers interact with staff and make volunteering more easily accessible.鈥

鈥淏ut as we know,鈥 Serpa noted, 鈥渁pps always start out with a ton of problems, bugs, etc.鈥

鈥淪o we have to create the perfect interface so that it鈥檚 easy for the volunteers at the front end and the staff at the back end. A ton of stuff is being planned.鈥

Viau said she 鈥渃an鈥檛 wait to see how the pilot project will fare this summer.鈥

鈥淚t鈥檚 great for students,鈥 said Serpa. 鈥淭hey learn how to make a business with technology, but at the same time keeping the core of the community spirit at its base.鈥

Back to top