ProgramsGraduate Business Analytics Consulting Program (Fall 2024)ProjectsBuild a Visualization Dashboard for Expert Survey Response Data and...

Project Title: Build a Visualization Dashboard for Expert Survey Response Data and Expert Details for Inlightened

Inlightened

Details
Project Title Build a Visualization Dashboard for Expert Survey Response Data and Expert Details for Inlightened
Project Topics Data Management
Skills & Expertise Business Project Management Data Analytics Data Engineering Data Entry Data Processing Data Visualization Digital Project Management Experimentation & Testing Front-End Development Graphic Design Healthcare Project Management IT Compliance Market Research Qualitative Research Quantitative Research Technical
Project Synopsis: Challenge/Opportunity
Inlightened, a healthcare platform that democratizes access to a marketplace of curated, vetted, and engaged clinicians and healthcare professionals, aims to enhance its service offerings by integrating a robust survey data visualization tool. Currently, Inlightened utilizes SurveyMonkey for gathering survey responses from healthcare experts. The opportunity lies in migrating this process to an in-house system that will allow users to create, manage, and analyze survey data directly within the Inlightened platform. This transition will empower clients to gain deeper insights, enhance decision-making processes, and streamline their operations, ultimately improving the user experience and engagement on the platform.

Inlightend has thousands of Experts currently in our database. We will add hundreds of thousands more in the next few years. We want to allow the companies that use our site to access our database for insights into trends and details about the healthcare landscape and apply this knowledge to their projects.
Project Synopsis: Activities/Actions Required
  • Conduct a thorough analysis of the current survey data and identify key metrics for visualization.
  • Develop a schema to structure the backend for data ingestion and management.
  • Design a prototype for the data visualization dashboard, incorporating user feedback and iterative improvements.
  • Implement data visualization techniques to enable real-time querying and analysis of survey data.
  • Ensure the dashboard supports various types of visualizations such as bar graphs, charts, and heat maps.
  • Develop comprehensive documentation and user guides for the new system.
Project Synopsis: Expected Results
  • Successful migration of existing survey data into the new system without data loss or corruption.
  • Creation of a user-friendly dashboard that meets Inlightened’s requirements for data analysis and visualization.
  • Positive feedback from beta testers and early adopters regarding the usability and functionality of the dashboard.
  • Increased engagement and satisfaction from Inlightened’s clients, evidenced by usage metrics and user feedback.
  • Reduction in reliance on third-party survey tools, demonstrating a seamless transition to the new system.

Project Timeline

Inlightened - Build a Visualization Dashboard for Expert Survey Response Data and Expert Details for Inlightened
Due Date
Activities
Deliverables
Status
Action
Thu, 08/15/24
12:00 AM UTC
Program Kickoff
No Deliverables
No deliverables are required for this action item.
Location: In Person
Asynchronous
Mon, 08/26/24
12:00 AM UTC
Student Pre-Kick-off Self-Assessment Form
Required Evaluation
Evaluation submission is required.
View
Mon, 09/09/24
12:00 AM UTC
Deep-dive on the Organization
Required Deliverable
  • Become familiar with the company’s mission, core competencies, and current portfolio and product offerings. What is their value proposition? Who are the key stakeholders?
  • What are some of the current challenges and needs for data management in the various industries Realogic is a part of?
  • Become familiar with the broad organizational structure and how data are currently managed across the organization.
  • What business decisions are the dashboard data expected to inform?
  • How are progress and success measured and benchmarked? What are the KPI’s and how are they measured, communicated, and used in strategic planning and decision-making?
Required Deliverable
Deliverable submission is required.
Guiding Questions:
  • Become familiar with the company’s mission, core competencies, and current portfolio and product offerings. What is their value proposition? Who are the key stakeholders?
  • What are some of the current challenges and needs for data management in the various industries Realogic is a part of?
  • Become familiar with the broad organizational structure and how data are currently managed across the organization.
  • What business decisions are the dashboard data expected to inform?
  • How are progress and success measured and benchmarked? What are the KPI’s and how are they measured, communicated, and used in strategic planning and decision-making?
Deliverable Instructions:
Infographic overview of the organization and project objectives (internal); questions for industry mentor; Initial thoughts on the type of data analytics that could help make the organization more data-driven.
Wed, 09/18/24
12:00 AM UTC
Student Temperature Check
Required Evaluation
Evaluation submission is required.
View
Mon, 10/07/24
12:00 AM UTC
Design prototype dashboard and data-stream
Required Deliverable
  • What types of dashboard designs meet the company’s needs?
  • Can you create a draft and define the chart type you suggest the company use?
  • What kind of relationship, composition, distribution, or comparison of data are most useful? What types of visualizations should be used in the dashboard design, and why?
  • Which KPIs should be included, and how are these expected to promote productivity and facilitate a cost-effective working environment?
  • Can you map the dataflow logic that takes into account all dashboard audiences?
