Capstone – Project

Cluster US Census block groups into hyperlocal markets

A Collaboration Between

Engagement Synopsis

The US Census Bureau makes loads of data available via their API data service. While the API service works for many processes, this project seeks to cluster 200K Census block groups based on data drawn from the American Community Survey (ACS). This will provide Morton Analytics LLC a way to create hyper local market data and maps as a ready to use solution for understanding local markets by population/demographics, preferences, and so forth.

Use cases include geo-based marketing development and outcome measures, market research and penetration metrics, and map making.

Morton Analytics LLC will provide:
A PostgreSQL database connection with raw data
A web-based RStudio IDE – optional

You will deliver:
A cluster model that preferences geographic proximity (there are existing functions that do this – you don’t need to develop anything new here)
A dashboard view of summary statistics about the clusters
Documentation describing the process you followed to produce your final product

Company Information

Hiring PotentialN/A

Company Overview


Course Info & Engagement Details

Engagement Format -
CourseBMIS476 Project Management
  • All Undergraduate
Students EnrolledN/A
Meeting Day & TimeN/A
Student Time Commitment4-7 Hours Per Week
Company Time Commitment2 Hours
Duration14.29 Weeks

Project Topics

Data Management

Reporting, Financial Planning & Analysis

Software Design & Development


There are currently no students assigned.

Collaboration Timeline

  • January 8, 2021

    Collaboration request published. Industry Partners may express interest in participating.

  • January 8, 2021

    Educators will begin interviewing interested Industry Partners to discuss project ideas.

  • January 8, 2021

    Final date for Industry Partners to express interest in participating.

  • January 8, 2021

    Educators and Industry Partners finalize project charters, legal documents, and background materials.

  • January 21, 2021

    OFFICIAL PROJECT LAUNCH: We’ll find a time on this day to web conference you into our class to kickoff the project.

  • May 1, 2021

    OFFICIAL PROJECT END: We’ll find a time on this day to web conference you into our class to close the project.

Key Milestones & Project Process

Project Resources

There are no resources currently available

Company Supervising Team

There are currently no supervisors assigned.

School Supervisors

There are currently no supervisors assigned.