KCData Analyst·🟢 Open to work
Krystle Ceasar portrait

Business-minded analyst combining data, operations, and strategic problem-solving

I combine Excel, SQL, and Tableau with operations experience to spot trends, answer business questions, and build dashboards that leaders use to act.

Work samples

I present consumer and people-analytics findings, dashboards, and SQL-backed analyses—from externships at Beats by Dre and Amazon to Tableau and segmentation projects.

  • Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship
    Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship
    Beats By Dre logo

    Beats By Dre · Dec 2025 · ✅ Verified by Extern

    Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship

    A Beats by Dre externship in data analytics, focusing on extracting consumer insights from surveys and reviews, performing sentiment analysis, and synthesizing findings into presentations and dashboards.

    Data AnalysisAI & MLPython
  • Amazon Operational Strategy & People Analytics Externship
    Amazon Operational Strategy & People Analytics Externship
    Amazon logo

    Amazon · Feb 2026 · ✅ Verified by Extern

    Amazon Operational Strategy & People Analytics Externship

    Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90.You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely.It’s part research, part strategy—and all about learning how people data drives big decisions.

    StrategyAI & MLOperationsData AnalysisPythonPresentation Skills

About me

I combine Excel, SQL, and Tableau with operations experience to spot trends, answer business questions, and build dashboards that leaders use to act.

I'm an analytics professional with an MBA in Business Analytics and over eight years of experience in business operations, project coordination, and problem-solving. My background spans graphic design, operations, and data analytics, giving me a unique perspective on business challenges and communicating insights. Through projects and externships, I've analyzed consumer behavior, employee experiences, operational performance, and marketing effectiveness using Excel, SQL, Tableau, and Python. I'm particularly interested in understanding the people and processes behind the data.

Externships

Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship

Completed · Dec 2025

Experience

AI Analyst

Handshake AI · Jun 2026 – Present

Marketing Analyst Intern

Snow Data Science · Aug 2026 – Oct 2026

Data Analyst

TELUS Digital · May 2026

Operational Strategy & People Analytics Extern (Amazon) / Data Analytics Extern (Beats by Dre)

Extern.com — Amazon & Beats by Dre · Aug 2025 – Feb 2026

Lead Consultant

FedEx Office · Jan 2021 – Oct 2025

Store Consultant

FedEx Office · Jul 2017 – Jan 2021

Education

Lamar University

Master of Business Administration in Business Analytics · Class of 2025

University of Houston - Clear Lake

Bachelor of Fine Arts - Graphic Design · Class of 2014

Skills

Data AnalysisMicrosoft ExcelSQLTableauData VisualizationDashboardsData AnalyticsData Storytelling

✅ Verified by Extern

Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship

A Beats by Dre externship in data analytics, focusing on extracting consumer insights from surveys and reviews, performing sentiment analysis, and synthesizing findings into presentations and dashboards.

Data AnalysisAI & MLPython

Overview

The work combined quantitative and qualitative analysis across surveys and product reviews to profile consumers and surface product insights for Beats by Dre. The project cleaned and analyzed about 4,910 survey responses, coded open-text feedback into themes, reviewed external review data, and produced an 8-slide executive presentation plan summarizing personas, usage patterns, and prioritized

Beats by Dre Data Analytics: Qualitative & Quantitative Insights Externship
Google Docs
Access

What I've accomplished

I produced five detailed consumer profiles, cleaned and analyzed roughly 4,910 survey responses with quantitative summaries and thematic coding, reviewed external review datasets and prioritized analysis areas, and packaged findings into an 8-slide executive presentation plan.

Project breakdown

View all work

✅ Verified by Extern

Amazon Operational Strategy & People Analytics Externship

Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90.You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely.It’s part research, part strategy—and all about learning how people data drives big decisions.

StrategyAI & MLOperationsData AnalysisPythonPresentation Skills

Overview

The externship compiled and analyzed employee voice data from public sources, mapped roles within an Amazon fulfillment context, and developed evidence-backed themes and workforce segments. Deliverables included structured spreadsheets, cleaned text for sentiment analysis, theme-tagged feedback with sentiment charts, a root-cause tree, segment assignments, and a pilot-ready problem statement and

Amazon Operational Strategy & People Analytics Externship
Google Sheets
Access

What I've accomplished

I produced cleaned, analysis-ready employee voice datasets, identified themes and root causes with sentiment charts, segmented the workforce with tags and metrics, and authored a pilot-ready problem statement and intervention hypothesis addressing physical strain for frontline associates.

Project breakdown

View all work