Portfolio

🛒Retail Analytics: From Excel to SQL

Description: Building a data pipeline for online retail analysis
Tech Stack: SQL (SELECT, CREATE, ALTER), Python(pandas, numpy), Azure(Data Factory, SQL Database, SQL Server, Blob Storage)
Status: Ongoing

---

💼Northwind Traders

Description: Answer the business question of who gets the bonus for the highest sales amount by analyzing the company database.
Tech Stack: SQL(SELECT, ORDER BY, JOINS, GROUP BY, HAVING, Aggregate functions)
Status: Completed

---

🎬Movie industry

Description: An analysis of the Movie Industry dataset available on Kaggle to check for correlations between certain numeric movie features.
Tech stack: Python(pandas, numpy, matplotlib, seaborn)
Status: Ongoing

---

📈Car Stock Market Analysis

Description: A general look on the stocks of various car brands between the years 2013-2023
Tech Stack: Python(pandas, pandas_datareader, yfinance, numpy, matplotlib)
Status: Completed

---

🍃Bellabeat Case Study

Description: Improve Bellabeat’s future marketing strategies by analyzing other smart devices’ usage data.
Teach Stack: R(tidyverse, skimr, snakecase etc.)
Status: Completed

---