Data Analysis of Motorcycle Crash Data in Massachusetts
Leveraged SQL proficiency within the ArcGIS Pro framework to conduct an in-depth analysis of a complex CSV dataset sourced from the Massachusetts Department of Transportation (MassDOT). The dataset comprised 10,709 individual crash data points, each containing extensive information encapsulated in 79 rows. Augmented the analysis by incorporating town and state details provided by MassGIS.
Translated the analyzed dataset into visually compelling presentations using Excel, emphasizing critical trends and patterns for a clear understanding
Successfully delivered a comprehensive presentation, showcasing the insights gained from the analysis, and published the presentation on YouTube for wider dissemination.
Python Capstone Project: Advanced Gradebook System
User-Creation Module: Engineered a robust system for creating and managing user profiles, each uniquely identified through identification numbers, ensuring a secure and organized user database.
Data Management and Storage: Developed functionalities for efficiently saving and retrieving user-specific information, streamlining data access and manipulation.
Access-Level Hierarchies: Implemented a tiered access structure catering to different user roles, including Professors, Teaching Assistants (TAs), Administrators, and Students.
Role-Specific Functions: Empowered higher-level access users (Professors, TAs, Administrators) with the capability to add, modify, and revise information within the gradebook, fostering collaboration and data accuracy. Enabled lower-level access users (Students) to view pertinent information, promoting transparency and accessibility.