Below are some examples of my work in SQL, R, and Tableau.
Pizza Restaurant Sales Analysis
Tools: SQL, PostgreSQL, and Tableau
Tools: SQL, PostgreSQL, and Visual Studio Code
Cyclistic Bike Share Company Analysis
Purpose: Assist the marketing team with determining rider rental behavior over the specified year.
Tools: R
Interstate Traffic Volume Dashboard
Purpose: Analyze local traffic historical monthly volumes, holiday travel volume, and weather impact to determine peak traffic contributors.
Tools: Google BigQuery and Tableau
Traffic Volume Dashboard Link (Tableau Public)
Google Fiber Repeat Caller Dashboard
Purpose: Create a dashboard for the data team and executive team to show the patterns of repeat caller behavior after new customer service installation.
Tools: Google BigQuery and Tableau
Google Fiber Repeat Caller Dashboard Link (Tableau Public)
The SQL script below is one example of a query that replaces text values and converts data types from text to integer. This was part of the data cleaning required before importing the dataset into Tableau.
Machine Vibration Trend Analysis
Purpose: Develop a statistical methodology to determine the vibration levels for a given machine that indicate degraded health.
Tools: R
Ray's Analytics 