Beta

icho Cai

Certified

Analyst

l

My Portfolio Highlights

My New Workbook

Project: Analyzing Motorcycle Part Sales

My New Workbook

Project: Analyzing Motorcycle Part Sales

Data whisperer, turning numbers into captivating stories.

My Work

Take a look at my latest work.

DataLab

Project: Analyzing Motorcycle Part Sales

DataLab

Project: Analyzing Motorcycle Part Sales

My Certifications

These are the industry credentials that I’ve earned.

Data Analyst Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Projects

Analyzing Unicorn Companies

Analyzing Motorcycle Part Sales

Projects

Analyzing Unicorn Companies

Analyzing Motorcycle Part Sales

My Work Experience

Where I've interned and worked during my career.

Draco Natural products | Feb 2023 - Apr 2023

Marketing Analyst

• Organized CRM systems by removing redundant data and joining datasets by using MySQL to facilitate future data analysis and visualizations. • Identified lucrative customer segments through k-means clustering and RFM analysis, leading to an 8% increase in conversions and a 10% boost in seasonal revenue. • Presented comprehensive, data-driven marketing strategies and action plans to C-level, resulting in improved online shopping behaviors and successful implementation of marketing segematation strategies. • Implemented Asana as a project management tool, enhancing efficiency and ensuring timely delivery, leading to successful product launches and improved department processes.

Q Bay Center | Feb 2022 - Jan 2023

Marketing Analyst Intern

• Assisted internal teams in improving 3% of the user experience and social media effectiveness by applying click-stream analysis and A/B testing to outline various conversion scenarios and create comprehensive user behavior flows. • Lowered campaign bounce rates (by 8% this past calendar year) by leveraging in-depth target audience analysis and profiling based on Google Analytics insights. • Collaborated with cross-functional teams to develop data-driven marketing strategies, incorporating insights from analytics and market research. • Created customized dashboards for C-level executives by following defined KPIs and business objectives to report day-to-day performance and support marketing decisions and strategies.

Pinnacle Career | Nov 2021 - Jan 2022

Data Analyst Intern

• Utilized Media Mixed Modeling to assess the overall marketing effect and define the appropriate budget allocations across various marketing channels. • Supervised ETL pipeline by MySQL after feature engineering. • Saved 7% on advertising and increased publicity effect by utilizing R to conduct multivariate, logistic regression models and hypothesis testing to evaluate the impact of various marketing tactics. • Delivered budget optimization recommendations on Excel Solver and delivered the visualization output by Tableau.

My Education

Take a look at my formal education

Master in Analytics Northeastern University | 2021

About Me

icho hasn't filled in a bio text

Create Your Data Portfolio for Free