Mark Webster
Portfolio

Data Analyst skilled in Excel, SQL, Python, and Tableau.

HR Employee Attrition
Statistical Analysis

Ran t-tests to determine the statistical significance of the age and income of employees.
Created visualizations in Python and presented data in PowerPoint to highlight specific demographics that were more prone to attrition.

‎ ‎ ‎ Project folder‎ ‎ ‎

Jupyter Notebook

House Pricing Factors
Statistical Analysis

Developed a dashboard to assist shareholders within an investment bank in determining factors that drive housing prices and how they should allocate dollars earmarked for investment into mortgage-backed securities.
Dashboard data was supported through t-tests run on housing price factors showing statistical significance.

View Project

Lariat Rent-A-Car
Buisiness Analysis

Examined and cleaned historical sales data using Excel (VLookUp and pivot tables).
Completed exploratory data analysis to identify strategic scenarios to increase revenue.
Presented models that showcased an increase of over $450,000 in profits, while lowering or maintaining operational costs.

View Project