Lettuce Growth Conditions (Google Sheets)

I analyzed the relationships between temperature, humidity, and pH levels for lettuce growth and showed the correlations in the form of line charts. The results show that all 3 variables remained consistent throughout the study. Credit to JJAY FABOR on Kaggle for the data set.

Monthly Sales (Microsoft Excel)

This project involved looking for trends in the amount of sales from month to month. This revealed a seasonal trend in the increase and decrease of sales, allowing the company to know when to stock up on materials for the busy season.

Demo Video: Spreadsheet Calculations (Google Sheets)

For this project, I used Loom to record a video presentation of a project that I completed using spreadsheet calculations.

Call Center Data (Google Sheets)

I analyzed a month's worth of data from a call center. The map showed which 3 states the majority of callers were located in, allowing for measures to reduce the number of callers in those states, thereby saving on labor cost.

Data Cleaning (SQL)

In this project, I uploaded a CSV file to BigQuery that contained car info, and used SQL queries to clean the data, trimming blank spaces, filling in nulls with the appropriate information, deleting faulty rows, and ensuring that no other data cleaning was necessary.

Data Cleaning (Google Sheets)

1. Widened columns to see all data. 2. Bolded the column headers. 3. Froze the header row. 4. Deleted 3 duplicate rows using "Remove duplicates." 5. Used COUNTIF to find all ratings outside the range of 1-5 stars. 6. Corrected all invalid star ratings. 7. Split the lat-long column into 2 columns.

CO2 Emissions Map (Tableau)

I imported several spreadsheets to Tableau Public and created a map and line chart showing the CO2 emissions per country and the CO2 emissions per region over time. I created a slideshow in Google Slides and used Screencastify to record my voice and my screen as I presented my findings.

Scatter plot (RStudio)

I created a scatter plot in RStudio to show how the carat weight of a diamond compares to its price. I created one scatter plot for each cut of diamond, using one line of code.

Bellabeat Capstone Project (RStudio)

I imported several csv files into R, then cleaned and analyzed them in order to extract insights and trends, leading me to have recommendations of targeted marketing strategies for the CEO of the company.

TCS Virtual Internship - Data Visualization (Tableau)

In this project, I went through the process of anticipating questions of the CEO and CMO, downloading and cleaning and dataset of sales information, and importing that dataset into Tableau to create visualizations, revealing seasonal trends and the need for increased marketing in some areas.