🔔 Projects-Porfolio:

Welcome to my Project guide, where you can take a look at my projects and study documents Welcome to my project portfolio! Here, I summarize the projects I have undertaken and the diverse sources I have utilized within the field of data.

Projects:

1) SQL projects:

Project	Tools	Project Description
Danny's Restaurant	MySQL: Join Tables, GroupBy, Window Function, Common Table Expression, Subquery	Write SQL codes to retrieve information related to restaunrant customers behaviour such as customers visiting patterns, customer spending, most frequent food ordered...
Data Mart	MySQL: Temporary Table, Date & Time Function, Generate Series Function, Common Table Expression	Using EDA method to quantify the impact of the change on the sales performance for Data Mart and it’s separate business areas.

2) Python Projects:

Project	Purpose	Library	Project Description
Web Scrapping: Online BookStore Data	Web Scrapping	Beautiful Soup, Request	By leveraging web scraping techniques, I was able to automate the process of extracting book details from http link, facilitating further analysis and exploration of the mystery book collection.
Data Wrangling & EDA projects	Gaining insights, understanding patterns, and discovering key characteristics within the data.	Pandas, Matplotlib, Seaborn, Plotly, Dataprep, Autoviz, Profiling	I showcase 3 distinct projects that apply EDA techniques to serve diverse business objectives: 📙Turnover trends and reasons of employee's turnover in different departments; 📙 Identify the highest revenue and profit products categorized by product categories and customer segments in a Retail supermarket; 📙 Analyzing of the financial performance exhibited by 500 S&P companies.

3) Machine Learning Projects:

Project	Library	Project Description
Machine Learning Projects on Classification	Pandas, Sklearn, Imblearn, Seaborn	I will showcase projects that employ diverse Classification Algorithms in Machine Learning to address various business problems, including: ⚾ Decision Tree Algorithm:Predict the likelihood of individuals developing diabetes; ⚾ Support Vector Classifier: Classifying species of Iris flowers; ⚾ Logistic Regression and SMOTE Model: Detecting credit fraud; ⚾ Navie Bayes Classifier: Classifying comments of viewers from the IMDB website as Negative or Positive comments.
Forecast Store's Sales: Times Series Model	Pandas, Numpy, Statsmodels, Pylab, Smdarima	Using ARIMA and SARIMA time series models, I forecasted the future sales of a superstore by leveraging historical data spanning four years, from 2015 to 2018.
Technology Similarity Analysis: Japanese Pharma Firms Case Study	Numpy, Pandas, Scipy.spatial, IPython.display	This project utilizes the patent information (subclass IPC) to understand the similarity in the technology of different pharmaceutical companies

4) Natural Language Processing Projects:

Project	Library	Project Description
Japanese Language NLP project	sklearn, gensim, glob, yellowbrick, string, MeCab, pyLDAvis	I scrapped over 7000 Japanese-language reviews from an online platform and transformed them into a Pandas DataFrame. I performed preprocessing and tokenization of the Japanese text using specialized libraries, visualized word embeddings, and conducted topic modeling to classify articles/reviews into categories. Additionally, I selected an arbitrary article and explored articles with similar content. Finally, I extracted feature phrases for each news category.
Predict Stock Market Price Using Sentiment Analysis	TextBlob, re, vaderSentiment, sklearn, pandas	This project aims to predict the direction (increase or decrease) of a company's stock price by analyzing top news headlines.

5) Tableau Projects:

Project	Project Description
Automobile Industry Overview	Comparison of car prices among automotive producers.
The Starup Quadrant	Interactive Dashboard of 1000 potentially startups in term of Growth pontential, Revenue and Expense.
Twitter Dashboard	Design an interactive KPI dashboard for social media including information such aswhat are they tweeting, when are they tweeting and how much media engagement and interaction from users tweets are getting.

6) Excel Projects:

Project	Tools	Project Description
Call Center Analysis	Excel: If condition, Condition Formating Function, Descriptive Statistic Pie Chart, Bar Chart, Line Chart	Conduct a thorough data exploration to identify underperforming employees in a call center, investigate the underlying reasons behind their performance, and propose targeted solutions to enhance productivity for each team.

7) ChatGPT:

Chat GPT engineer instruction