OMG Compliance Report

HP
Overall Performance
53.7%
Cumulative average
👥
Total PMs
29
Project managers analyzed
📈
Total Deliverables
581
Audit entries processed
🏆
Top Performers
87.0%
Christian Barandica

🎯 Overall PM Performance Ranking

🛠️ QC Tool Usage Leaderboard Feb 11 Report

📈 Overall Performance Trend

Monthly Performance
Overall Cumulative Average

📊 Performance Trend per Category

📈 Department Performance Trend

🏢 Department Performance Rankings

Q1 Performance
—
Nov – Jan Average
🏆
Q1 Top Performer
—
—
👥
Q1 Active PMs
—
Across Nov – Jan

🎯 Q1 Combined PM Performance Ranking

🏢 Q1 PM Department Performance Rankings

📈 Q1 Performance Trend

Monthly Performance
Q1 Average

📊 Q1 Category Trend

📈 Q1 Department Performance Trend

Q2 Performance
—
Feb – Apr Average
🏆
Q2 Top Performer
—
—
👥
Q2 Active PMs
—
Across Feb – Apr

🎯 Q2 Combined PM Performance Ranking

🏢 Q2 PM Department Performance Rankings

📈 Q2 Performance Trend

Monthly Performance
Q2 Average

📊 Q2 Category Trend

📈 Q2 Department Performance Trend

Overall Performance
18%
Cumulative average
👥
Total Studio Members
29
Studio artists analyzed
📈
Total Deliverables
90
Studio entries processed
🏆
Top Performer
72%
Emmanuel Nkhumeleni

🎨 Overall Studio Performance Ranking

📈 Overall Performance Trend

📊 Performance per Category

📈 Department Performance Trend

🏢 Studio Department Performance Rankings

Q1 Performance
—
Nov – Jan Average
🏆
Q1 Top Performer
—
—
👥
Q1 Active Studios
—
Across Nov – Jan

🎨 Q1 Combined Studio Performance Ranking

📈 Q1 Studio Performance Trend

Monthly Performance
Q1 Average

📊 Q1 Studio Category Trend

📈 Q1 Studio Department Performance Trend

Q2 Performance
—
Feb – Apr Average
🏆
Q2 Top Performer
—
—
👥
Q2 Active Studios
—
Across Feb – Apr

🎨 Q2 Combined Studio Performance Ranking

📈 Q2 Studio Performance Trend

Monthly Performance
Q2 Average

📊 Q2 Studio Category Trend

📈 Q2 Studio Department Performance Trend

📊 Executive Summary Report

🏆 Top Performers

🥇 Top PM
Christian Barandica
87.8% Overall
52 deliverables | Solutions
🥇 Top Studio
Octavio Casiano Gavino
76.9% Overall
13 deliverables | .COM/Large Format/UI/UX

💪 PM Category Strengths

Line Items 91.1%
Job Category 57.4%
Approval 51.8%

⚠️ PM Category Weaknesses

Notes 27.5%
Required By 39.1%
PM Assign 42.9%

💪 Studio Category Strengths

Deliverable Assets 54.6%
Review Tool 44.7%
Box 26.8%

⚠️ Studio Category Weaknesses

Studio Notes 18.3%
Studio Assign 18.7%

🔴 Performers Needing Improvement

The following team members are scoring below 20% overall and need immediate attention:

Name Type Overall Score Deliverables Failing Categories
Maryorith Gonzalez PM 16.7% 16 PM Assign (0%), Required By (0%), Notes (0%), Job Cat (6.2%), Approval (6.2%)
Neha Sayana PM 16.7% 2 PM Assign (0%), Required By (0%), Notes (0%), Job Cat (0%), Approval (0%)
Manan Aggarwal PM 16.7% 1 PM Assign (0%), Required By (0%), Notes (0%), Job Cat (0%), Approval (0%)
Multiple Studio Members Studio 0% Varies All categories at 0% - 40+ studio members with zero compliance
⚠️ Critical Action Required:
  • Immediate one-on-one meetings with underperformers
  • Review and clarify compliance requirements for Notes, PM Assign, and Required By fields
  • Implement mandatory training for Studio Assign and Studio Notes
  • Set up weekly check-ins to monitor improvement

📤 Upload Audit Data

Upload a new Excel file matching the format of HP_OMG_Audit_Mar6.xlsx to recalculate all dashboard data.

📁

Drag & drop your .xlsx file here

or click to browse

📋 Expected File Format

The Excel file should have a single sheet with columns in this order:

  1. Deliverable Number
  2. Brief Date
  3. Deadline
  4. Owner (PM)
  5. Studio
  6. Copywriter
  7. QA
  8. PM Assign
  9. PM Required By
  10. Studio Assign
  11. PM Notes
  12. Studio Notes
  13. Deliverable Assets
  14. Review Tool
  15. Job Category
  16. Line Items
  17. Box
  18. Approval Rounds

Compliance is marked with a bullet character (•). Dates determine the month bucket (Nov, Dec, Jan, Feb).