Mitchell Lor

Intro

Hey there! I'm Mitchell, a passionate explorer of data with a zest for uncovering insights that drive impactful decisions. My journey into the realm of analytics has been an exhilarating ride, fueled by curiosity and a drive for continuous growth.

Originally hailing from the University of Minnesota - Twin Cities with a degree in economics, my path took an unexpected turn when I embarked on a career as an Associate Educator at Cityview Elementary School. While nurturing young minds was fulfilling, I found myself yearning for a new challenge, a new frontier to conquer.

Enter data analytics. It was like discovering a hidden treasure chest buried beneath layers of information. I dove headfirst into the Google Data Analytics course on Coursera, and boy, was it a thrilling ride! Every module, every lesson, sparked a newfound excitement within me. I knew I had found my calling.

Armed with newfound knowledge and fueled by ambition, I embarked on a journey of self-discovery through personal projects, each one a testament to my growing proficiency and passion for the field.

Yet, my appetite for learning and growth remained insatiable. Recognizing the immense value of formal training, I seized the opportunity to enroll in the Data Analytics bootcamp at the University of Minnesota. What a transformative experience it has been! Through rigorous challenges and hands-on projects, I honed my skills, expanded my toolkit, and emerged a seasoned data aficionado.

As the curtains draw close on this chapter of my journey, I stand on the brink of a new adventure, brimming with excitement and anticipation. The prospect of collaborating with like-minded individuals, leveraging data to unravel complex problems, and driving meaningful change fills me with boundless enthusiasm.

To any recruiter or team out there, I bring not just technical proficiency, but a unique blend of tenacity, creativity, and a genuine passion for making a difference. I thrive in collaborative environments, where diverse perspectives converge to tackle challenges head-on.

So, here's to new beginnings, to embarking on a thrilling odyssey in the ever-evolving landscape of data analytics. I'm ready, eager, and downright ecstatic to see where this journey takes me next. Let's dive in and make some magic happen!

Click here to check out a list of my github repositories!

Projects

1. Edamam API Data Engineering
2. Covid Deaths

1. Edamam API
Data Engineering

For this project, I worked with a team to create a database for chicken recipes and their CO2 emission information. I was in charge of the ETL process and had to make requests to the API, then create a table to store the data. To do this, Python was used to create requests, and then I extracted the response body onto a list and into a dataframe. Afterwards, I loaded the data onto a SQL database using PostgreSQL. My team members then used the database I created to query and complete their analysis.

Link to the API can be found here.

Github repository can be found here.

2. Covid Deaths/Vaccinations

In this project I looked at the Covid deaths, infections, and vaccinations worldwide to find out information based on countries and continents. Microsoft SQL Server Management Studio was used to query the data. The dataset can be found below.

Link to the original dataset can be found here.
SQL querying can be found here.

Dashboard created from Tableau can be found here

Tableau Visualizations

Click on the image above, or visit the url https://public.tableau.com/app/profile/mitchell1520
to see a list of visualizations I created on Tableau Public.

Contact Info

Email: lormitchell93@gmail.com

Click on the buttons below to find my Github and/or LinkedIn

• GitHub
• LinkedIn

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';