- Analyze existing Excel / SharePoint-based PMO reports
- Clean and standardize data sources
- Deliver improvements in existing Power BI dashboards
- Identify gaps in data structure and reporting logic
B. Data Transformation & Structuring
- Support migration of data to Dataverse (structured backend)
- Assist in defining data models and relationships
- Help establish a single source of truth for PMO reporting
C. Dashboard Development
- Build and enhance Power BI reports:
- Resource utilization
- Project health
- Forecasting / demand planning
- Ensure reports are
- Accurate
- Performance-optimized
- Business-friendly
D. Low-Code Enablement
- Build basic solutions using:
- Power Apps (forms / data capture)
- Power Automate (approvals / workflows)
E. Data Governance & Quality
- Ensure consistency and reliability of data
- Maintain structured data practices
- Highlight and resolve data anomalies
F. Emerging Capabilities (Secondary)
- Support improvements in data usability and accessibility
- Exposure to modern analytics tools (learning-oriented, not mandatory)
4. Required Skills (Must-Have) A. PMO Functional Skills
- Strong understanding of:
- Project Lifecycle
- Resource utilization tracking
- Forecasting and PMO metrics
- Hands-on experience in PMO reporting environments
B. Power BI & Analytics
- Strong experience in:
- Power BI dashboards
- DAX (intermediate)
- Data modeling concepts
- Ability to
- Convert business needs into dashboards
- Work with unstructured data
C. Data Structuring Ability
- Understanding of:
- Data relationships
- Structured vs flat data
- Ability to identify
- Data inconsistencies
- Quality issues
D. SharePoint / Excel Expertise
- Strong experience with:
- SharePoint Lists
- Excel-driven reporting
- Ability to
- Extract, clean, and restructure data
5. Preferred Skills (Good-to-Have)
- Exposure to:
- Microsoft Dataverse
- Power Apps / Power Automate
- Understanding of
- PMO metrics (utilization, forecast, pipeline)