The Business Analytics Capstone Experience allows students to work on real-world business problems using data and statistics.
Graduate students work with a UM-Dearborn faculty advisor and a mentor from a sponsoring company to model, analyze and recommend a solution for a significant business problem.
Sponsoring a Capstone Project
The curriculum for the Master of Science-Business Analytics in the College of Business prepares students to deal with the challenging task of deriving deep insights from the vast array of structured and unstructured data in a variety of business areas. The program prepares students to pursue careers such as a data scientist or analyst.
Capstone Project Overview
The capstone project is the core of the MS-Business Analytics curriculum. This 15-week course emphasizes a team-based learning experience in which students conduct real-world analytics projects using data provided by the sponsoring organization. Since 2016, students have completed 15 projects with six sponsoring organizations. Some of the industry sectors represented by our sponsors include manufacturing, healthcare, energy, retail and service. Student projects have included optimal supply-chain logistics configuration, health-care services profitability analysis, predictive modeling for parts classification, analysis of customer satisfaction in a call center, forecasting weather-related power outages, and data-modeling for smart mobility.
Why Sponsor a Capstone Project
Sponsoring a project provides MS-Business Analytics students an opportunity to gain experience applying their coursework to real-world business problems.
It also offers the sponsoring organizations the opportunity to work with our students. Many organizations make formal offers of employment to project participants after their work in the capstone project.
Only select students participate in the Capstone course. These students are selected on the basis of:
- Superior academic performance in the graduate program.
- Successful completion core courses in statistical modeling and analysis, optimization, forecasting, and data mining.
- Demonstrated teamwork and problem-solving skills.
- A formal written project report.
- A software demonstration (if developed for a particular application)
- A public presentation summarizing the project results.
There is no cost to sponsor a project.
Requirements for Sponsor
- A project lead who will interface with the student team and Faculty Coordinator on all project matters.
- 2 to 3 hours each week for meetings with the student team, either in person or online.
- A brief, well-defined problem statement. The solution to the problem must require quantitative analysis, such as statistical analysis, optimization, predictive modeling, data mining, visual analytics, and exploratory analysis.
- A prepared data set that requires data modeling, such as data cleansing, data preparation, data normalization, data merging, or data parsing. Students must be able to analyze the data using natural languages, such as R or Python.
Project teams sign a non-disclosure agreement to protect the privacy of the data and other information shared by the sponsor. Sponsors may anonymize business-sensitive information and other technical details.
At the start of the semester, the sponsor and students meet to discuss the following:
- The organization’s business problem.
- The specific goal of the data analytics project.
- A description of the available data.
- Project-meeting schedules between the sponsoring organization and the student team.
The goal of the project is for students to:
- Understand and clearly define the business decision problem.
- Process and analyze data.
- Design, model and develop a solution.
During the project, student teams maintain regular communication with the project sponsors through scheduled site visits, web meetings and weekly progress updates. The Faculty Coordinator tracks project progress with technical reviews and updates with the student teams throughout the semester. In addition, the Faculty Coordinator and project sponsors jointly conduct mid-term progress reviews and provide feedback to the student teams.
The University provides student teams with access to an extensive portal of prominent software in a cloud-based environment, which students will use on their projects.
At the conclusion of the project, the student teams will make a public presentation of their findings to the sponsor, College of Business faculty, staff and students.
The Capstone project course is offered two times a year, during Fall and Winter semesters. We welcome your inquiries about sponsoring a Capstone project. We are currently in the planning stages for projects for Fall 2019 (9/4/19 to 12/18/19) and Winter 2020 (1/8/20 to 4/22/20) semesters. The tentative schedule is as follows:
- Problem identification and project planning:
- Now through August 15, 2019 for Fall 2019 semester.
- Now through November 15, 2019 for Winter 2020 semester.
- Project kick-off meeting:
- Wednesday, September 4, 2019 for Fall 2019 semester.
- Wednesday, January 8, 2020 for Winter 2020 semester.
- Final presentation to sponsor:
- Wednesday, December 18, 2019 for Fall 2019 semester.
- Wednesday, April 17, 2020 for Winter 2020 semester
- Problem identification and project planning:
Capstone Projects for Fall 2019
DTE Energy Project: Predict Resources Needed for Storm Restoration in a Given Time
A large storm can cause numerous power outages leaving hundreds of thousands of customers without power. DTE Energy wants to be able to predict the number of resources that will be needed to improve outage restoration at any given time. Power can be restored quickly after a storm if DTE has an increased number of service crews available (including service crews from other regions in Michigan and out of state), but this solution comes with a cost. Therefore understanding the relationship between cost and time is critical for DTE to make more informed decisions to balance time, cost and customer satisfaction.
XPO Logistics Project: Predictive Analytics for Assembly Plant Cost Per Mile
XPO Logistics wants to utilize predictive analytics to analyze various Impact Matrix components for plant comparisons to determine whether there are large variances among them and if so, why? Using historical data students will identify the Impact Matrix for various plants and produce individual plant summaries to predict when cost per mile will change.
“Students had a short period of time to work on large scale issues, but they were able to find opportunities within the data set, and indeed, Ford will be implementing solutions in this space.” - Alan Jacobson, Ford Motor Company
Ford Motor Co.
Process for Generating an Origin-Destination Demand Matrix for Use in a Commuter Ride-sharing Simulation at Ford Smart Mobility
Ford Motor Company has expanded into mobility services with the purchase of a startup company, Chariot, which offers a carpooling service to commuters in select urban areas and uniquely allows potential customers to vote on new commuter routes. To support Ford and Chariot in identifying new commuter routes in cities where the company is not operating, this research effort created a process that simulates commuter origin and destinations, the number of commuters, and time of departure. The process selected San Francisco, CA as a starting point in part for verification purposes because Chariot already has operations in the city. Results indicate the process properly simulated commuter flow. Specifically, commuter’s origin locations were highly dispersed across San Francisco, but the destination locations indicate commuters are traveling towards areas of high employment. The process also accurately simulated departure times associated with the rush hour commute. In summary, the process created can be replicated to model commuter traffic patterns in other cities and identify where large of commuters are traveling from and to and during what time of day. Thus, the process provides Ford and Chariot commuter data to help guide early business decisions. An end-to-end analytics framework was utilized to process publicly available data from a very large number of sources by utilizing advanced data mining, visual analytics and simulation techniques to generate traffic flow inputs for advanced transportation network and simulation models.
Modeling for Predicting Power Outages due to Weather Events for DTE Energy
DTE Energy, the electrical service provider for Southeast Michigan, allocates a great deal of resources toward managing outages, particularly those caused by big weather events. This research project aimed to develop a series of models which are geographically sensitive (at the service center level) to predict number of power outages per day based on weather data. Using an ensemble of neural networks, a model for each service center was created that is sensitive to three different scenarios. These models, specifically those belonging to the four service centers which experience the greatest number of electrical service interruptions, predict number of outages in that service center to an industry benchmark level of accuracy. Further, one scenario—high temperature and high wind speed days—predicts outages substantially beyond industry benchmarks. Finally, we discuss our attempt at a more time sensitive model, predicting outages hourly. An end-to-end data analytics framework was utilized to process large disparate datasets by utilizing advanced data mining techniques to cleanse, merge and prepare data for modeling utilizing predictive modeling, and classification & forecasting algorithms. This work has enabled DTE Energy to better plan their labor and other resources in restoring power in a more efficient manner.
Stefanini IT Solutions Inc.
An Analytics Approach to Managing Inbound Call Support at Stefanini IT Solutions
Harnessing the power of data and analytics is the first step in driving operational efficiencies for the business of the future. Stefanini is looking to gain data driven insights into two of their existing call-center processes – inbound call handling process and the existing service ticket creation process. Stefanini currently maintains and captures data related to these two processes separately. The purpose of this project is to combine the call related data with the corresponding tickets and assist Stefanini to gain a better understanding of on what impact the issue types have on the duration of the calls. The analysis will also help Stefanini identify key areas to drive automation, deploy additional employee trainings and optimize the existing staffing models that can eventually generate operational efficiencies for the company. An end-to-end analytics framework was designed by effectively combining the two disparate data sets by utilizing exploratory data analytics, visualization and advanced analytics techniques to generate key insights to help drive efficiencies and automation for Stefanini.