Business & Economy

UGA students build custom data app for bus maker

When nationwide bus maker Blue Bird had a problem, it turned to students in the University of Georgia’s Terry College Master of Science in Business Analytics program for a solution.

The dilemma stemmed from their business model. Because each bus Blue Bird makes is built-to-order, and because schools tend to order buses only at certain times of year, many workers were left without much to do for months at a time. The rest of the year, they were slammed.

The company approached Terry’s MSBA program to ask for help finding a solution. The executives wanted to see if there was a way to unpack the complexities of bus design and find a “standard bus” that could be completed in the slow season and sold later.

A team of 11 MSBA students met with top executives as part of their degree’s capstone project.

“We realized pretty quickly that we didn’t have enough domain knowledge to say, ‘You should have one standard bus for every state or every region,’ so we had to do something else,” said project leader Courtney Weaver. “So what we did was to develop an online tool that allows them to better track their data and see it in a variety of ways.”

The Terry team compiled Blue Bird’s data into a dashboard they created. The customizable platform allows the bus maker to spot trends and identify common configurations, leading to improved efficiency.

“The dashboard lets you pull up information at the region and unit levels. For example, you can search for what options — like seat belts, windows or air brakes — are included in 75% of the buses. Then you can start to ask why it’s 75% and not 100%,” Weaver said. “Or you can look at state-level data, and see that every bus you build for a school district in Arkansas has these certain characteristics. Or you can see that if a bus has option A, there’s a 98% chance it will also include option C.”

The team drove down to Macon to present their dashboard to the company’s C-suite. And, if the chief financial officer’s reaction is any indication, it was a huge success.

“We were really impressed by the approach that was taken, by the clarity of thought and the overall presentation. We plan to use the approach and the tool that was developed to determine if there is really a ‘standard bus,’” said Phil Tighe, CFO of Blue Bird. “Our people at Blue Bird are very excited about this initiative.”

Not only did the project give Blue Bird a new way to make strategic decisions, it provided MSBA students with real-world consulting experience.

“My biggest takeaway is that data can be very ugly. I knew that before, but really getting into it and seeing the 33,000 rows of data — that was a lot to go through,” Weaver said. “I think we all learned a lot from really working with a client and learning how to communicate with them.”

The MSBA program is a one-year interdisciplinary course of study that develops technical expertise in collecting, analyzing and interpreting big data in a business context. It involves two semesters of study, during which students learn about the collection, storage, analysis, interpretation and visualization of data as well as the predominant programming languages in the field — SQL, R and Python. More information is available on the program’s website.