An end-to-end data analysis on a dataset containing the Top 100 Billboard songs over the last 40 years. Visualizations created using Tableau, dataset manipulated in Excel, data scraped from Spotify via their API.
Main Content
Ryan Serebro
As a recent graduate of MissionU, a highly selective Data Analytics fellowship based out of San Francisco, and a current student of Flatiron School, I am a Data Analyst looking for a new role. My expertise includes, and is not limited to, data cleaning and munging, data analysis, visualizations, and modeling.
Key Skills

MySQL
With training from instructors at MissionU, I am proficient in writing complex queries to extract and manipulate data from large databases.

Excel
During my time interning for a non-profit, I practiced the skill of Excel modeling and have an advanced understanding of all concepts in the application.

Tableau
Creating beautiful and comprehensible data visualizations has now become my favorite part of any project. Most of my experience in visualization has been using Tableau.

Python
I am proficient in the practice of Data Analysis, Cleaning and Visualizations via Jupyter Notebooks. I am in the process of perfecting Machine Learning models.

02Boeing Investment Opportunities
An end-to-end financial analysis on potential Boeing Investments for 2017 based on 2016 delivery data provided by Boeing. Excel was used for the entirety of this project, from data cleaning to analysis and visualizations.

03Codecademy Digital Marketing
A digital marketing report generated for Codecademy, using a dataset provided by Codecademy. Data analysis, and visualizations were completed in Excel.