Data Science Projects

Data Science Bootcamp 7 with AdToy DataRockie

In data science bootcamp with 6 months intensive program, we've learnt 10 sprints (on-going) which are in-demand skills to be an Entry-level Data Analyst. Therefore, all my consistent homework and projects are as follows:

1. Spreadsheet

• Dynamic Query
• Converting TH to ENG Date
• ID Card Parser

2. Database SQL

A simple restaurant database created with SQL consists of 5 dimension tables and 1 fact table, as well as an ER-diagram and some queries for data analysis. This project is published in Replit, which is a powerful platform for creating and sharing software. I also create the ER-diagram of my restaurant database to show the relationships between tables available in this database.

• My_Restaurant.sql
• Source Code
• ER-diagram

3. R Programming

The Rule-based Chatbot is created to assist users in choosing Thai food 🍽️ and playing an interactive rock-paper-scissors game 🕹️. This project is created with R and published in Replit, with an objective to manage input data using control flow and function to provide pre-defined replies.

• Mel Chatbot.r 🐻
• Source Code

4. Data Transformation with R

Using the rvest package to scrape data from two different web page (IMDb & VLR.gg), along with regular expression and dplyr package to transform it into usable format.

• Report of Data Transformation and Web Scraping
• Source Code

5. Data Visualization with R

A report with 5 visualization from diamonds dataset, using ggplot2 to explore this dataset and create R Markdown document. Note that diamonds is a built-in dataset in ggplot2 library that containing the prices and other attributes of almost 54,000 round cut diamonds.

• Insightful Diamonds Report with Data Visualization
• Source Code

6. Statistics

7. Machine Learning for Data Analyst

8. Intro to Python Programming

Use Python to create a interactive chatbot for pizza ordering and play rock-paper-scissors, as well as OOP (Object Oriented Programming) knowledge to create an ATM class with five methods: deposit, transfer, withdrawn, update password, and summary bank account. Moreover, the final project in exploring and analyzing sales data with Pandas is also included below.

• Homework Python 101 with OOP
• Sales Data Analysis with Pandas

9. Essential Python for Data Science

Use request to get data from the Cocktail Database🍹 which is a public API and export to .csv file. Along with use sklearn algorithms to build 3 machine learning models which are LinearRegression, RandomForest and DecisionTree.

• Homework of Essential Python Class

10. Dashboard

Use SQL to query essential information from Summer Products & Sales Performance, then use Looker Studio and Tableau Public to generate a report and dashboard.

• Raw Data & Query Data
• Merchants.sql
• Merchants Performance Dashboard - Tableau Public
• Merchants Report on Wish Platform - Looker Studio

Verified Batch: