University of Alberta
Log in Sign up

Analytics Capstone - November/December 2022

ANA1010
Closed
Cambrian College
Cambrian College
Sudbury, Ontario, Canada
Sidney Shapiro
Sidney Shapiro He / Him
Assistant Professor, Business Analytics
2
Timeline
  • November 1, 2022
    Experience start
  • December 2, 2022
    Partner check in and feedback
  • December 20, 2022
    Experience end
Experience
10/14 project matches
Dates set by experience
Preferred companies
Anywhere
Any
Any industries
Categories
Information technology Data analysis Data modelling Market research
Skills
project planning business analytics storytelling and data visualization data analysis research
Learner goals and capabilities

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.

Learners
Graduate
Any level
30 learners
Project
210 hours per learner
Learners self-assign
Teams of 2
Expected outcomes and 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 timeline
  • November 1, 2022
    Experience start
  • December 2, 2022
    Partner check in and feedback
  • December 20, 2022
    Experience end
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.

Linked templates
Analyzing Industry Data View all
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