Data Analysis Portfolio

Reports

  1. Hurricane Analysis

    • Summary: An analysis on tropical cyclones in the North Atlantic region. The project includes both the data preparation stage and the analysis stage of the data analysis cycle. In the preparation stage the data is cleaned by selecting the columns that will be used, specifying missing values, specifying data-types, and removing outliers. The analysis performed is in the form of statistics and data visualizations using R’s ggplot2 and dplyr packages.

    • Skills: R, ggplot2, dplyr, Data Analysis, Data Visualization

Dashboards

  1. Inaugural Speech Analysis

    • Summary: Built an interactive application through R’s Shiny package to perform a text analysis. The application allows the user to explore the most frequently used words and bigrams of the U.S. president’s inaugural speeches with the ability to remove stopwords.

    • Skills: R, Shiny, ggplot2, dplyr, Data Visualization

  2. Investment Simulator

    • Summary: Built an interactive investment application through R’s Shiny package. The application uses simulations to visualize how an investment account will grow given an initial amount and yearly contributions.

    • Skills: R, Shiny, ggplot2, dplyr, Data Visualization

  3. Savings Rate Calculator

    • Summary: A savings calculator application to compute the number of years of saving a percentage of one’s income it would take to reach a target amount given an annual income and an annual rate.

    • Skills: R, Shiny, ggplot2, dplyr, Data Visualization

SQL

  1. SQL Discussion

    • Summary: In this SQL discussion we go through examples of creating tables, joining multiple tables, and aggregation over multiple rows.