My Toolbox:

R/R-Studio:

A FREE and open source IDE for the R programming language for statistical computing and graphics. R was designed by Robert Gentlemen in 1993 and R Studio was founded by JJ Allaire in 2011 and maintained by Hadley Wickham.

R and its libraries support statistical programming and graphing techniques. These packages support the theory and ideologies in statistics including but not limited to: linear and non-linear modeling, classical Bayesian statistical tests, time-series analysis, classification, regression, clustering, and visualization.

Using R my bread a butter is data cleansing and data munging/wrangling. By utilizing R as my analysis AND ETL tool, I am able to write single scripts to complete entire analysis and tasks in one place. This simplicity allows for easy debugging and replication. Some of my best work has been done using the powerful packages maintained for R.

Use Case: Web scrape daily statistics from a baseball website at the player or team aggregation using Rvest. Manipulate the data to tell a story using dplyr and reshape. Build visualizations and a RShiny App using Shiny and ggplot2. Automate this process daily using Task Scheduler for Windows.

Other Highlights about R:

• Using rvest, a package in R I am able to webscrape data from ANY website on the internet using CSS language.

• I utilize R Shiny. R Shiny is an application builder that allows for beautiful app design and visualization interaction.

• RMarkdown, phenomenal report generation package.

• Favorite R Packages: tidyverse packages, ggplot2, tidymodels, rvest, kableExtra, gt, RODBC

Alteryx Designer:

Python with Jupyter Notebook:

Tableau Server, Tableau Desktop, and Tableau Prep Builder:

• Tableau Server allows users to show visualizations in real time with live or static data connections. Users can apply filters, parameters, visualizations in tooltips, and much more in a web browser hosted by Tableau Server.

• Tableau Desktop brings the power of visualization to the analyst. This application is incredibly robust, has tremendous support, and is the industry leading drag and drop visualization tool.

• Tableau Prep Builder is still a beta tool, however I strongly encourage those interested in Exploratory Data Analysis to utilize this application. Tableau prep allows you to combine, munge, alter, manipulate, export your data with the standards required for data analysis without knowing how to write code. Great for early data science learners! also is Q.A.D. for data scientists!

Microsoft Access and Microsoft Excel:

SQL:

• Authored SQL Query Generation and Database Management using Microsoft SQL Server IDE and Snowflake IDE.

DataRobot:

• Automated Machine Learning with custom parameter tuning, feature engineering, data leakage detection, and much more!

Power BI:

• Using Power Query M Language Editor, Using Power BI Dashboarding capabilities in DAX. Power BI Server Administration and implemented best practices.

My Projects

These are some of my favorite pieces of work that I am allowed to share