Consulting Committee
The UF AIS Consulting Committee provides MS-ISOM students with real-world consulting experience, professional development opportunities, and a supportive environment to learn and grow your consulting skills.
Past Projects
DuPont Community Foundation
PM: Angela Chan; Analysts: Allen Boulenger, Clare Huang, Chinar Patil, James Patnik
The duPont Community Foundation team created a Tableau dashboard to analyze and compare data in the Jacksonville community to assess needs, measure progress, and forecast potential areas that need investments in the Northeast Florida neighborhoods/communities.
The team analyzed the data of 7 indicators detailed by the Brookings Institute that influence poverty and displacement levels in the greater Jacksonville community. Factors include homeownership rates, self-employment rates, and displacement risk rates in the community. Local funders, non-profits, and social-focused entrepreneurs can use
the dashboard to inform decision-making processes to improve affordable housing investment decisions.
Hunger Network
PM: Archana Pullela; Analysts: Rounak Amre, Shawna Dean, Thomas Gilfix
The Hunger Network team was tasked to build a feasibility report for the Northeast Florida Hunger Network on communication and propose a solution. Their project researched the inter-communication problems faced by food distributors, their various non-profit partners, and the working volunteers.
The team concluded that there is a need for a modern platform that facilitates access to information and a universal place to broadcast information for everyone involved in food donation. This platform would be a website hosted by Smart North Florida and serve Jacksonville and its surrounding areas.
Northeast Florida Regional Council (NEFRC)
PM: Riya Patel; Analysts: Gregory Gerve, Ayoung Sylvia Jang, Jacob Warchola
The NEFRC project involved creating dashboards composed of graphs and maps that presented various "quality of life" indicators for the North Florida Regional Council Annual Report. The indicators were divided into the following four categories:
-
Education
-
Transportation
-
Housing
-
Healthcare
Separate dashboards were created for each category that visualized demographic data for zip codes and counties in the Jacksonville area.
Local Initiative Support Corporation (LISC) Jacksonville
PM: John Ambers; Analysts: Xiaomei Hai, Ruchir Lakhani, Rusini Perera, Chris Zhao
The team worked with LISC Jacksonville to create a map visualization to display assets within the Ribault Region. They were particularly interested in mapping private businesses, government entities, recreational facilities, transportation information, and zoning.
Overall, the goal was for LISC Jacksonville to see the region's critical assets to pitch to local investors and government officials to reinvest in the area. This will ultimately improve access to the waterways and infrastructure and provide incentives to private companies to move businesses into the region.
Neptune Beach Town Center
PM: Si Lin Lei; Analysts: Krupa Patel, William Teke, George White
The Neptune Beach Town Center team identified trends from visitor parking metrics sourced from Flowbird, the parking management solution currently in use at the Beaches Town Center. The project also included citation data from the parking violations ticketing system managed by Megan Steward, mobility manager at Neptune Beach.
To facilitate timely on-demand analytics, the team created two dashboards - one in Excel focusing on parking violations and another using R Shiny, focusing on parking metrics (Flowbird data). Each dashboard has dynamic interfaces tailored for different aspects of parking management. Within Excel, the parking citations can be
queried by their frequency, time series, and location popularity. The R dashboard investigates parking behaviors, such as visit popularity & visit duration to BTC and revenue earned by each parking lot within the current parking system. Both dashboards come with user guides for troubleshooting purposes.
This engagement finalized with a white paper focused on actionable parking solutions Neptune Beach could implement for better management. The white paper focuses on a "dynamic curbside," which encompasses low-cost solutions that capitalize on the cyclical nature of parking. Solutions include varied pricing by popular hours and selective parking spots demarked for the exclusive use of delivery services (Uber Eats, GrubHub, etc.). These solutions are meant to increase parking turnover to boost visitor presence and sales for the restaurants and entertainment-focused businesses within the Beaches Town Center.
