/My_Portfolio

This is a repository that I have created to showcase skills, share projects and track my progress in Data Analytics / Data Science related topics.

Jingyi Wang - Data Analysis Portfolio

About

  • 👋Hi, I'm Jingyi! I have a solid banking background and hold a Master of Science (M.S.) degree in Business Statistics, as well as an MBA degree in Information Systems (Hofstra University).
  • 💞️I deeply appreciate the value of data analysis in my daily work, especially in formulating sales strategies, as well as evident-based management.
  • 🌱I am always motivated and eager to learn everything!
  • ⚡This is a repository that I have created to showcase skills, share projects and track my learning progress.
  • ✨HAPPY CODING!✨

Table of contents

Portfolio Projects

In this section I will list data analytics projects briefly describing the technology stack used to solve cases.

ETH and S&P 500 Clustering Analysis

Description: For this Python based project, I collected historical trading data for S&P 500 companies and ETH-USD, and filtered 10,000 twitter posts, containing the words "ETH", "Ethereum". The project includes the following steps: collecting data,explore data, modify variables, setup model, and evaluate model. My hypothesis is that companies that are highly correlated will be affected by the same possitive or negative market information, and thus they should converge in market performance. I hope to find these companies.
Code: ETH_SP500_Clustering_Code.ipynb
Presentation: My Presentation for ETH_SP500_Analysis.pdf
Report: My Report for ETH_SP500_Analysis.pdf + Further Hotelling Test in R.pdf
Skills: Data Collecting, Data Cleaning, EDA (exploratory data analysis), Time Series Processing, Clustering Analysis, Eblow Method, Social Media Analysis(text analysis, network analysis), Hypothesis Testing, Hoteling T^2 Testing, Data Visualization.
Technology: Python (urllib, ssl, pandas, numpy, datetime, sklearn, Matplotlib, R, Netlytic.
Results: Find a clear chain of industries related to blockchain computing resouces, and other interesting facts.

Study Projects

In this section I will provide links to my github repositories containing code and jupyter notebooks I created while passing online courses or was just having fun with.

Web Analytics for Business

Description: My study for a variety of topics and techniques in the area of web analytics.
Repository: The repository focuses on web data structure/contents/usage, data acquisition from web platform, transformation of unstructured web data into structured data format, analysis of web data using data mining techniques such as classification/clustering/association, sentiment analysis for business decisions, and visualization of unstructured data.---> go to repo..
Status: ∞

ACCT and Financial Reporting

Description: This repository contains the course materials and my final exam on the CVS Annual Financial Report for a 5 month ACCT and Fiancial Reporting course.
Repository: This course is a comprehensive overview of the basic financial statements and how they and other accounting information are utilized for managerial decision making in a global economy. Topics include, but are not limited to, financial reporting and analysis, profit analysis, planning and forecasting, and cost control. Environmental factors and ethical implications are integrated throughout the course.---> go to repo..
Status: Completed in Fall 2019

SQL and Database Management Systems

Description: This repository is for SQL exercises done by me while learning SQL on various platforms and courses.
Repository: Related courses include: SQL Essential Training, Database Management Systems, Advanced SQL for Query Tuning and Performance Optimization, SQL Module, SQL Bolt.Hope this repo will help you to assess my SQL skills or will be just fun for you to look through. ---> go to repo..
Status: ∞

Basic Python Code

Description: This is the basic Python code I put together, they are pieces I learned from various sources during my learning process. Repository: Topics covered: Numbers, Functions, Variable Assignments, Strings, Lists, Sorting, Dicts, Files, Regular Expressions, Utilities, Urllib, and lot more. ---> go to repo..
Status: ∞

Side Projects

Description: Side projects and various code snippets I'm having fun with.
Repository:
- JupiterLab GitHub---> go to repo..
Status: ∞

Tableau Vizzes

Description: My Tableau Public account ---> go to Tableau..
Status: ∞

Certificates [Live and Learn]

I believe that the best way to showcase skills is by doing and sharing your job done but sometimes certificates appear to be as an indirect result.✨
I gained a very systematic knowledge of statistics and analytical skills and graduated with honors with a 4.0 GPA in both my MBA degree and MS degree.
💞️ Here is a list of my transcript and my certificates:

Contacts