Lauran Jones

Safety Awareness Training VR

I developed Safety Awareness Training VR as a short demo for
my Educational Technology class at Georgia Tech.
This application was created using Unity and SteamVR.

Healthy Heart

A Python/Django website that incorporates FHIR user
biometric lab data and Framingham Study data
to advise users of their current heart health,
and how to improve it through diet and exercise.

Sample CS KPI Dashboard

A Looker Studio Customer Support KPI Dashboard connected
to an automatic ETL pipeline of CS data from Zendesk Explore
to Google Sheets, through Google Apps Scripts triggers and code.
This Dashboard provides daily insights, trends, and KPI metrics
vital to any monitoring the progress a CS Team.
Showcases:

• Looker Studio - Dashboard
• Google Sheets - Dataset
• Google Apps Scripts, Triggers - Programming and automation
• KPI metrics - Customer Support Domain Knowledge
• Zendesk Explore - Business Systems Knowledge
• ETL Pipeline Creation - Zendesk to Google

Sample Market Analysis Dashboard

A Looker Studio Market Data Analysis Dashboard connected
to a Postgres Database. The dataset in Postgres database was webscraped
using Python and contains over 40 million public marketplace listings
with 100 datapoints per listing.
Showcases:

• Looker Studio - Dashboard
• Postgres - Dataset
• Python - Programming and automation
• Sales metrics - Retail Market Performance Domain Knowledge

Sample Spreadsheet - Fraud Risk Report

A Google Spreadsheet analyzing a smaller dataset of datapoints representing risk.
The data was randomly generated using Python, and exported to CSV.
Showcases:

• Google Sheets - Spreadsheet
• Pivot Tables
• Index Match - Data Linking Formulas (improvement on Xlookup and Vlookup)
• Python - Random data and CSV generation