Online Video Campaign Performance Dashboard – Procter & Gamble
During my 2025 summer internship at Procter & Gamble, I managed an online video campaign in the mobile gaming space and uncovered a major cost inefficiency. I discovered we were buying the same ad space twice — once publicly and once privately — but paying double for the private version. By digging into specific gaming publisher sites and comparing delivery data, I proved the overlap and helped save the company significant spend. To prevent this from happening again, I built an automated SQL reporting system that updates live data in Excel, allowing the team to monitor publisher performance long after my internship ended.
Visualizing Performance: Power BI Dashboard – Kohler Co.
At Kohler Co., I was asked to solve a simple but frustrating problem: the sales team had data everywhere, but no easy way to see what was actually happening. I built an interactive Power BI dashboard that pulled together category-level sales, weekly goals, and top-selling products into one clear, visual tool. For many sales reps who weren’t comfortable with spreadsheets, this was the first time they could instantly understand their performance without digging through reports. The dashboard gave them real-time visibility across multiple stores and became a daily resource for tracking progress, spotting trends, and making confident decisions.