Brian Webb
The Analyst Portfolio

Data Analyst Skilled in SQL, Tableau, and Excel @BrianTheAnalyst

Data Cleaning in SQL

Imported Excel dataset on Nashville Tennessee housing statistics in Microsoft SQL Server. Cleaned the dataset and prepared it for future analysis.

Data Exploration in SQL

Cleaned and analyzed a dataset on COVID statistics in Microsoft SQL Server, creating views with subsets of the data to analyze specific variables. Imported views to Microsoft Excel to clean and format data for use in visualizations.

Tableau Projects

Tableau Data Visualization Dashboards. Created various visuals in Tableau, including bar charts, line graphs, and a map chart to display data conclusions, then compiled them into a dashboard.

Excel Dashboard

Cleaned and analyzed a dataset on bike buyer customers. Imported Excel data sheet with hundreds of entries into Excel, then cleaned and formatted data for visualization. Created various visuals including bar charts, and line graphs to display data conclusions, then compiled them into a dashboard.

Google Capstone Project

Imported 12 excel datasheets with millions of entries into R, then used tidyr package to clean the datasets and prepare them for analysis. Joined all of the datasets together, created subsets of the data, and converted each attribute to the proper data type before performing analysis to find differences between members and casual customers.

Location


Sequim, WA 98382

Phone

(719) 821-1946

Email

brianwebb.da@gmail.com

Social