Marketing Analytics Projects
Turning Data into Marketing Decisions
A showcase of analytical projects spanning regression modeling, data visualization, and AI tool evaluation. Each project reflects how I approach data as a way to answer real business questions and inform better decisions.
Vodka Sales Data
Objective: Understand how advertising impacts sales and identify the best model to capture that relationship.
Approach: Applied regression and adstock model to a vodka sales dataset to evaluate the impact of advertising spend on sales volume. Tested multiple model types, including linear regression and log-log models to find the best fit. The adstock model proved to be the strongest fit for the data, accounting for the lagged and cumulative effects of advertising over time.
Tableau
Objective: Translate raw sales data into clear, actionable visual insights for business decision-making.
Approach: Built profit and sales performance dashboards in Tableau to surface key trends and support data-driven decisions across revenue and operational performance.
LLM Project
Objective: Determine which large language model performs best at generating accurate SQL queries.
Approach: Tested multiple LLMs on their ability to generate correct SQL code, evaluating accuracy and reliability across a range of query types. The project reflects a hands-on approach to understanding how AI tools can augment analytical workflows.
