Currently an Extern @Beats By Dre
Aspiring Data Analyst
I'm Graeme Cyrell, on a journey to shape my career in data analytics with hands-on experience at Beats by Dre.
Work samples
Here, you'll find my projects and experiences that showcase my passion for data analysis and insights.
Beats By Dre · Aug 2026 · ✅ Verified by Extern
Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship
A Beats by Dre externship in data analytics focused on extracting qualitative and quantitative consumer insights from reviews, surveys, and social data.
Data AnalysisPythonHealthcare Hospital Patient Analysis
Analyzed 10,000 patient records across 8 facilities (2019–2024) to uncover admission patterns, billing trends, and length-of-stay variance by condition and admission type. Engineered 12 SQL queries and reusable views surfacing top conditions, average billing by insurance type, and abnormal diagnostic test rates. Built a 6-chart Tableau dashboard with KPI tiles; presented 6 recommendations to reduce average length-of-stay.
SQL (PostgreSQL)PythonTableauNBA Team Performance & Endorsement Analysis
Built a relational data model joining 4 statistical tables across 30+ teams and 10+ seasons, cleaning thousands of game-level records to eliminate duplicates and standardize team nomenclature. Calculated advanced performance metrics and visualized franchise efficiency trends in interactive Tableau dashboards to inform sponsorship targeting recommendations.
SQL (BigQuery)TableauBellabeat Smart Device Data Analysis
Analyzed activity data from thousands of Fitbit users in R to identify behavioral correlations between physical activity, sedentary time, and sleep duration. Delivered Tableau dashboards translating behavioral findings into 3 targeted marketing recommendations for Bellabeat's product team.
R (tidyverse, ggplot2)Tableau
About me
I'm Graeme Cyrell, on a journey to shape my career in data analytics with hands-on experience at Beats by Dre.
I'm Graeme Cyrell Siazon-Consolacion, an aspiring data analyst currently engaged in an externship with Beats by Dre. I'm passionate about leveraging both qualitative and quantitative insights to drive impactful decisions in the industry.
Externships
Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship
Beats By Dre
Experience
Small Business Owner
Amazon · Dec 2022 - Aug 2024
PT Tech
Stratton Rehab. Clinic · Jun 2021 - Sep 2022
Front Desk Agent/Bellman
Marriott · Apr 2018 - Dec 2019
Education
Texas A&M International University
Master of Science, Information Science (IT/Computer Science) · Class of 2025
University of Texas at San Antonio
Bachelors Degree/Kinesiology · Class of 2021
Skills
✅ Verified by Extern
Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship
A Beats by Dre externship in data analytics focused on extracting qualitative and quantitative consumer insights from reviews, surveys, and social data.
Overview
In my externship with Beats by Dre, I explored how top brands decode consumer conversations to enhance product resonance. I gained practical skills in market trend identification, customer feedback analysis, and sentiment analysis using Python and AI tools. This experience deepened my understanding of consumer behavior and data analytics, guiding strategic business decisions.
What I've accomplished
I produced a pain-point taxonomy, a CSV-formatted customer journey map, cleaned survey datasets with statistical analyses and charts, and a documented approach for aspect-level sentiment tagging and competitive sentiment benchmarking.
Project breakdown
Healthcare Hospital Patient Analysis
Analyzed 10,000 patient records across 8 facilities (2019–2024) to uncover admission patterns, billing trends, and length-of-stay variance by condition and admission type. Engineered 12 SQL queries and reusable views surfacing top conditions, average billing by insurance type, and abnormal diagnostic test rates. Built a 6-chart Tableau dashboard with KPI tiles; presented 6 recommendations to reduce average length-of-stay.
NBA Team Performance & Endorsement Analysis
Built a relational data model joining 4 statistical tables across 30+ teams and 10+ seasons, cleaning thousands of game-level records to eliminate duplicates and standardize team nomenclature. Calculated advanced performance metrics and visualized franchise efficiency trends in interactive Tableau dashboards to inform sponsorship targeting recommendations.
Bellabeat Smart Device Data Analysis
Analyzed activity data from thousands of Fitbit users in R to identify behavioral correlations between physical activity, sedentary time, and sleep duration. Delivered Tableau dashboards translating behavioral findings into 3 targeted marketing recommendations for Bellabeat's product team.