Makayla Farmer
Blythewood
Summary
Aspiring Data Analyst with hands-on experience in Tableau, Excel, and SQL, skilled in transforming complex datasets into actionable insights. Strong background in economics, finance, and business strategy, with a proven track record of analyzing trends and creating impactful data visualizations. Committed to leveraging data to enhance efficiency and support strategic growth initiatives. Recognized for analytical thinking and problem-solving abilities in dynamic environments.
Overview
3
3
years of professional experience
4
4
Certifications
Work History
Data Analytics Participant
Global Career Accelerator
Columbia
09.2025 - 01.2026
- Completed intensive data analytics training focused on Excel, SQL, and Tableau.
- Analyzed 6,000+ trending YouTube videos to identify performance drivers and recommend strategies to improve engagement.
- Explored BART ridership data to uncover weekday commuting trends and high-volume line usage, supporting transit optimization.
- Examined U.S. delivery datasets to identify regional trends in delivery time, order volume, and cuisine preferences, improving operational strategy.
- Visualized Google Trends data for nine Olympic sports, revealing cyclical interest patterns and event-driven spikes for seasonal marketing.
- Conducted A/B test analysis on promotional emails, providing actionable recommendations that increased engagement rates.
- Utilized XLOOKUP and PivotTables to evaluate referral program data, discovering that referred users exhibited higher spend and retention rates.
Sound Technician
Ambassador Christian Center
Columbia
12.2023 - 10.2024
- Set up and operated audio equipment to ensure clear, balanced sound during live services and events.
- Managed audio recording and livestream production, delivering consistent quality for in-person and online audiences.
- Troubleshot technical issues and maintained audio system efficiency to ensure smooth event execution.
Team Manager
Legion City General Football Team
Blythewood
06.2023 - 08.2024
- Collected and organized player IDs, contracts, and insurance forms to ensure compliance and accurate documentation.
- Managed team finances and payment records, maintaining accuracy and transparency.
- Streamlined administrative processes, improving record-keeping and operational coordination.
Education
Bachelor's - Economics & Finance
University of South Carolina
Columbia, SC07.2027
Associate of Arts - Business
University of South Carolina
Columbia, SC12.2024
Skills
- Tableau and Power BI
- Excel and Google Sheets
- SQL and data querying
- Data visualization and storytelling
- Statistical analysis and forecasting
- Financial analysis and budget tracking
- Business strategy and intelligence
- Leadership and collaboration
- Communication skills
- Problem-solving and process improvement
- Attention to detail in reporting
Projects
UNESCO World Heritage Sites, Visualized site classifications, endangered status, and country-level coverage in Tableau. Gender Pay Gap (Forbes Data 2005-2020), Created comparative visualizations of earnings among top-paid actors and actresses. Global Data Dashboards, Explored worldwide datasets on height, music sales, and video game genres using Tableau. UFO Sightings Analysis, Built calculated fields and charts to analyze sighting trends by location, duration, and time of day. Super Bowl Trends, Joined and analyzed multi-source datasets to evaluate ad costs, TV ratings, and competitiveness over time. NYC Taxi Data Visualization, Created dashboards to examine fare distribution, trip distance, and tipping behavior across rate types.
Certification
AI Professional Skills Certification, University of South Carolina, Global Career Accelerator, 2025
Timeline
Data Analytics Participant
Global Career Accelerator
09.2025 - 01.2026
Sound Technician
Ambassador Christian Center
12.2023 - 10.2024
Team Manager
Legion City General Football Team
06.2023 - 08.2024
Bachelor's - Economics & Finance
University of South Carolina
Associate of Arts - Business
University of South Carolina