For inquiries and collab requests feel free to reach out at peige77@gmail.com.
This repository will serve as a compendium of the projects that I have completed. Most projects are showcased inside a Jupyter Notebook to show the data analysis thought process concisely.
Previews of each project with a short description and project link can be viewed below.
Projects are broken down into 3 separate folders based on the way the analysis was performed:
- Python Projects - analysis using Python programming, visualizations created with Python, Excel & Tableau
- SQL Projects - analysis using SQL specifically Microsoft SQL Server Management Studio, visualizations created with Excel & Tableau
- Other Projects - projects that don't neatly fit into another category ex: websites created with HTML, CSS & JS, Excel-only projects or dashboards
Main skills, tools & softwares:
- Python Libraries: NumPy, Pandas, Matplotlib, Seaborn, Folium & Pypyodbc
- SQL: Database Management, ELT, Data Migration, Microsoft SQL Server Management Studio, Big Query & Large and Small Data
- Data Analysis: Collection, Preprocessing, Wrangling, Cleaning, Manipulation, Transformation & Exploratory Data Analysis
- Statistical Analysis: Univariate and Bivariate Analysis & Hypothesis Testing
- Additional Software: Excel, Sheets, Jupyter Notebook/Lab & Tableau
- Misc: HTML, CSS, JS, Dashboard Creation, Revenue Forecasting
Asheville Airbnb Data Analysis- Created to identify the perfect daily rate for my Asheville property during travels and pinpoint strategic investment locations, this project blends precision with potential in the realm of real estate.
Visualizations from Project:
U.S. Education Spending vs. Test Scores Analysis- This project dissected U.S. Department of Education data, revealing the intricate relationships among state revenue, 8th-grade math scores, state expenditure, and identifying states with the highest student populations.
Visualizations from Project:
French Bakery Sales Analysis and Revenue Projection - This project unfurled the essence of a French Bakery's sales, distilling monthly revenues, spotlighting the top 10 items, and orchestrating a forecast for the coming year.
Visualizations from Project:
Survivor Contestant Age Analysis - In the realm of Survivor fandom, my family bets on victors based on episode #1 impressions. Seeking an advantage, I discreetly analyzed age groups to secure my winning streak.
Visualizations from Project:
Covid Mortality Analysis- This project delved into the harsh reality of Covid's toll, swiftly pinpointing the continent with the most deaths and highest mortality rate. It tracked the daily pulse of new cases, capturing the pandemic's relentless journey through the dataset duration.
Visualizations from Project:
Spotify Top Artists, Albums & Singles Analysis- In the Spotify realm, this project swiftly uncovered the top 10 artists, singles, and albums, capturing the essence of musical dominance through digital streams.
Visualizations from Project:
Bike Store Revenue, Customer & Employee Analysis - This project deciphered a national bike store franchise's sales data, pinpointing top revenue states and months, distilling top products annually, spotlighting top-performing sales reps, and unmasking the influential top 10 customers driving sales.
Visualizations from Project:
Product Performance, Monthly Revenue & Ad Spend Data Analysis- This project dissected data from a digital marketing company, revealing monthly sales revenue, top-grossing states, delivery punctuality, product returns, acquisition channels' profitability, and product-specific customer satisfaction.
Visualizations from Project:
Netflix Content Analysis of: Top Countries, Most Popular Genres & Content by Rating- This Netflix data dive unveiled content-producing countries, distinguished preferences between movies and TV shows, crafted a top 10 genre list, and mapped content distribution based on ratings.
Visualizations from Project:
Superstore Analysis of Sales, Products, Categories & States- This Tableau project delved into the Superstore Dataset, revealing revenue nuances per state, category, and subcategory. It artistically depicted profit margins across every metric, sculpting a concise narrative of analytical richness.
Visualizations from Project:
