Hi! 👋 This here is a collection of all the recent data analysis projects I have completed/am completing. Please keep in mind that this is a work in progress. ✨
Intermediate SQL knowledge (Joins, common table expressions, aggregations, subqueries, datetime functions, datatype conversion, text and string manipulation...)
| Project | Description | Functions Used | Status |
|---|---|---|---|
| 💼Northwind Trades | Answer the business question of who gets the bonus for the highest sales amount by analyzing the company database | SELECT, ORDER BY, JOINS, GROUP BY, HAVING, Aggregate functions | Completed |
| 🔫The SQL Murder Mystery | Solve an intriguing murder case by analyzing an SQL database | SELECT, JOINS, WHERE, LIKE | Completed |
Data cleaning, visualization, analysis
| Project | Description | Libraries Used | Status |
|---|---|---|---|
| 🎬Movie industry | An analysis of the Movie Industry dataset available on Kaggle to check for correlations between certain numeric movie features. | pandas, numpy, matplotlib, seaborn | In Progress |
| 📈Car Stock Market Analysis | A general look on the stocks of various car brands between the years 2013-2023 | pandas, pandas_datareader, yfinance, numpy, matplotlib | Completed |
| Project | Description | Packages Used | Status |
|---|---|---|---|
| 🍃Bellabeat Case Study | Improve Bellabeat's future marketing strategies by analyzing other smart devices' usage data | tidyverse, skimr, snakecase etc. | Completed |