Data Analytics Projects
Below includes the Data Analytics projects that I have compiled and executed either during my studies or for business organizations. I have uploaded all of my work pertaining to Data Analysis onto my GitHub account, as well as additional writing summarizing the work qualitatively for specific projects on Medium; links to both are included in the description.
If you wish to visit my GitHub account and repositories directly, you can find it here:
If you wish to visit my Medium profile page and articles directly, you can find it here:
Data Analysis of Etsy Marketplace (+ SWOT)
Chien-Chien
(E-Commerce Store)
My client wished to establish an online e-commerce brand, titled "Chien-Chien", and hired me to conduct a market/data analysis pertaining to the niche target audience they seek to capture; an additional SWOT Analysis was also compiled for the client.
Programming in Python
in Data Science
UBC Certificate (Course)
This is my final project for the course in UBC Extended Learning's "Key Capabilities of Data Science." The analysis is centered around past theatrical releases from Disney Studio and all of its relevant information, and its thesis is focused on finding the best box office earners in different categories, such as genre/year/director.
Data Visualization
UBC Certificate (Course)
This is my final project for the course in UBC Extended Learning's "Key Capabilities for Data Science." The final output includes an interactive dashboard with numerous visualizations from the given data set featuring trees on the streets of Vancouver.
Intro to Machine Learning
UBC Certificate (Course)
This is my final project for the course in UBC Extended Learning's "Key Capabilities for Data Science." The best ML model features a RandomForestClassifier with a balanced class weight that can predict the fat level of any cheese products from the given data with accuracy.
Relational Database & SQL
BCIT - COMP 1630 (Course)
This is the Term Project for said course offered by BCIT. The two files attached in my GitHub repository include the SQL files to generate the database and my written query to wrangle and extrapolate the required answers; the latter demonstrates my ability of database construction and manipulation in SQL.
Data Modelling and BI
BCIT - OPMT 7750 (Course)
This is my final project for the BCIT course "OPMT 7750 - Data Modelling and BI." This project revolves around retooling the 2019-2020 NBA Lakers team roster using data analytics, through Excel, and presenting the findings through Power BI's data visualization. Please visit my links below, Medium and GitHub, for more info.
Quant. Methods for Managers
BCIT - OPMT 5515 (Course)
This is my final project for the BCIT course "OPMT 5515 - Quantitative Methods for Managers." This project revolves around assessing the correlations between different survey results from BC School Satisfaction Survey 2012-2013 using
Excel and r value from regression analysis. Please visit my GitHub repository for more info.
