Purpose:To run the stored procedure get.myArchive from Power BI for a series of previous Sundays (for example, the last six Sundays), and optionally combine or parameterise the results. 🧠Background The get.myArchive procedure is designed to retrieve snapshot data for a specified date.By default, Power BI passes a single date parameter such as: However, when … Read more
(Revised for SFIA-8 Alignment) Overview As a Data Analyst / Report Writer (Grade 3) you play a pivotal role in developing insightful reports, dashboards, and data models to support data-driven decision-making. This role involves working closely with the Data Warehouse team, Finance, and Commercial teams, ensuring data integrity, governance, and automation across reporting processes. You … Read more
SFIA Reference: BPRE Level 4 Data Analyst / Report Writer (Grade 3) Competency Description Applies financial and operational understanding to design reports that align with business goals. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: METL Level 4 Data Analyst / Report Writer (Grade 3) Competency Description Works iteratively to deliver reporting solutions, using Agile methods to continuously improve outputs. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: BUSA Level 4 Data Analyst / Report Writer (Grade 3) Competency Description Presents analytical findings with clarity and influence using compelling visuals and narrative techniques. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: INCA Level 4 Data Analyst / Report Writer (Grade 3) Competency Description Integrates Power BI with APIs, external data services, and other platforms to enrich reporting. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
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 Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: INAN Level 4 Data Analyst / Report Writer (Grade 3) Competency Description Enables business teams to access and explore data independently through certified datasets and reusable models. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
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 Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: DATM Level 4 Data Analyst / Report Writer (Grade 3) Competency Description Ensures accuracy, security, and traceability in reporting through effective data governance and QA practices. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources