Business Analytics Capstone - Spring 2021

Closed
Project
Academic experience
120 hours of work total
Participant
Anywhere
Advanced level

Project scope

Categories
Operations Project management Information technology
Skills
cross-selling predictive modeling business analytics statistical analysis customer acquisition management machine learning product lining solution deployment descriptor data modeling program evaluation
Details

The capstone project provides an opportunity for businesses and learners to collaborate to identify and translate a real business problem into an analytics problem. The project can include elements of data collection & preparation, data modeling, and analysis with the potential to include predictive modeling, 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 relevant to your organization and business problem. The capstone course instructors will review the documents to confirm the proposed problem's scope and timing 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. Nonprofit program evaluation and funding
  3. Analyzing business 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 (behavioral 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

To ensure students’ learning objectives are achieved, we recommend that the datasets are at least 20,000+ rows in size. Data need not be ‘clean’; it is advantageous to the students’ learning experience to require hygiene before analysis. Similarly, if more than one database is provided, which must be conjoined, students will be required to integrate them. This supports the learning experience and minimizes partner data preparations.

Deliverables
No deliverables exist for this project.
Mentorship

CEO

About the company

Company
2 - 10 employees
Sales, Insurance, Banking & finance

Since our beginnings in 2002, we have grown to become one of the largest financial planning companies in Midwestern Ontario. We are a full service financial planning company that focuses on the four key parts of your financial life - investments, insurance, income tax, and debt management.