🚫 Why Sending Local Links to Power BI Files Isn’t an Enterprise Solution

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

Head of Reporting & Analytics Delivery (Grade 5)

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

Running a Stored Procedure for Multiple Dates in Power BI

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

Data Analyst/Report Writer (Grade 3)

(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

BI305: Advanced Analytics & Forecasting

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

BI304: Self-Service Analytics Enablement

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