Download PDF
Fivetran > Case Studies > Code2College Employs IoT to Enhance Student Learning Experience
Fivetran Logo

Code2College Employs IoT to Enhance Student Learning Experience

Technology Category
  • Functional Applications - Warehouse Management Systems (WMS)
  • Infrastructure as a Service (IaaS) - Virtual Private Cloud
Applicable Industries
  • Education
  • Transportation
Applicable Functions
  • Product Research & Development
  • Warehouse & Inventory Management
Use Cases
  • Picking, Sorting & Positioning
  • Public Transportation Management
Services
  • Cloud Planning, Design & Implementation Services
  • Training
The Challenge
Code2College, a nonprofit organization aimed at helping minority and low-income students achieve tech/STEM careers, was facing challenges in managing and analyzing student data. The organization's data, including student attendance, grades, and teacher input, was kept in spreadsheets or gathered by word of mouth. This approach was inefficient and time-consuming, especially when specific data on a student's performance or an overall view of the student population was required. The organization used Salesforce for operations and Canvas as a learning management tool. However, extracting information from these platforms to answer a single question would require a day's work, which was untenable given the small size of the data team. The team wanted to centralize their data using Google's BigQuery data warehouse tool to streamline retrieval and expedite responses to student needs. However, the challenge was how to transfer data from platforms like Salesforce and Canvas into BigQuery.
About The Customer
Code2College is a nonprofit organization based in Austin, Texas, founded in 2016 by a group of volunteers. The organization's mission is to expose low-income and minority students to the tech industry and create a pipeline from previously untapped talent. To date, Code2College has served more than 2,000 students, placed more than 250 students in tech internships, and helped more than 250 of its alumni get into college. The organization uses Salesforce for operations and Canvas as a learning management tool. It also conducts student surveys and stores them in Google Drive. The organization's leadership recognized early on that data would be central to their mission, and they have been proactive in seeking out efficient and cost-effective solutions to manage and analyze their data.
The Solution
The solution came in the form of Fivetran, an ELT (Extract, Load, Transform) tool that Code2College implemented to efficiently transfer data from Salesforce, Canvas, and Google Drive. The organization chose Fivetran after a rigorous process of trial and error with various tools. Fivetran stood out due to its ease of setup, fast syncs, and well-modeled data. The tool now enables regular, automatic data retrievals, keeping the data fresh and actionable. It has also dramatically accelerated response time from the data team and provided self-service capabilities for faculty members. Furthermore, Fivetran's Free Plan offered cost savings for the organization. The tool's efficiency in resource usage was particularly beneficial for Code2College as a nonprofit. Another significant advantage was the ability to move direct feedback from students into the organization's data warehouse, enabling quicker analysis of student experiences.
Operational Impact
  • The implementation of Fivetran has brought about significant operational improvements for Code2College. The tool has not only streamlined the data retrieval process but also enhanced the trustworthiness of the data. Teachers can now obtain information quickly and trust the data's accuracy, which is crucial for understanding each student's performance and tailoring the curriculum accordingly. The data team's ability to move direct feedback from students into the organization's data warehouse has also been a significant benefit. This capability allows the organization to quickly analyze what students are saying about their own experience, providing valuable insights that can be used to improve the learning environment. Looking ahead, Code2College plans to increase the integration of student feedback with student data from Salesforce and Canvas, which is expected to provide even more valuable context and insights.
Quantitative Benefit
  • Code2College has served more than 2,000 students, placed more than 250 students in tech internships, and helped more than 250 of its alumni get into college.
  • Fivetran's Free Plan offered cost savings for the organization.
  • Fivetran enables regular, automatic data retrievals, keeping the data fresh and actionable.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.