Hi! I'm Remy and I'm currently working on a boot camp in data analysis/data science in London. I have an analytical background in engineering.
This is a repository to showcase skills, share projects and track my progress in Data Analytics / Data Science related topics.
Imperial College London - MRes Medical Device Design and Entrepreneurship
King's College London - BEng Biomedical Engineering
Project: Evaluated the effectiveness of a pilot loyalty program for an e-commerce company. Make recommendations on Prism+ loyalty program.
Project: Should a company invest in paid or organic media? How to attribute marketing channels? Deeper dive on whether investment for paid advertising has paid off?
Project: FP&A analysts flagged a sharp increase in marketing spend. Analysed metrics to see if the marketing spend has paid off.
Project: Improve conversion rate through targeted marketing by customer segmentation.
Goals: Conduct RFM analysis to create customer segments for an e-commerce company.
Results: Created and split customers into 6 customer segments. Provided insights and recommendations to improve number of customers opting in, retention rate, and conversion rate.
Project: Unlocking Prism's Potential.
Goals: To provide Prism, an ecommerce business with an intuitive dashboard showing a holistic view of Prism's performance over both the short and medium term.
Descriptions: Vast data warehouse including funnelevents, product costs, product list prices, product returns, product attributes, sessions, transactions, transactions and items, and users tables. Over 450M rows of real web, transactional, product, and operational data spanning over 3 years.
Results: Prism has a customer retention issue, with a 77.5% annual churn rate. Google remains the top revenue channel at over £10M annually. Optimising Google represents untapped potential. Increase purchase frequency through triggered re-engagement campaigns, incentives for re-orders and add-ons. Implementing pay in instalment option to the website to encourage repeat purchases.
Project: Case study on a travel agency experiencing huge growth in mobile bookings.
Goals: To understand how mobile users are using epictrips.com.
Descriptions: epictrips.com has seen a huge growth in the number of bookings made on mobile devices. To utilise this, epictrips.com would like to know how epictrips.com is being used.
Results: Americans are booking the most trips out of any country and are primarily travelling within the US. Recommendation: Advertise more hotels in the US and target marketing efforts towards the US. The mobile app is outperforming the mobile web. Recommendation: Continually make UI/UX improvements. Travellers book holidays last minute. Recommendation: Offer pricing and discount strategies to utilise the large number of people making last-minute bookings.
Project: Dashboard providing analysis on which inventory to re-stock for an e-commerce business in the UK.
Goals: To provide a dashboard providing analysis on which inventory to restock.
Descriptions: A fictional e-commerce business has been acquired and the acquiring company wants to maximise profit for the e-commerce business. They aim to do this by stocking the most profitable inventory. Given data regarding product details, product cost, product price, etc.
Results: Based on the analysis, I recommended that Men's Bib Shorts (sizes S and M) and Women's Tights (sizes S and L), should be the products that should have a drastic increase in inventory to maximise profit.
Project: COVID data visualisation dashboard.
Goals: To analyse COVID data by cases per country, deaths, and COVID tests conducted.
Results: See data visualisation here.