PATHWAY CTM Data Warehouse

PathwayCTM help students navigate the world of apprenticeships and kickstart their career. With their unique blend of career events, personalized mentoring sessions, and top-quality resources, they provide tools that need to succeed. To achieve this pathwayctm has a wordpress website for regisrations, zoom for event meetings, zoho recurit for managing students. All these are different platforms. Their goal was to combine data from all these platforms to a single place where they can manage all details in one place for research, analysis and reporting. We were assigned to do this job to create single place which accumulates data from all other platform in real time and data always stay in sync.

Challange was to sync data in real time. Students / parents / teachers all register themselves in wordpress website. They also register for events via wordpress website. Event meetings are managed via zoom. So data related to event registrations and attendees stays with zoom. Pathway manage their students for apprenticeships and career growth in zoho recurit. Schools which pathway helps for the students for pre-employment program are getting managed in Zoho CRM. So we were in need to sync data from wordpress, zoom, zoho crm and zoho recruit at one place.

We understand the importance of having all data in one place for research, analysis, and reporting. Our dedicated team has worked tirelessly to create a seamless system that combines data from different platforms into a single place.

After doing analysis we decided build system in Laravel framework which will be accumulating data from all other sources, and new system is called Data Warehouse. Process we adapted, when student registers in wordpress site, we also create same student in zoho recurit using zapier integration. We impliment zoho api's which in turn on creating new student or updating / delete student, we update our data warehouse. This api's designed to work real time so student data in Data Warehouse always stay upto date at any point of time and this way one piece was in place. Other challange was to integrate ZOOM. When student registers for any event we sync that all info into our warehouse. Warehouse in turn using zoom api checks and get details about registrants and attendees of that event. So Data Warehouse now has all students data including their educational info, school info and info regrading events they attended, all in one place. Using this data pathway can now generate reports for events, schools, students etc on demand and use for their analysis.