Worked on a team as Data Analyst consultants for MAC Aerospace through the University of Maryland to analyze 30 years of past data collection
Project Objectives:
Optimize Research Process
Interview MAC employees to assess how they interact with MARS
Interview MAC employees to assess how they interact with MARS
Purchase Stock of Particularly Profitable Items
Analyze data to assess frequently sold and high profit items
Analyze data to assess frequently sold and high profit items
Create Partnerships & Alliances
Analyze vendor and customer data to identify repeated transactions with specific companies
Analyze vendor and customer data to identify repeated transactions with specific companies
Closing Rate
Identify the proportion of RFQs that have been converted to sales
Identify the proportion of RFQs that have been converted to sales
Link to final report:
https://docs.google.com/document/d/1AShv7xvTLyKaoJjhDfxXTHLF645e0KXr0odYmD45Arg/edit?usp=sharing
Completed data cleaning in R and merged datasets for visualizations in Tableau.
Links to Tableau dashboards:
Customers: https://public.tableau.com/profile/caleb.lee1627#!/vizhome/MACPart3/Dashboard2?publish=yes
Sales and Clients: https://public.tableau.com/profile/amanda.lynn.neal#!/vizhome/TopClientsandTopSalesPeople/Dashboard1
Vendors: https://public.tableau.com/profile/amani5183#!/vizhome/TopVendorAnalysis/Dashboard1?publish=yes
