Camille's Data Analytics Portfolio

Ulta Skincare Reviews  Analysis of Dermalogica product reviews Background      Dermalogica is a popular prestige skincare brand sold at Ulta Beauty, a beauty retail chain. I sorted, cleaned, and analyzed data from Dermalogica product reviews left on ultabeauty.com from the products' listing dates ~11 years ago in 2012 until March 27, 2023. Objective Identify trends among the reviews in order to analyze where reviewers are located, if they are verified buyers,  when they left the most reviews, and which products are reviewed most frequently and least frequently. Data      The data used for analysis is from a public dataset called "NLP: Ulta Skincare Reviews" that can be found on Kaggle  and is available in .csv format. The data was pulled from the Ulta website on March 27, 2023 and includes 4 different Dermalogica exfoliating product types, including Daily Microfoliant, Daily Superfoliant, Hydro Masque Exfoliant, and Multi-Vitamin Thermaf...

 Bellabeat Fitness Tracker Analysis Using FitBit Data to Determine Fitness Tracker User Trends Background Bellabeat is a high-tech company created by women for women. Its main goal is to empower women through their health; therefore, data such as activity and sleep are collected from the users of the Bellabeat phone application and the three other different fitness tracker products.  Business Task The founder of the company would like an analysis on the trends in smart device usage.  I n order to analyze smart device usage, a public dataset from a similar fitness tracker called FitBit was used.  Business Objectives What are some trends found in FitBit user data that can be applied to the customers of Bellabeat products? How could these trends influence Bellabeat's marketing strategy? Data The FitBit tracker data is a publicly available dataset on Kaggle which is hosted by the user Möbius under the license CC0: Public Domain. The files are in .csv format. The data re...

Cyclistic Rider-Type Analysis Trends in 2022 Background :      Cyclistic is a bike-share company that started in 2016 and has since grown into a successful company with a fleet of 5,824 bicycles (with 3 different types of bicycles) that are located in stations throughout Chicago.        Cyclistic has two types of riders: casual riders, which consists of those using single-ride passes or full-day passes, and annual members. Annual memberships are more profitable than casual riders.     Business Task: Analyze how annual members and casual riders use Cyclistic bikes differently in 2022 to determine how casual riders can be turned into annual members to increase profits.   Business Objectives: How do annual members and casual riders use Cyclistic bikes differently? How could these trends apply to turning casual members into annual members? Data : The dataset is publicly available via Motivate International Inc. under this link , and the data...