Skip to content

A glimpse into my world of data exploration and discovery.

Notifications You must be signed in to change notification settings

farens27/Portfolio

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

20 Commits
ย 
ย 

Repository files navigation

๐Ÿ“œ Ren's Portfolio

Data is my passion, and my portfolio is my playground. Here, you'll find a collection of my projects that showcase my skills and experience in using data to make a difference.

๐Ÿ“ Table of Contents


Data Engineering

Project Link Tools Project Description
๐ŸŽฅ Movie Survey Data Cleansing Microsoft SQL Server & Microsoft SQL Server Integration Services (SSIS) The Movie Survey Data Cleansing Project is a comprehensive initiative focused on mastering ETL (Extract, Transform, Load) processes utilizing SQL Server Integration Services (SSIS). The project aims to address the complexities associated with data cleansing within the realm of movie preference surveys. Through meticulous data handling and transformation, the project endeavors to streamline and standardize survey data for subsequent analysis.

Python

Project Link Area of Analysis Project Description Libraries
๐ŸŽฎ VCT Masters Tokyo 2023 EDA This project delves into the VCT Masters Tokyo 2023 tournament, uncovering the most and least prevalent agents, map-specific agent preferences, and players excelling in various statistical categories, including kills, headshot percentage, rating, combat score, first kills, and KAS. Data visualization will be employed to effectively present the findings. Pandas, Numpy, Matplotlib, and Seaborn

SQL

Project Link Area of Analysis Project Description DBMS
๐Ÿ’ผ Career Track Analysis Data Analysis This project aims to analyze the career track enrollments and achievements of 365's students using SQL and Tableau. The analysis will focus on understanding student enrollment patterns, completion rates, and factors influencing successful completion. The findings will be used to inform improvements to the career track program and enhance student success. MySQL
๐ŸŽต Music Store Analysis Data Analysis This project leverages the power of SQL to uncover key insights into the operation of an online music store and drive its success. Delve into the store's data to uncover hidden patterns and provide actionable recommendations. PostgreSQL
โ› Vehicle Accident Analysis Data Analysis This project embarks on a data-driven journey to demystify the world of vehicle accidents. Using the powerful lens of SQL, we'll dissect a comprehensive dataset to illuminate patterns, trends, and underlying factors contributing to these road incidents. Microsoft SQL Server
๐Ÿ• Pizza Sales Analysis Data Analysis This project transforms you into a data-driven pizza maestro, wielding the power of SQL and Power BI to analyze your pizzeria's sales performance and unlock hidden gems for success. Say goodbye to guesswork and embrace a data-driven approach to pizza perfection! Microsoft SQL Server

Excel

Project Link Area of Analysis Project Description

Tableau

Project Link Project Description Dashboard Link
๐Ÿ’ผ Career Track Analysis This project aims to analyze the career track enrollments and achievements of 365's students using SQL and Tableau. The analysis will focus on understanding student enrollment patterns, completion rates, and factors influencing successful completion. The findings will be used to inform improvements to the career track program and enhance student success. Dashboard

Power BI

Project Link Project Description Dashboard Link
๐Ÿ• Pizza Sales Analysis This project transforms you into a data-driven pizza maestro, wielding the power of SQL and Power BI to analyze your pizzeria's sales performance and unlock hidden gems for success. Say goodbye to guesswork and embrace a data-driven approach to pizza perfection! Dashboard

Looker Studio

Project Link Project Description Dashboard Link
๐Ÿ›’ Super Store Sales Analysis This project dives deep into the sales data of Superstore, a fictional retail giant, using Looker Studio to uncover key insights and drive informed business decisions. By analyzing various dimensions like order volume, sales figures, and customer segments. Dashboard