SFIA Reference: DTAN Level 4/5
Data Analyst / Report Writer (Grade 3)
Competency Description
Applies forecasting and advanced analytics techniques to deliver deeper business insights using BI tools and code.
Learning Outcomes
- Use DAX, R, or Python for trend analysis and modelling.
- Apply time series forecasting in Power BI.
- Explain assumptions and outcomes of analytical models.
Evidence Requirements
Level 4:
- Built a forecast visual or trend analysis using DAX.
- Explained KPI variation using statistical tools. Level 5:
- Delivered a predictive model with measurable business value.
- Combined BI visuals with code-based models.
Suggested Learning Activities
- Forecasting with DAX workshop.
- Python/R notebook lab for KPI modelling.
- Reflection on forecast accuracy vs actuals.
Recommended Resources
- KnowHow: “Forecasting in Power BI”
- Book: “Practical Time Series Forecasting” by Galit Shmueli