Portfolio
Written Work Samples
Professional Persona Executive Summary
This document shows the type of person, team member, and communicator I am. In this summary, I discuss how my core values shape the person I am today, the way I draw from all 4 styles of communicator, some of my preferences in a team setting, and what I have learned over the last year. In the end, I also discuss how each of these things will affect my future, both professionally and socially.
Industry Report
This report analyzes the industry of fitness equipment and how this industry is in the process of shifting from fitness centers such as gyms to an at-home experience. In this report, I discuss some of the industry's major products and services, the market share concentration, and some financial trends.
Apple Financial Analysis
This project analyzes Apple's financials using their 2021 10-K report. In this document, I look at the way Apple sets up their financial statements, such as the way they depreciate PP&E and how they recognize revenue. I also analyze Apple's trend in revenue and net income by using vertical and horizontal analyses, as well as through the usage of current, quick, and profit ratios.
Visual Design Samples
Company Narrative Analysis
The company narrative analysis was the first of 3 presentations my team and I had to present in our business communication class. As a team, we researched our company Apple and identified a potential communication issue, where the way Apple wishes to be seen and the way they are actually perceived by the public are not aligned. All of us worked on the research, but my slide is the one titled "Communication Issue."
Final Communication Plan
This was my team's final presentation in which we produced a recommendation as to how Apple could get rid of their communication issue. In the time between the first presentation and this one, we identified a more relevant communication issue, so the recommendations made in this presentation might not align with the problem identified in the company narrative analysis presentation. For this presentation, I worked on the current Apple ad, our team's mock ad, budget, and timeline slides.
Technology Samples
Tableau
This is a visualization I created on Tableau to show how fines are spread out across NFL players by position. From the bar chart on the left, you can see that outside linebackers are the most fined position, and the confidence intervals on the right show the distribution of fines among 5 positions.
Excel
This is an example of a pivot table I created on Excel to show how grades were spread out across different versions, majors, grade levels, and states. Before creating the pivot table, I aligned the student ID numbers using a VLOOKUP formula.
Ethan Williams
McClelland Hall, University of Arizona
1130 E Helen St, Tucson, AZ 85721
Email: ethan.a.williams@gmail.com
Phone: (602) 400-8675