Sharing local file links to Power BI (.pbix) reports may seem convenient, but it creates significant risks for your data, your reports, and your organisation. Here’s why this approach should be avoided in any enterprise environment. 1️⃣ It Creates Multiple, Conflicting Versions of the Same Report When a .pbix file is shared via local file … Read more
Role Purpose The Head of Reporting & Analytics Delivery provides leadership for the organisation’s reporting, analytical outputs, and stakeholder-facing data products. The role exists to ensure that: The role focuses on: Scope and Impact The role: The Head of Reporting & Analytics Delivery operates with: Key Responsibilities (SFIA-8 Aligned) Strategy and Direction (SFIA: Information Strategy, … Read more
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