Quintin Rohrbaugh Dashboard

Project Goals

Project Goals
MARKET RESEARCH
2024-2025
Q1 Q2 Q3 Q4
Objectives Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Score
Develop Datassential Integration Plan + 0

Develop plan for the integration of Datassential concept testing scores into PowerBI for Foodservice team.

Create Database for Brandformance +

Create a new database for tracking Brandformance scores.

Audit Based Power BI Reports +

Develop reports in PowerBI based on the audits of retailer compliance with Susan G Komen, Super Bowl and Cinco merchandising programs.

Project Goals
AFM INTELLIGENCE
2024-2025
Q1 Q2 Q3 Q4
Objectives Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Score
MHAIA Data Security Policies + 0

Assess and implement MHAIA and APEAM Fabric and Power BI data and user security policies.

Reassess and implement updated Coupon Dashboard and Process +

Develop Coupon dashboard for Shopper & Trade team analysis.

Planning Kickoff +

Develop and present annual market insights report as kick-off for AFM planning sessions. Presentation should ground all teams and strategic partners in category performance across businesses and overall market trends, and serve as basis for opportunity assessments. Involve agency partners to present areas of expertise, including media, shopper, consumer insights.

Incorporate Country of Origin Audit Results Into Reporting +

Incorporate Country of Origin audit results into centralized reporting.

Fabric Architecture Assessment +

Asses Fabric data model and implement, and document any new efficiencies.

Power BI Analyst Certification +

Obtain Microsoft Power BI Analyst certification to improve development skills and to identify optimization opportunities.

Quarterly CoE Meetings + 1 1 1 i1

Lead quarterly CoE meetings to improve company understanding of reporting and upskill on utilization.

Document CoE Processes +

Document CoE Processes

Create CoE Source Library +

Create CoE Source Library

Project Goals
MARKET INTELLIGENCE
2024-2025
Q1 Q2 Q3 Q4
Objectives Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Score
Tentpole Calendar + 0

Create Tentpole calendar for internal reporting.

MHAIA Reporting +

Assist MHAIA analyst in creating MHAIA reports and publishing them to their website.

Placer.ai Integration +

Integrate Placer.ai data into the Fabric warehouse.

Media Data Integration +

Integrate media and digital data into AFM's reporting platform.

Mexican Data Source Integration +

Integrate MHAIA and APEAM data sources into the Fabric warehouse to have a unified place for data and reporting.

Assess Agency Data Provisions and Efficacy +

Provide annual assessment, including potential improvements, of sales and panel data providers' delivery of data extracts or connections (NielsenIQ, 84.51LLC, Numerator, Circana, Datassential, Placer.ai).

Project Goals
LONG-TERM STRATEGY
2024-2025
Q1 Q2 Q3 Q4
Objectives Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Score
Integrate Admin Data + 0

Integrate Dataverse data and correctly data model all of the admin data.

Develop Executive Scorecard KPIs +

Provide ongoing reporting of KPIs through the Executive Scorecard and develop KPI spotlights for office monitors end of October.

BHAG Goals