Analytics Capstone - Fall 2022

ANA1010
Closed
Cambrian College
Sudbury, Ontario, Canada
Sidney Shapiro
Professor and Program Coordinator
(29)
3
General
  • Graduate
  • 30 learners; teams of 2
  • 210 hours per learner
  • Dates set by experience
  • Learners self-assign
Preferred companies
  • 13/20 project matches
  • Anywhere
  • Academic experience
  • Any
  • Any
Categories
General Data analysis Market research Operations Project management Information technology
Skills
project planning business analytics storytelling and data visualization data analysis research
Project timeline
  • September 7, 2022
    Experience start
  • October 1, 2022
    Partner check in and feedback
  • October 29, 2022
    Experience end
Overview
Details

This capstone project is part of the Business Analytics (BAPG), Health Analytics (HAGC), and Crime Analytics (CAGC) graduate certificate programs at Cambrian College. The students will participate in various projects involving different types of data, ranging from qualitative data gathering, quantitative data and analysis, technical projects, or other projects that align with their skillsets. This could include but is not limited to large and/or complex data, gathering data, conducting program evaluation, development and deployment of surveys, help with funding applications, create dashboards and analysis, and work with various types of data to support decisions using analytics in a wide array of industries.

Students can research, apply analytical models, methodologies, and tools learned in the program to analyze data. Faculty mentors will work with students to ensure the capstone project reflects, and encompasses, best practices for big data analytics and project management.

Learner skills
Project planning, Business analytics, Storytelling and data visualization, Data analysis, Research
Deliverables

The final project deliverables will include:

  • A report on students’ findings and details of the analytics solution.
  • A final presentation of the solution and recommendations to your organization.
  • Future collaboration ideas will be identified based on current project outcomes.
Project Examples

The capstone project provides an opportunity for organizations, businesses, partners, and learners to collaborate to identify and translate a real problems into an analytics problem. Students can research, apply analytical models, methodologies, and tools learned in the program to analyze data sets to predict trends and challenges, and investigate with the purpose of developing analytics solution for your organization. The project can include elements of data collection & preparation, data modelling and analysis with the potential to include predictive modelling, machine learning implementation, constructing dashboards or spreadsheets, programming, statistical analysis, and a solution deployment plan. Capstone project results/recommendations will be communicated in a report document and a final presentation.

You should submit a high-level proposal/business problem statement including relevant data sets and definitions, a list of acceptable tools (if applicable), and expected deliverables. Business datasets could be provided based on a non-disclosure agreement or in an anonymized/synthetic data format that is relevant to your organization and the project. The capstone course instructors will review the documents to confirm the scope and timing of the proposed problem and its alignment with the capstone course requirements.

Analytics solution may be applicable for (however they are not limited to) the following topics:

  1. Customer acquisition and retention
  2. Non profit program evaluation and funding
  3. Analyzing data
  4. Merchandising for trade areas (categories)
  5. Quantifying Customer Lifetime Value
  6. Determining media consumption (mass vs digital)
  7. Reduction of client churn (lower abandonment)
  8. Cross-sell and up-sell opportunities
  9. Develop high propensity target markets
  10. Customer segmentation (behavioural or transactional)
  11. New Product/Product line development
  12. Market Basket Analysis to understand which items are often purchased together
  13. Ranking markets by potential revenue
  14. Consumer personification
  15. Market research
  16. Development or integration of software or databases

Note: Students can sign a NDA, if required.

Additional company criteria

Companies must answer the following questions to submit a match request to this experience:

Provide a dedicated contact who is available to answer periodic meetings, emails or phone calls over the duration of the project to address students' questions. Checking in with students as the project progresses with regular meetings, reviews, and updates.

Be available for a quick phone call or meeting with the instructor to initiate your relationship and confirm your scope is an appropriate fit for the course.

Provide a dedicated contact who is available to answer periodic emails or phone calls over the duration of the project to address students' questions. Checking in with students as the project progresses with regular meetings, reviews, and updates.

Provide students with written feedback half way through the project and at its conclusion