Several open-ended questions we may want to answer (this is a starting point and should be defined iteratively)
  • Operations: How does the various work distribute between employees, both in terms of handling Crelate (recruiting activities) and in terms of using calls and messages (through RingCentral?). Ideally we could see a method to track effectiveness.
  • Operations: Can we track the effectiveness of our recruiting process?
  • Social Media: How are our engagement levels looking, month to month, across every criteria - likes, shares, comments - for every one of the pages? What seems to affect engagement? 
Required Deliverable
Deliverable submission is required.
Guiding Questions:
  • What types of dashboard designs meet the company’s needs?
  • Can you create a draft and define the chart type you suggest the company use?
  • What kind of relationship, composition, distribution, or comparison of data are most useful? What types of visualizations should be used in the dashboard design, and why?
  • Which KPIs should be included, and how are these expected to promote productivity and facilitate a cost-effective working environment?
  • Can you map the dataflow logic that takes into account all dashboard audiences?
Several open-ended questions we may want to answer (this is a starting point and should be defined iteratively)
  • Operations: How does the various work distribute between employees, both in terms of handling Crelate (recruiting activities) and in terms of using calls and messages (through RingCentral?). Ideally we could see a method to track effectiveness.
  • Operations: Can we track the effectiveness of our recruiting process?
  • Social Media: How are our engagement levels looking, month to month, across every criteria - likes, shares, comments - for every one of the pages? What seems to affect engagement? 

Deliverable Instructions:
Prototype Dashboard and Dataflow Map
Wed, 10/23/24
12:00 AM UTC
Temperature Check #2
Required Evaluation
Evaluation submission is required.
View
Mon, 11/04/24
12:00 AM UTC
Define Needs & Select KPI’s
Required Deliverable
  • Who will work with the KPIs featured in the dashboard? 
  • What kind of information will they need? 
  • Do you need to present your dashboard to C-level management or other employees? 
  • What technologies are used to support the dashboard?
  • Are you creating a dashboard for daily operational tasks or do you need to showcase the strategic performance of long-term goals? 
  • What is the best viable way to present the information?
  • What metrics should be presented in the dashboard?   How do they align to specific short-term objectives or more long-term goals? How do the metrics add value? 
Required Deliverable
Deliverable submission is required.
Guiding Questions:
  • Who will work with the KPIs featured in the dashboard? 
  • What kind of information will they need? 
  • Do you need to present your dashboard to C-level management or other employees? 
  • What technologies are used to support the dashboard?
  • Are you creating a dashboard for daily operational tasks or do you need to showcase the strategic performance of long-term goals? 
  • What is the best viable way to present the information?
  • What metrics should be presented in the dashboard?   How do they align to specific short-term objectives or more long-term goals? How do the metrics add value? 
Deliverable Instructions:
KPI inventory, map of goal/objectives alignment, dashboard usage map or table
Fri, 12/06/24
12:00 AM UTC
Create KPI Dashboard Template & Map of Dataflow Logistics
Required Deliverable
  • What are the most effective ways for creating powerful data visualizations in the dashboard environment?
  • How can you effectively and parsimoniously use a combination of designs, colors, etc., and create a dashboard useful to different audience segments? Can you align your visualizations with brand standards?
  • What additional insights can be gleaned from the dashboard?
  • What recommendations do you have for integrating the dashboard into daily operations and decision-making frameworks? Can you create user stories to illustrate how the dashboard can be used to gain business insights and inform high-quality decision-making?
Required Deliverable
Deliverable submission is required.
Guiding Questions:
  • What are the most effective ways for creating powerful data visualizations in the dashboard environment?
  • How can you effectively and parsimoniously use a combination of designs, colors, etc., and create a dashboard useful to different audience segments? Can you align your visualizations with brand standards?
  • What additional insights can be gleaned from the dashboard?
  • What recommendations do you have for integrating the dashboard into daily operations and decision-making frameworks? Can you create user stories to illustrate how the dashboard can be used to gain business insights and inform high-quality decision-making?

Deliverable Instructions:
Dashboard, User stories, Recommendations
Fri, 12/06/24
12:00 AM UTC
Student Post-Engagement Self-Assessment Form
Required Evaluation
Evaluation submission is required.
View
Fri, 12/06/24
12:00 AM UTC
Student Post-Engagement Peer Assessment Form
Required Evaluation
Evaluation submission is required.
View

Program Managers

Name Organization
Uma Gupta University of South Carolina - Upstate

Teams

Team Name  Project Name  Team Members 
No Teams Available