Sarah Mangrum

Logo

Mammographer/Radiologic Technologist turned Data-Driven Healthcare Professional.
Animal Enthusiast. TV/Movie Junkie. Continuous Learner.
I love taking on new challenges and enjoy helping others.
Seeking my first Data Analyst role.

View My LinkedIn Profile

View My GitHub Profile

Welcome to My Portfolio


CLICK IMAGE for LINKEDIN PROFILE


Learn About My Projects


Marketing Analysis with Excel-CLICK HERE

Using Excel, analyzed 2000+ rows of customer behavior from an iFood dataset to evaluate campaign success levels identifying key insights of the customer population and enabling improved targeting of marketing funds

Key Skills: Data Cleaning, Filtering, Sorting, Data Aggregation, Formulas, VLOOKUP, Pivot Tables, and Data Visualization


Education Analysis with Tableau-CLICK HERE

Using Tableau, created interactive dashboard from Massachusetts Department of Education dataset identifying key performance metrics for 1800+ Massachusetts schools allowing at-a-glance viewing and understanding of the entire program

Key Skills: Connecting to Data, Parameters, Charts and Graphs, Metrics/KPI’s, Dashboard


The World Bank: An Analysis of Finances Around the Globe-CLICK HERE

Using SQL, conducted comprehensive financial analysis for the World Bank determining the financial and accounting landscape across the globe

Key Skills: ✅ SELECT* ✅ FROM table_name ✅ LIMIT ✅ AS ✅ WHERE ✅ COUNT ✅ GROUP BY ✅ ORDER BY ✅ MIN/MAX ✅ SUM ✅ AVG ✅ AND/OR/NOT


Healthcare Analysis with SQL-CLICK HERE

Using SQL, explored 100,000+ rows of patient healthcare data, assessing key factors like hospital equality and duration of hospital stay

Key Skills: ✅ JOIN ✅ UNION ✅ CASE WHEN ✅ HAVING ✅ DISTINCT ✅ WINDOW FUNCTION ✅ RANKING ✅ TEXT ✅ Dates ✅ WITH (CTE’s) ✅ CAST ✅ HISTOGRAMS ✅ ALTER TABLE ✅ MODIFY COLUMN CONCAT ✅ REPLACE ✅ ROUND ✅ PARTITION BY


[Sports Analysis with Tableau-Coming Soon]

Using Tableau, designed a custom dashboard to explain the 2021 NBA season patterns and trends with KPI’s, bar charts, scatter plots, heatmaps, and more.

Key Skills:


[Python Manufacturing Project-Coming Soon]

Using Python, performed exploratory analysis to troubleshoot possible manufacturing issues with Pandas, Numpy, and Matplotlib

Key Skills:


[Employee Attrition Rate Analysis with Python-Coming Soon]

Woz U DataScience Bootcamp Capstone Project

Key Skills:


[R People Analytics Project-Coming Soon]

Using R, implemented statistics and machine learning to identify what factors led to employees leaving the company

Key Skills:


[Data Analytics Accelerator Capstone Project-Coming Soon]

Key Skills:


More About Me


About Me

My Projects


LinkedIn

Tableau

Resume