Bellabeat Case Study

Identify potential opportunities for growth and provide marketing strategy recommendations to the executive based on trends in Bellabeat app usage.

Tools: Excel, R programming

PwC Switzerland Virtual Experience Program on Forage

Performed data analysis with Power BI to help solve business problems for clients.
Built dashboards for call center, customer retention, and HR analysis respectively.

Tools: Power BI

PwC Switzerland Virtual Experience Program on Forage

Mark Minervini's VCP Screener

I'm interested in stock investments and discovered Mark Minervini on Youtube that I truly began to understand the strategy behind successful stock trading. Minervini uses many criteria to screen leading stocks, but most trading platforms do not support setting so many indicator criteria. Therefore, I want to develop a screener.

Tools: Python
Packages: pandas, numpy, yfinance, matplotlib, scipy

Stock Market

Stephen Curry's Milestone

The project focuses on studying Stephen Curry's career in the NBA through data analysis using SQL. The dataset used in the project is obtained from Kaggle, and includes various statistics about Curry and his team. It includes several SQL queries that explore different aspects of Curry's performance, such as his shooting performance, his contribution to his team, and his achievements compared to other players.

Tools: MSSQL

Stephen Curry

Technical Skills

Excel

Experienced with Excel tools and functions to clean and prepare data and use logical and lookup functions to transform, link, categorise and analyze data.

MySQL

Experienced with SQL to access databases and extract, filter, and sort the data they contain. Applied SQL functions for cleaning and transforming data. Completed calculations using SQL queries for data analysis.

Python Programming

Experienced with Python, covering the basics of Python, numerical computing with Numpy, working with CSV data files, analyzing tabular data with Pandas and creating visualization with Matplotlib and Seaborn.

Power BI

Experienced with Power BI to prepare data and use DAX (Data Analysis Expressions) to solve basic calculations and data analysis problems. Created effective interactive reports and dashboards to visualize the analysis of the data with different graphs.

Tableau

Experienced with Tableau to create dashboards, dashboard filters and effective visualization of data to form a compelling narrative through data stories.

R programming

Experienced with R to import, clean, manipulate, analyze and visualize data using Tidyverse packages (ggplot2, dplyr, tidyr, readr and tibble).