SFIA Reference: DENG Level 4
Data Analyst / Report Writer (Grade 3)
Competency Description
Transforms and prepares data for reporting using Power Query (M) and SQL, integrating with data pipelines.
Learning Outcomes
- Cleanse and shape data using Power Query.
- Write efficient SQL queries to feed BI datasets.
- Collaborate with engineers to streamline transformations.
Evidence Requirements
Level 4:
- Built a reusable Power Query transformation for reporting.
- Created SQL views to support BI models. Level 5:
- Designed transformation patterns adopted team-wide.
- Audited and refactored inefficient ETL logic.
Suggested Learning Activities
- Transformation lab: From raw to report-ready.
- Reflection: Performance tuning Power Query steps.
- SQL script optimisation exercise.
Recommended Resources
- KnowHow: “Power Query Tips and Patterns”
- Microsoft Learn: Query Performance Tuning