Welcome to my programming portfolio! Here I exhibit tips and tricks, as well as personal projects I feel passionately displays my interest in data analytics as well as full stack developement.
| Project Name | Description | Topic |
|---|---|---|
| Excel Tips and Tricks | Wrote Excel functions that assist with expediting the data analysis process. | Excel functions, data cleaning, advanced charting, data formatting |
| Adidas Dashboard | Used Fictional Adidas financial records to create a dashboard highlighting key information which includes interactive charts as well as side buttons. | dashboard creation, charting, adjustable pivot charts & tables, formatting |
| Project Name | Description | Topic |
|---|---|---|
| Analyzing Consumer Data | Using a self created database of 1000 rows of fictional consumer data, it will be analyzed, cleaned, and used to answer stakeholder questions from "Aurora Technologies" | SQLite, complex SQL queries, database creation, database analyzation, joins, case-end |
| Dinosaur Data Analysis | Utilizing premade data found through Kaggle.com, it will be analyzed, isolated, and manipulated to simulate a paleontological teams findings. | SQLite, complex SQL queries, database analyzation, inner joins, case-end, window functions |
| Project Name | Description | Topic |
|---|---|---|
| Analzying Social Media User Data | Using a custom made JSON file with 50 different users, the data will be put through Python's Pandas, SciPy, and Maplotlib libraries to form a detailed analysis dissecting and visualizing different media's user data. | JSON creation, Python, Pandas, SciPy, Matplotlib, database analyzation, debugging code |
| Cheat Sheet Functions | Custom made functions for the purpose of making coding just a little bit easier! | Pandas, Numpy, function creation, data analytics, encoding |
| SQLAlchemy Query Process | Python code displaying the modeling, ingestion, and query process of a dynamically created schema able to handle file imports utilizing SQLAlchemy.ORM and Pandas. Features include the database construction, row / col manipulation, table joining, and aggregate functions. | Python, Pandas, SQLAlchemy.ORM |
| Playwright Browser Automation Template | Python code displaying the creation of a dynamic async Playwright function, navigating through a template website and performing a multitude of sample tasks based off a sample CSV file. Tasks include input clicking / filling, lambda functions, button pressing, and HTML / CSS element navigating | Python, Playwright, asyncio, Sys, Pandas, re, datetime |
| Project Name | Description | Topic |
|---|---|---|
| Customer Sales and Product Analysis | Using Excel to craft a custom made database of unorganized data between customer sales and product info from ChemTech, a chemical supply company. The data will be manipulated and cleaned in SQL, while EDA tasks and visualization will be done in R to report findings. | Excel, Creating dataframes, functions, SQL, data manipulation, transactions, CTE's, R, visualization, dplyr, ggplot2, scales, lubridate |
| Video Game Product Health and Feedback Analysis | Using two custom created JSON files housing player information and product health, the files will be normalized, manipulated, organized, analyzed, and visualized solely in R via vanilla and multiple libraries. | JSON file creation, analysis, visualization, R, JSONlite, data.table, ggplot2, stringr, scales, lubridate, dplyr, tidyverse, tidytext |
| R Shiny Visualization Apps | A collection of R Shiny applications able to handle data analysis, visualization, dynamic ui changes, and mulitple libraries. | R, Shiny, HTML, CSS, JavaScript |
| Project Name | Description | Topic |
|---|---|---|
| Automation Software Front-End | #FRONT-END ONLY# Web automation software written in JavaScript and C# to perform various tasks, written as a template. The UI will be built and previewed on Vite. HTML will be utilized to create the software structure and CSS with SASS to customize structure elements. Using the React framework, base / advanced UI elements via JSX will be created in combination with TypeScript's readability. | HTML, CSS, SASS, JavaScript, React, TypeScript |
| Automation Software Front-End Debugging | Utilizing the previous project's front end source code, JavaScript's Jest and Cypress will be used to debug and perform a multitude of testing types. | JavaScript, TypeScript, Jest, Cypress |