Value-Based Campaign Optimization
Implemented a value-based optimization strategy for paid acquisition campaigns in Mexico. By improving bidding signals and aligning media investment with customer value, the project increased ROAS by 10%.
I built an AI-powered chatbot for Tableau that allows users to interact with their existing dashboards and data through natural-language questions.
Instead of manually navigating through multiple Tableau workbooks to find a specific metric or insight, users can ask the assistant what they need and receive relevant information from the available Tableau data and dashboards.
The solution adds a conversational AI layer directly to the existing BI workflow, helping users explore their data and find the right dashboard or report without changing how their Tableau environment is structured.
Client had raw sales data (14 rows across UK/USA, split by quarter) and needed it turned into something actually usable. I cleaned it up and built a PivotTable that breaks total sales down by rep and country, with grand totals for both.
What I did:
Structured the raw data into a proper table (consistent headers, currency formatting)
Built a PivotTable summarizing Sum of Sales by Last Name and Country
Used SUMIFS so the totals update automatically if the source data changes — nothing hardcoded
Checked every formula for errors before delivery
Delivered as a working .xlsx file, ready to plug into a bigger report or dashboard.
If you've got messy sales/ops data sitting in a spreadsheet and need it turned into something you can actually read at a glance, this is exactly the kind of thing I can help with.