ProgramsIntegrated Project Management Capstone Course (BMIS476 - Fall 2025)ProjectsMarket Research ETL Pipeline and Dashboard

Project Title: Market Research ETL Pipeline and Dashboard

Morton Analytics LLC

Details
Project Title Market Research ETL Pipeline and Dashboard
Project Topics Data Management Information Technology (IT) Market Research Reporting, Financial Planning & Analysis Research, Analysis, Evaluation Software Design & Development
Skills & Expertise API Data Engineering Data Vi Market Research Shiny for Python Shiny for R Statistics Tableau
Project Synopsis: Challenge/Opportunity
Morton Analytics LLC excels in providing professional services that leverage data analytics to drive informed business decisions. However, the company currently faces challenges in efficiently processing and analyzing vast datasets from the U.S. Census American Community Survey. The lack of a streamlined ETL process hinders timely access to crucial demographic and economic data, impacting the company's ability to deliver actionable insights to clients. As a result, Morton Analytics is missing opportunities to enhance client strategies, optimize resource allocation, and improve market positioning.
Project Synopsis: Activities/Actions Required

  1. Students will utilize ETL tools to extract data from the Census API.
  2. Census American Community Survey (2014-2023), transform it into usable formats, and load it into a database or parquet file format.
  3. They will employ time series data visualization techniques to create an interactive dashboard that showcases key population trends based on user selected market geographies (county, zip, tract).
Project Synopsis: Expected Results
  • The expected outcomes of this project include the successful creation of an ETL pipeline and a user.
  • Friendly dashboard that provides insights into demographic and economic trends from the U.S. Census data. 
  • Students will achieve learning outcomes related to data management, software development, and market analysis. 

Project Timeline

Touchpoints & Assignments Date Type

Student Teams Finalized

 Aug 28 2025 Event

Students Select Project Preferences

 Sep 04 2025 Event

Students Introduced to Industry Partners to Schedule Kickoff Meeting for Next Week

 Sep 17 2025 Event

Submit Project Charter (For Industry Approval)

 Sep 23 2025 Event

Negotiate and Sign NDA if required

 Sep 23 2025 Event

Industry Temperature Check 1/3

 Sep 26 2025 Evaluation

Student Temperature Check 1/3

 Sep 26 2025 Evaluation

Student Temperature Check 2/3

 Oct 31 2025 Evaluation

Industry Temperature Check 2/3

 Oct 31 2025 Evaluation

System Design Document

 Nov 04 2025 Event

Agile Development Meetings with Project Sponsor

 Nov 07 2025 Event

Student Temperature Check 3/3

 Nov 21 2025 Evaluation

Industry Temperature Check 3/3

 Nov 21 2025 Evaluation

Final Presentation

 Dec 05 2025 Event

Industry Project Feedback Form

 Dec 12 2025 Evaluation

Final Project Report and Hand-off

 Dec 12 2025 Event

Program Managers

Name Organization
Clayton Looney University of Montana

Teams

Team Name  Project Name  Team Members 
No Teams Available