CSE498, Collaborative Design, Spring 2024
Computer Science and Engineering
Michigan State University

Ford Motor Company is an international automotive manufacturer headquartered in Dearborn, Michigan. With nearly 175,000 employees and producing about 6.4 million vehicles globally, Ford stands as one of the top ten automakers worldwide.

Dealerships are facing stiff competition in the market. Tracking performance across dealerships is pivotal in our modern information age. Ford dealers need to be constantly innovating and improving to ensure success in the automotive industry.

Our Dealer Experience Dashboard streamlines and modernizes the access and analysis of critical information to drive future sales for Ford dealers.

Dealers interact with our dashboard to generate reports of the key data metrics they are interested in analyzing, for example, sales, repair orders, vehicle deliveries, etc.

We offer significant customization options so that each dealer can focus on what matters to them. Our dashboard also boasts extensive data visualization tools, enabling users to quickly and effortlessly comprehend complex data through charts and graphs.

After a dealer finishes their data analysis, our dashboard generates a report of the data, visualizations, and overall analysis. This report is then shared with any relevant entities to help improve the overall dealer performance.

Our system automates real-time updates, keeping dealers informed of any changes or trends in dealership performance.

Our software shows sales trends and identifies key areas of growth in dealerships, improving sales and increasing revenue. All the information analysts need to see is now condensed in a few easy-to-use web pages along with easy ways to share these reports.

Our UI is primarily written in JavaScript and developed using React for the front end, Express to talk to the server, and Google’s BigQuery to handle the data.