Data Analytics Analysis
Resume:
FREDERICK
JABAGAT
CAREER OBJECTIVE
Former educator with a passion for communicating concepts to a variety of audiences and a knack for creating collaborative environments. Highly skilled in Excel, SQL, and Tableau - looking forward to using these tools to drive insights and recommendations to cross-functional teams.
DATA ANALYTICS EXPERIENCE AND PROJECTS
Netflix Userbase Analysis – Excel and SQL July 2024 Conducted Exploratory Data Analysis: Analyzed Netflix userbase dataset to understand demographics, subscription types, and revenue patterns. User Segmentation: Identified key segments by country, age group, and device usage.
• Key Metrics: US and Spain have the most users; Basic plan users have a 25% longer subscription duration than Standard and Premium users. Revenue and Subscription Duration Analysis: Examined correlations between subscription types and revenue.
• Key Metrics: Basic plan generates 23% (Standard) and 25% (Premium) more monthly revenue.
Strategic Recommendations: Suggested personalized recommendations and value-added services to retain subscribers and mitigate churn.
• Key Metrics: Standard plan users are more likely to churn with price increases; Basic and Standard plan users rank highest for tablet and smartphone usage.
XFT Happy Hour Sales KPI Dashboard May 2024
Conducted exploratory data analysis and data cleaning, and detailed comparison of total gross sales and profit for January-February and March-April periods.
• Key Insight: Identified that Mondays, Tuesdays, and Wednesdays had the slowest sales among all days of the week, suggesting the need for targeted promotions.
• Sales Performance: Despite multiple holidays in the Jan-Feb, Mar-Apr sales matched 98% of the Jan-Feb sales, indicating the positive impact of the happy hour promotion
• Recommendations: Continuing and adjusting the Happy Hour Promotion to target the slowest times of the day, maximizing profit.
• Emphasized the importance of strategic promotions in mitigating sales declines and optimizing profit during slower periods WORK EXPERIENCE
Store Manager March 2023 -Present
Xing Fu Tang Alhambra
• Managed daily operations, business reporting, inventory, scheduling, and sales.
• Analyzed cost, inventory, sales and labor scheduling effectively Data Analyst
******************@*****.***
Monterey Park, CA
Portfolio Github
EXPERTISE
• Excel
• MySQL
• Tableau
• Data Visualization
SKILLS
• Sales Performance Analysis
• Quantitative Analysis
• KPI Reporting
• Dashboard Development
• Marketing Strategies
EDUCATION
B.A.
World Arts and Culture/Dance
University of California, Los Angeles
June 2018 – June 2020
CERTIFICATIONS
Excel for Data Analytics
MySQL for Data Analytics
Tableau for Data Visualization
Contact this candidate