PROJECTS AND ASSIGNMENT
Key projects and assignment for my post graduate program in data analytics along with programs used for each project/assignment.
PUBLIC SENTIMENT AROUND AIRLINE INDUSTRY
Machine Learning, Python, NVivo
For this research paper, my group and I used python to collect and analyze Twitter data. The purpose of this research paper was to analyze public sentiment around the airline industry during the Covid-19 pandemic. We used the data collected along with machine learning to draw on conclusion on how the airline industry can increase public sentiment during the pandemic
VARIOUS EXCEL ASSIGNMENTS
Excel, Pivot tabels
During my postgraduate program, I have learned intermediate to advance uses of excel. I've expanded my knowledge of pivot tables, what-if analysis, and how to properly format and present excel sheets. Listed below are a few assignments showing my excel skills learned through this program.
MALAWI BANK ASSIGNMENT
SAS, Power BI and Excel
For this term project, my group and I had to analyze a data set for the Malawi national bank. We used SAS code and excel to run our analysis and understand our variables. Power BI was used to format and present all the data collect and analyzed. Using SAS we filter and analyze the data set to present recommendations to Malawi National bank to improve their business flow. Below is a copy of our written report
MARKHAM MUSEUM CAPSTONE PROJECT
Machine Learning, Python, NVivo
For my capstone project, my group and I worked alongside the ROM to understand public sentiment regarding digitalization and the technological shift of museums. Using the data collected along with machine learning we created a research report for how digitalization can be used to improve and enhance the Markham Museum experience.
MICROSOFT ACCESS MIDTERM
Access, SQL and Relationship Databases
To display my understanding of relational databases, access, and SQL, my midterm assignment was to use an online application form to create our database. Included in the access databases are forms and SQL queries. Provide below is the entity-relationship document, please reach out to me to view the access database with SQL coding.
GAMING INDUSTRY COMAPRE TO S&P500
Python, Excel, Research,
For an individual project, I create an equal weighted portfolio of 5 gaming stocking and compared it to the S&P 500 (SPY). This paper will test if a 100% US gaming portfolio can beat the SPY. Additionally, if we can expect similar returns in a 100% Canadian portfolio. All data gathered from this report was from Yahoo Finance.