ENGG 390 Reports (MEM Students)

Degree Program

M.E.M

Year of Graduation

2019

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

Download

Restricted

Available to Dartmouth community via local IP address.

Share

COinS