Juan Nicolas Serrano's Projects
Analysis on Amazon's vine review program using PySpark and AWS RDS with PostgreSQL
Created an interactive dashboard to display bacteria that live inside the human body and are able to synthesize protein using Plotly.js and HTML/CSS
Created a story and multiple dashboards to analyze and visualize Citi Bikes data using Tableau and Python
Utilized several machine learning models to predict credit risk using Python's imbalanced-learn and scikit-learn libraries
Cryptocurrencies analysis using unsupervised machine learning and Python
Audit on Congressional Election using Python 3
Performing analysis on Kickstarter data to uncover trends using Excel
Created interactive visualizations for earthquake data using JavaScript, Leaflet, Mapbox, D3, and GeoJSON
HTML Web scraping on mars data to create a flask web application using Python, Bootstrap, and MongoDB
ETL pipeline on movie data using Python and postgreSQL
Linear Regression Model and Statistical Significance analysis on NBA salaries data to predict players' salary by looking at their stats
Config files for my GitHub profile.
Employee database analysis and future-proof on retiring employees using SQL and pgAdmin
Analysis on ride-sharing data using Pandas, NumPy, and Matplotlib Libraries.
Analysis on School District's funding and SAT scores using Pandas and NumPy libraries.
Automating the data analysis of renewable energy stocks using VBA
Analyzing weather data from an SQLite Database using Python, SQLAlchemy, and Flask
Created a website that displays UFO-sightings data and is able to filter through it on user input using JavaScript, HTML/CSS, and Bootstrap
Weather analysis and travel maps and directions of +600 cities around the world using multiple APIs.