ENGG 390 Reports (MEM Students)
Degree Program
M.E.M
Year of Graduation
2019
Sponsor
Tesla, Spark, NV
Faculty Advisor
Eric S. Bish
Document Type
Report
Publication Date
2018
Abstract
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
Dartmouth Digital Commons Citation
Zhang, Wanqiao, "Full-Stack Automated Reporting System for Supply Chain Metrics" (2018). ENGG 390 Reports (MEM Students). 13.
https://digitalcommons.dartmouth.edu/engs390/13
Restricted
Available to Dartmouth community via local IP address.