An Overview of my Skills
All pictures on this page are hyperlinks to a more detailed page about that project / subject
Personal Project: Strength Training Analysis with Tableau, Excel Macros & SQL
R Language & Kaggle Projects
Interactive Tableau dashboard built using my own personal workout data over a year. Click on the picture for more information on my Excel & Tableau knowledge as well as information about this independent project
A few screen shots of the R Langauge code I have produced. Click for more detailed information.
SQL & Business Analysis Projects
Screen shots of some of the SQL code I made in several project. Click for details on my SQL knowledge and projects I’ve done.
Python Projects
Some of the StrataScratch Python tasks I have completed. Working on more in depth Python projects at the moment, more content to come, click here for more info.
Tableau Projects
Screen shot of some of the SQL code I made in this project. Click for details on my SQL knowledge and this project
About Me
Click here to get to know more about me as a person~
Analyst Work Experience:
- Financial Data Analyst & Advisor: Create Cafe (Da Nang, Vietnam) August 2023 – Present
- Create and manage custom income statement and balance sheet in Google Sheets
- Automate the importing of bank statements and POS data, merge together
- Create & present visualizations analyzing trends based on time of year, product sales types, expenses, etc
- Narrow down which fields should be focused on to help increase overall profit, work with stakeholder to come up with actionable plans appropriate for their overall business plan
- Marketing Analyst: Revenue Boost (Da Nang, Vietnam) October 2023 – January 2024
- Compile & analyze customer surveys for trends in complaints / compliments
- Find actionable responses to increase customer happiness and retention rate
Skills
Certificates
- Excel & Google Sheets (intermediate – advanced):
- Data visualization
- Data cleaning
- Statistical analyses
- Creation, editing & data entry of complex spreadsheets
- Create, edit and run complex macros
- Basic management of security and sharing of data
- Tableau (intermediate – advanced):
- Create complex visualizations to explore, explain, and exhibit data
- Have multiple sheets with with inter-filterable fields
- Create complex live data dashboards
- Create complex fixed data reports
- Simplify complex data into easy to understand visualizations
- SQL (intermediate – advanced):
- Knowledge / experience with:
- BigQuery
- Google Standard SQL
- S3Schools SQL Tryit Editor
- Can query to:
- Retrieve Data
- Manipulate Data
- Join Data
- Analyze Data
- Knowledge / experience with:
- R Language (intermediate):
- Statistical analyses & data visualization
- Data cleaning and preparation
- R package experience:
- dplyr
- ggplot2
- tidyr
- more
- Python (intermediate):
- Experience using libraries:
- Pandas
- Matplotlib
- NumPy
- SciPy
- Seaborn
- Statsmodels
- Data visualization
- Basic process automation
- Statistical analyses
- Regression modeling
- Machine learning (my first ML project currently underway)
- Experience using libraries:
- APIs (basic):
- Basic knowledge of APIs
- Currently working on a personal project utilizing APIs.
- In the process of learning how to utilize APIs effectively
- Social skills
- Lots of experience and training in:
- Public speaking
- Professional communication practices
- Giving presentations
- Able to communicate professionally and personably with coworkers, stakeholders, clients, and managers in person, via text, email, etc.
- Lots of experience and training in:
- Knowledge in specific fields:
- Finance / Accounting
- Fitness
- Education
- Gaming
- Outdoors / Adventure
- Google Data Analytics Professional Certificate including:
- Foundations: Data, Data Everywhere (18 hours)
- Ask Questions to Make Data-Driven Questions (21 hours)
- Process Data from Dirty to Clean (26 hours)
- Prepare Data for Exploration (25 hours)
- Analyze Data to Answer Questions (32 hours)
- Data Analysis with R Programming (34 hours)
- Share Data Through the Art of Visualization (25 hours)
- Google Data Analytics Capstone: Complete a Case Study (11 hrs)
- Application of Data Analysis in Business with R Programming (1 hour)
- Data Analysis with SQL: Inform a Business Decision (1 hour)
- Introduction to Tableau (in progress)
- Google Advanced Data Analytics including: (in progress)
- Foundations of Data Science (25 hours)
- Get Started With Python (30 hours)
- Go Beyond the Numbers: Translate Data into Insights (32 hours)
- The Power of Statistics (37 hours)
- SQL for Data Science (UC Davis) (15 hours)
- Being really cool and fun to work with (36 years)
Personal Note About My Overall Skill / Experience
I must admit I am not the most experienced nor knowledgeable analyst in the world. However with all the tools available out there, I have been able to work through many problems I would never have been able to figure out on my own. Between Kaggle, GitHub, ChatGPT, Google searches, Stack Overflow, and other publicly available sources, I believe that just about any issue can be overcome with a little perseverance and open mindedness. Beyond that I have a personal network of data and IT professionals that I also find quite helpful for some of my issues.
I am committed to Data Analytics and passionate about what I do. I am a bit of a perfectionist, which sometimes can be inhibiting. But it can also be a strength. When I care about something I care about doing it right, a lesson learned the hard way as a kid growing up with a step-father with a military and farm boy background, also one of the hardest working individuals I’ve ever met.
I would particularly like to work in an industry I care about such as travel, outdoor / adventure, gaming, finance, education, or something that helps the world (social wellness programs, combat climate change, etc.). Preferably a role where I can learn more and utilize some visualization tools, as I do really enjoy making beautiful and useful visualizations. I also enjoy learning coding and languages in general. I am conversational in Korean and Spanish, and currently learning Vietnamese, which is definitely the most difficult language I’ve tried to learn. As with learning any language, the process is usually difficult, but very rewarding when you see the results. As for coding languages I’m pretty comfortable with SQL and focusing on progressing my Python skills now. I practice both daily.
For me, my proudest piece of work I have created as a data analyst is my Strength Sync Dashboard on Tableau Public. I am in the process of turning that into a website (and later app) to allow users to input their data directly or plug-in their workout data via various apps and my site will scrape their data, input and clean it, and then give them their own personal dashboard. Check out more info on my page dedicated to it here.