Aliyah Stephens
Provo, Utah, USA

Data Analyst

_________________________________________________________________

Skills

  • Excel

  • SQL

  • Tableau

  • R

  • Python

  • Communication

  • Teamwork

  • Customer Service

  • Problem Solving

_________________________________________________________________

Data Projects

DoorDash Marketing Project (Excel)

Utilized VLOOKUP, Pivot Tables, Scatter Plots, & Bar Charts to analyze 2,000+ rows of data to provide insight on customer spending habits.

_________________________________________________________________

Evaluating School Success Project (Tableau)

Analyzed 1,800+ schools to create an interactive dashboard to explain trends in academic success.

_________________________________________________________________

Financial Analysis of World Bank Loans (SQL)

Used SQL clauses to analyze 1.2M bank transactions to provide insight for the World back on loans from different countries.

_________________________________________________________________

Hospital Healthcare Project
(SQL)

Used SQL clauses to analyze over 101,000 rows and 50 columns of data. Used JOIN, HAVING, CASE WHEN and more.

_________________________________________________________________

Basketball Case Study
(Tableau)

Analyzed data of 500+ players. Used tableau to create visuals of players performance in the season.

_________________________________________________________________

Iron Mining Project
(Python)

Analyzed data with 730k + rows of data. Used Python to clean, analyze, and create meaningful visuals.

_________________________________________________________________

People Analytics
(R)

Analyzed data 1400+ employees. Used R to create visuals and statistic based findings.

_________________________________________________________________

Food Impact
(Tableau)

Analyzed data about 150+ rows of data. Created visuals on tableau to create data driven insights about the food we eat.

_________________________________________________________________

_________________________________________________________________

About Me

Hi I'm Aliyah, welcome to my portfolio! I am a detail-oriented, result-driven data analyst with a passion for finding creative ways to present information that help business make better data driven decisions.My technical skills include proficiency in:✧ Excel
✩ SQL
✩ Tableau
✩ R
✩ Python
My experience in the service industry has allowed me to develop:✩ Exceptional communication capability
✩ A strong foundation in problem-solving
✩ Attention to detail
✩ Managing multiple tasks under pressure
When I am not working you can find me at the movies with a popcorn and drink, taking long walks with a good podcast (especially at the Beach/ Botanical Garden), or reading a book trying to be as still as possible because my cat has fallen asleep on my lap. I enjoy traveling to new cities, my favorite is NYC! I love going to concerts to see my favorite artist. .I am excited to bring my analytic mindset, eagerness to learn, and adaptability to a forward thinking organization. I am currently seeking the opportunity to work as an entry-level data analyst where I can continue to learn and grow in the field and help business's work smarter not harder.Lets connect, I would love to discuss how I can be an added asset to your team!

_________________________________________________________________