Digital Portfolio

Graduate Studies Projects

## [Walmart Sales Analysis (Mode Analytics)](https://app.mode.com/robert04vargas/reports/6c4afec2423b) Walmart Sales Analysis (Mode Analytics) - General analysis of historical sales data for 45 Walmart stores located in different regions. - Visuals created using SQL via the Mode Analytics Platform. - Queries are outlined within the project.

Work Projects

## [Mobile Game A/B Testing](https://public.tableau.com/app/profile/robert.vargas7196/viz/MobileGameABTesting-CookieCats/MobileGamesABTesting-CookieCats) Mobile Game A/B Testing

Other Projects and Core Competencies

## [Exploratory Analysis and Predictive Model Using Game Data from FIFA 2020](https://rpubs.com/Robato_95/873916) * I analyzed data that contains 100+ attributes for over 18,000 players on FIFA 20. * After exploring the data, I created a multiple linear regression model to predict player speed using R programming.

Supermarket Quarter 3 Sales (EDA)

An exploratory data analysis of Q3 sales from a fictional supermarket.
Illustrating findings using important metrics, KPIs, and graphs.
Visuals created using R Flexboard.

Analyzing Monthly Returns of the SP500

I’ve collected approximately 20 years of monthly closing data to analyze the returns of $SPY using R programming.
Using important metrics, I conclude if investing in $SPY is a smart investment.

Premier League Exploratory Analysis

An exploratory analysis of data collected between the 2015-16 and the 2018-19 season.
Analyzed trends related to demographics, market values, and sport metrics using R programming.

1990s California Housing Exploratory Analysis and Predictive Model

The data contains information from the 1990 California census and pertains to the houses found in a given California district (based on lat/long coordinates) and key summary stats about them based on the census.
In order to create and test a predictive model using R programming, I extracted a sample of 500 districts to use as our test object.

Hotel Booking Behavior

An analysis of hotel booking behavior using Tableau
The project is focused mainly on identifying trends, most successful revenue channels, and customer behavior.

Predicting Avocado Prices

Data for avocado prices beginning in 2015 and contains various details related to the logistics of avocados shipped for each week up until the end of Q1 2018.

Using the following Python packages, I explored the logistic details in the data and use this information to create a multiple linear regression model to predict avocado prices

import os
import pandas as pd
import numpy as np
from matplotlib import pyplot as plt
import sklearn
from sklearn import *
from sklearn.model_selection import train_test_split
from sklearn.metrics import *

Investigating Runner’s Data

Investigating the relationship between a runner’s weight and their mile time using R programming.

Stanford Open Policing Project

Data includes stop data from Rhode Island, covering the period from 2005 through 2015.
Analyzed the data using R programming and answered some inspirational questions from the Kaggle prompt.

Econometric Analysis Using Credit Card Data

Analysis based on a book called “Econmetric Analysis” by William Greene.
Using credit card data, I created a logistic regression model to predict whether cardholders in a test sample got approved or denied.

Analyzing Portland Housing Data

An exploratory data analysis of real estate in the Portland area using Tableau.
I analyze the years these houses were built, the average house price by year built, and the average price per elementary school district.

Predicting Shoe Sizes Experiment

Taking data uploaded by Sebastian Sauer and using it to create a model to predict shoe sizes.

Are Heights Normally Distributed?

Data analyzed is heights of fathers and their sons, based on an experiment by Karl Pearson in 1900.
Using this data I analyzed the distribution of the observed heights using R programming.
I hypothesized that the differences in the model would follow a normal distribution as well.

Benford Analysis - Accounts Payable

As an auditor, this concept really connected to me and I conducted a fraud procedure using R code.

Analyzing My Financial Portfolio

A visual respresentation of my trading portfolio using R programming graphs.

Guitar Tuner

A simple guitar tuner that I created using Python as a final project for one of my introduction to programming classes.
This is only a software project so no gadgets needed.

Weather App

A GUI that allows the user to enter any city in the world and retrieve the current weather information using Python.

Data Entry Automation Project

This was a project to practice using the automation tools provided by the pyautogui and the webbrowser packages.
Using these packages I created code that would fill out the following form based on information for each member of my family.

import pyautogui as pag
import webbrowser as wb

What Should Your Mile Time Be?

A mile pace will be calculated based on the user’s age, gender, and fitness level using Python.
The data is based on 10,000 runners and the information was collected by Healthline in 2010.
Works for age ranges between 16 and 99 years old.

Coachella Music Festival Sentiment Analysis

Analyzing Twitter activity related to the performances during the Coachella Music festival.

US Superstore Financial Analysis

Sales data from a US superstore for the period 2014 through 2018.
Through metrics I explore the company’s successes and failures using R programming.
Using the findings, I explore recomendations to help reach the goal of a 15% gross profit margin over the next four years.