Data Harmonization and Integration: Empowering Phare Counselling with an Automated Insights Dashboard
The high-level goal of this project is to successfully complete the data integration process for Jane, thus ensuring the successful functioning of the automated data dashboard. The deliverable will be a robust and dynamic data dashboard that consolidates data from both Freshsales and Jane, providing seamless updates for real-time insights. Addressing the existing challenge, students will collaborate with Phare Counselling's team, understanding the partial progress made in drawing data from Jane, and then help establish the missing connections. This will lead to a fully functional data dashboard that offers a comprehensive overview of key performance indicators (KPIs) with intuitive visualizations. The measure of accomplishment will be the successful presentation of data from Jane within the dashboard, alongside the existing data from Freshsales. The completed dashboard will allow stakeholders to monitor weekly metrics, revenue trends, conversion ratios, and client information for informed decision-making and continuous improvement. By addressing the data connection issue, this project will empower Phare Counselling to optimize operations, enhance service quality, and improve the overall client experience. Addressing content, the dashboard will encompass various visual representations of the data, such as charts, graphs, and tables, to aid in easy interpretation. The format will be an interactive web-based dashboard accessible through secure login credentials. The depth of the deliverable will encompass key operational and financial metrics to support strategic planning and decision-making. The successful completion of this project will be evident when Phare Counselling can efficiently draw and present data from both Freshsales and Jane in the automated dashboard, enabling data-driven insights for impactful improvements.
Phare - Marketing, Sales, Data Analysis
PROJECT DESCRIPTION/DESCRIPTION DU PROJET: Phare is a mental health startup in the digital health services space with a fifteen-counsellor team and eighty clients and growing. Our core product is a marketplace dedicated to an ideal fit between clients with counsellors. Our team has been serving paying clients in need of therapy for more than a year (since June 2020), during which our team has been testing, validating and invalidating hypotheses about its customers on both sides--clients and counsellors--of its marketplace. Our culture is one of wanting to make an impact around mental health, especially for students. If you join Phare, we want you to know that you will be bringing your whole being to working with us, not just the parts of you that are "relevant" on a list of bullet points on a job posting. We started Phare because we knew there was a huge need--and a huge demand--under COVID and the mental health effects that have been exacerbated until pandemic will have a ripple effect for a long time to come. So you and others who join us will be working on some of the greatest problems that inspired us to start Phare in the first place. HOW MANY STUDENT INTRAPRENEURS WILL THIS PROJECT ACCOMMODATE? 5 TIME COMMITMENT PER STUDENT/TEMPS DE TRAVAIL PAR ÉTUDIANT: 70 KEY PROJECT ACTIVITIES/TÂCHES ASSOCIÉES AU PROJET: Software Development User Experience/User Interface design Financial Modeling and Reporting Researching access to mental health resources on your campus Representing Phare on your campus as an ambassador for mental health Educating other students as to access to mental health services (including non-Phare options) IDEAL ROLES/RESPONSIBILITIES/RÔLES/RESPONSABILITÉS:* Software Development and Design Finance Marketing, Media, Sales Data Analysis, Operations FINAL PROJECT DELIVERABLES/LIVRABLES DU PROJET: Progress reports Prototypes, live demos (software development and design) Business reports (Finance) PROJECT MENTOR NAME/NOM DU MENTOR DU PROJET: Dr. Ray Hsu
Phare Mental Health - Administration, Financial Data Analysis, Social Media
PROJECT DESCRIPTION/DESCRIPTION DU PROJET: Phare is a mental health startup in the digital health services space with 25 counsellors and 125 clients (and growing). Our core product is a marketplace dedicated to an ideal fit between clients with counsellors. Our team has been serving paying clients in need of therapy for more than a year (since June 2020). HOW MANY STUDENT INTRAPRENEURS WILL THIS PROJECT ACCOMMODATE? 5 TIME COMMITMENT PER STUDENT/TEMPS DE TRAVAIL PAR ÉTUDIANT: 70 KEY PROJECT ACTIVITIES/TÂCHES ASSOCIÉES AU PROJET: Managing social media Administrating operations Updating financial records Helping us analyze financial and operational data (using Excel and Power BI) You will present on your findings during regular meetings IDEAL ROLES/RESPONSIBILITIES/RÔLES/RESPONSABILITÉS:* Marketing, Social Media Data Analysis, Operations FINAL PROJECT DELIVERABLES/LIVRABLES DU PROJET: Progress reports PROJECT MENTOR NAME/NOM DU MENTOR DU PROJET: Dr. Ray Hsu