This dataset and analysis were completed as part of a graduate-level capstone project for the master’s program in Information Science 2023. In collaboration with a cohort, I helped to develop a mock company—Cave Shippers LLC—where my responsibility was to conduct an end-to-end analysis of historical performance and future sales potential for shipping containers produced using various material types.
Through this assessment, I delivered insights and reporting to support key business questions, including:
Developing an interactive dashboard to evaluate quarterly sales trends and units sold
Performing a 10-year sales forecast to estimate long-term performance
Conducting statistical analysis to assess material type performance, order frequency, and customer-level sales behavior
Source Code and Files Used
My role on the team was to analyze and present insights for a mock startup company. Using a dataset adapted from a real shipping container business, we modified the source data into a CSV, loaded it into MySQL, and created interactive Tableau visualizations to communicate findings.
First, I reviewed the dataset’s size and metadata to understand its structure and determine the appropriate handling approach based on each field’s attributes. Next, I built Databricks Dashboard visualizations driven by SQL queries to highlight key trends in work type, remote ratio, and salary by work year.
🖥️Databricks
📊Tableau
💡MySQL