My Data Analytics Portfolio

Projects

Daylight Savings Time and Car Collisions Using Excel and Power BI

This collaborative project, my team and I examined car collisions that happened during daylight savings time. To accomplish this, we cleaned and process our data with Excel, and then utilized Power BI to conduct further analysis. Employing different techniques to discover that Spring Forward correlated with the highest number of car collisions.

Manufacturing Data using Python

Analyzing mining data with Python, I was able to uncover if using depressants is a successful technique and the best mining dates which could lead to the most profitable mining sites.

Healthcare Analysis with SQL

Using MySQL, I uncover issues with readmittance to the hospital, the correlation between patients staying longer in the hospital and having more lab procedures done and which medical specialties are causing these high numbers.

The World Bank Analysis with SQL

In this analysis, I uncover specific findings using The World Bank financial data. I focus on the top borrowers, the average The World Bank is lending out and how much money is being paid back.

Massachusetts Education Analysis

In this project, I explore the state of Massachsett’s educational data. It talks about where the state needs to focus to grow college attendance, what class room size to maintain, schools that are falling behind and recommendations on what to do.

Door Dash Market Analysis Using Excel

For this step by step analysis, I go over Door Dash data to create a better marketing campaign. Things like what age groups are spending the most on the app, what the average being spent are and recommendations to do next to increase users and spending.

Space Missions Dataset Using Excel

In this analysis, I look over Space Missions from 1959 to 2022 to focus on missions that were successful and unsuccessful. I also take a dive into the financial aspect to space missions and figure out why budgets vary so widely.

Samantha Paul