At DentsuGlobalServices, I develop interactive dashboards for media campaign performance analysis using Snowflake, Power BI, and Looker Studio. I build data models and DAX measures to track campaign spend, impressions, clicks, conversions, and other KPIs.
For these campaign dashboards, I bring data from multiple media platforms into KPI, trend, campaign, and channel-level reports. I identify high- and low-performing campaigns and creatives to support media optimization and business decisions.
At Cognizant, I developed Power BI dashboards to track digital marketing KPIs across online campaigns. I used SQL to extract and blend campaign data, and Power Query to automate data cleaning and transformation.
I also analyzed marketing funnels and customer segments, combining web traffic and sales data with SQL. My work included reporting automation with IBM Planning Analytics, Excel, VBA, and Power Query, as well as insights to help improve campaign efficiency and ROI.
