This project is the final assignment for my Database Programming class, focusing on analyzing data from the Lahman’s Baseball database. The analysis covers team statistics from 2000 to 2003, with a particular focus on the Chicago Cubs.
- Utilized SQL and MySQL Workbench to query and analyze baseball data
- Exported query results as Excel sheets for further processing
- Created dynamic visualizations using Tableau to present insights on team performance
- Examined trends and statistics of teams competing between 2000 and 2003, with an emphasis on the Chicago Cubs
- SQL (Structured Query Language)
- MySQL Workbench for database management and querying
- Tableau for data visualization and presentation
- Excel for intermediate data handling/export
- In-depth statistical analysis of team performances from 2000-2003
- Visual dashboards showcasing trends, wins, losses, and other key metrics
- Focused case study on the Chicago Cubs to highlight specific team insights
- SQL queries and scripts used for data extraction and analysis
- Exported Excel sheets containing processed data
- Tableau workbooks and dashboards for visualization