Year of Graduation
Tesla, Spark, NV
Eric S. Bish
An automated reporting mechanism was designed and implemented in order to increase the visibility of material flow performance within Tesla’s raw material supply chain system. In order to effectively evaluate the logistics efficiency, a framework of metrics was proposed to standardize the performance scoring. Concurrently, a full-stack data pipeline was built to efficiently support the business decision-making. Data was consolidated from distributed database using complex SQL queries, centralized database was staged on SQL server to promote the data acquisition efficiency by 3600%( from 360seconds to 10 seconds), and an interactive dashboard was built to allow users accessing the data without any knowledge about the database.
Level of Access
Restricted: Campus/Dartmouth Community Only Access
Zhang, Wanqiao, "Full-Stack Automated Reporting System for Supply Chain Metrics" (2018). ENGG 390 Reports (MEM Students). 13.
Available to Dartmouth community via local IP address.