Portfolio

Project maintained by ldruizsan Hosted on GitHub Pages — Theme by mattgraham

Luis Ruiz-Santiago

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

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

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

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

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

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