SQL_Queries
A series of MySQL queries on the popular sakila schema to obtain information on the tables actor, address, category, city, country, customer, film, film_actor, film_category, inventory, language, payment, rental, staff and store.
Likely Available
About
Experienced Data Analyst with a demonstrated history of working in diverse industries. I have many skills at my disposal to gather, analyze in depth, and report
Evidence-backed skills
Repositories
WeatherPy
Visualization analysis of weather in 500+ cities at different latitudes relative to the equator line. The visualizations show temperature, humidity, cloudiness, wind speed using OpenWeatherMap API and Citypy module.
UCB_Project3
Use machine learning models be used to predict the next lotto numbers Lottery Game: Predict the numbers in the California Daily 3 game (less numbers than MegaMillions or Powerball) Machine Learning: Sklearn regression models Keras sequential model
Stock-Market-Analysis
Excel Analysis of Kickstarter Campaigns
ETL-Exercise
Healthcare company stock data was pulled from Nasdaq and uploaded into a database. Additionally, the number of company sponsored clinical trials were uploaded into the database. These data sets were chosen to monitor the number of clinical trials of publicly traded healthcare companies.
Belly-Button-Diversity
Interactive dashboard to explore belly button biodiversity by sample in the dataset.
Data_Journalism
Is There a Link Between Household Income and Behavioral Risk Factors? Using D3 document, I explore certain associations between demographics and behavioral risk factors using survey data collected in 2014.
github.io
John Palalia Data Analyst Webpage
The-Power-of-Plots
Ridesharing company data analysis to provide market differentiation insights using Pandas, Matplotlib , and Jupyter Notebook.
Crowdfunding-Trends
Excel Analysis of Kickstarter Campaigns
Citi-Bike-Tableau
Visualization of Citi Bike sharing data in Tableau