BUZZ-LIGHT-YEARS-VENDORS-ANALYTICS.

● Utilized TABLEAU to analyze 99,057 customers and their vendor locations that have yet to complete the repair on their Buzz Light Years; for use in determining where to send the repair trucks first. ● Implemented UNIONS and JOINs to comb through all the datasets together and visualizing.

GUOHOZUG-BIKES-ANALYSIS.

● Transformed and processed client’s data by using SQL in SQL Server Management Studio using JOINS and QUERIES to ensure data completeness, cleaning, formatting and validity. ● Created a dashboard with POWER BI to aid stakeholders highlight key performance metrics.

HUMAN RESOURCE ANALYSIS

Utilized MySQL in MySQL Workbench 8.0 CE to evaluate the ‘Human Resources.csv’ to perform sentiment analysis on the employees.

Automated Data Entry Form

This project involves designing an Excel data entry dynamic form in VBA window using text boxes, option buttons, combo boxes, command buttons and list boxes. The data entered is saved in a database thus proving efficiency in data collection and safety.

Python Data Cleaning Project

This github repository includes the code and documentation for the data cleaning procedures applied to the FIFA21 dataset. The objective of this project is to refine and improve the dataset, which contains details about players from the widely-known FIFA21 video game.