Data-Driven Insights for Local Pharmacy Marketing

Open
Abdul Awal Pharmacy Services Inc.
Toronto, Ontario, Canada
Pharmacy Owner
Project
Academic experience or paid work
60 hours of work total
Learner
Ontario, Canada
Advanced level

Project scope

Categories
Data visualization Data analysis Data modelling Marketing analytics Databases
Skills
kibana elastic (elk) stack document-oriented databases mongodb logstash demography marketing data analysis dashboard decision making
Details

Abdul Awal Pharmacy Services Inc., a new independent pharmacy in Toronto, is seeking data-driven insights to support its marketing and operational decision-making. Students will analyze customer interaction data, demographic information, and digital engagement to identify trends and opportunities. The goal is to use document-oriented databases and the ELK stack to visualize and interpret patterns that can inform strategic outreach, community needs, and service optimization.

Deliverables

Students will:

  • Build a MongoDB database to structure community demographic and pharmacy service data
  • Design and implement dashboards using Kibana for real-time marketing insights
  • Use Logstash to process sample engagement data (e.g., online interest, flyer response rates)
  • Identify key metrics (e.g., geographic interest, service demand) to support targeted marketing
  • Deliver a data analysis report with visualizations and actionable business recommendations
  • Present final findings to Abdul Awal Pharmacy Services Inc. in a professional presentation


Mentorship
Domain expertise and knowledge

Providing specialized, in-depth knowledge and general industry insights for a comprehensive understanding.

Skills, knowledge and expertise

Sharing knowledge in specific technical skills, techniques, methodologies required for the project.

Hands-on support

Direct involvement in project tasks, offering guidance, and demonstrating techniques.

Tools and/or resources

Providing access to necessary tools, software, and resources required for project completion.

Regular meetings

Scheduled check-ins to discuss progress, address challenges, and provide feedback.

Supported causes

The global challenges this project addresses, aligning with the United Nations Sustainable Development Goals (SDGs). Learn more about all 17 SDGs here.

Good health and well-being

About the company

Company
Toronto, Ontario, Canada
2 - 10 employees
Hospital, health, wellness & medical
Representation
Minority-Owned Small Business Family-Owned Immigrant-Owned Community-Focused

Abdul Awal Pharmacy Services Inc. is a trusted, community-focused pharmacy located at 3176 Eglinton Ave E in Scarborough, Ontario. We are dedicated to providing personalized healthcare services and a wide range of pharmaceutical products to meet the needs of our diverse clientele.​

Our services include prescription dispensing, medication counseling, and health consultations, all aimed at ensuring the well-being of our patients. We pride ourselves on our commitment to accessibility and customer care, making healthcare more convenient and approachable for everyone.