This page will feature some of the work I have done using Python, Excel, and Tableau. For Tableau, don't forget to check my Tableau Public page!
- Data Analytics Immersion Program at Thinkful
- IBM Data Analyst Professional Certificate
- Master's Degree in Chemical Engineering at the University of Rochester - River Campus
- Bachelor's Degree in Chemical Engineering at the University of Puerto Rico - Mayagüez
Photo by John McArthur on Unsplash
- This is a dashboard developed to visualize sentiment analysis of tweets about 6 airlines and deployed to Heroku
- Python libraries used: Pandas, Streamlit, Matplotlib, Plotly Express
- Input: csv file with Tweets
- Output: Sentiment of airlines
- Repository can be found here
Photo by Kouji Tsuru on Unsplash
- The goal of this project is to visualize the trends of 4 pollutants that are part of what the EPA calls criteria pollutants and determine if the US has complied with the standards that have been established by the EPA.
- Python libraries used: Pandas, Matplotlib, Seaborn, Scipy.Stats
- Input: concentration levels by location for ground-level ozone, sulfur dioxide, nitrogen oxide, and carbon monoxide along the Air Quality Index (AQI) for each
- Output: Visualization of trends using lineplots and measure statistical significances
Photo by Dylan Gillis on Unsplash
- This project evaluated performance of account executives and developed models for a new sales commission structure for the new fiscal year
- Three strategies were considered:
- Assume the company is increasing the book of business, no increase in headcount, same compensation structure
- Modify the compensation structure with the same target revenue (no BoB growth) and no increase in headcount
- Increase headcount while keeping the same structure and book of business
- A fourth strategy combines the first 3 to estimate the impact
- The model showed that, individually, the first strategy provided the largest revenue growth by over $200 million. However, combining all three is expected to grow by over $400 million.
- The project also includes an employee dashboard that allows to look up performance of any single account executive and a dashboard to evaluate the performance of executives by level
Photo by Yulia Matvienko on Unsplash
- This is my submission for Maven Analytics' Toys challenge and we we tasked with providing insight into possible expansion strategies for the company
- My analysis showed the company has a lot of inventory at hand and identified three cities in Mexico that can be considered for opening new stores that are closer to high-volume areas and can also help distribute excess inventory
- For a full description of the situation, make sure to check my LinkedIn post
Photo by Ishant Mishra on Unsplash
- This was a project that analyzed stock daily returns for 6 major tech stocks and compare their performance to that of the S&P500
- Parameter Beta was calculated using CAPM for each stock to determine volatility relative to the market