Intern, Data Analytics
singpost ·
- Seniority
- Intern
- Employment
- Internship
- Category
- Data analytics
- Company size
- 501-1000
Builds interactive Power BI dashboards, defines KPIs, and documents data workflows while learning data cleaning, automation, and business insights for SingPost.
Job Description
Project Scope & Key Deliverables:
1. Interactive Dashboard Development: Construct live, interactive dashboards using corporate standard tools (e.g., Power BI)
2. Metric Framework Design: Define and align key performance indicators (KPIs) relevant to the business unit's current goals.
3. Documentation & Handover: Draft a simple workflow detailing data refreshing protocols, dashboard logic for future maintenance.
Learning Outcomes & Objectives:
1. Clean and Transform Data: Master real-world data techniques to handle missing variables, duplicates, and inconsistent formatting.
2. Execute Automated Reporting: Set up scheduled data refreshes and low-maintenance data updates.
3. Translate Data into Business Insight: Deliver actionable recommendations during stakeholder presentations.
Prerequisites / Skills Required:
Excel Mastery: Advanced formulas (VLOOKUP/XLOOKUP, INDEX/MATCH), pivot tables, and basic Power Query knowledge.
BI Tool Familiarity: Basic exposure to Microsoft Power BI.
Foundational Python: Understanding how to write basic data queries.