CLICK IMAGE for LINKEDIN PROFILE
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
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
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
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
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:
Using Python, performed exploratory analysis to troubleshoot possible manufacturing issues with Pandas, Numpy, and Matplotlib
Key Skills:
Key Skills:
Using R, implemented statistics and machine learning to identify what factors led to employees leaving the company
Key Skills:
Key Skills:
- Marketing Analysis with Excel
- Education Analysis with Tableau
- Finance Analysis with SQL
- Healthcare Analysis with SQL