Matrix visual · Capability by area
Technical Proficiency
The full technology stack behind the reports — grouped the way a delivery team is actually organised, from modelling through to automation.
Core BI & Modelling
Semantic models, measures and report design
Power BI
Enterprise report and model design end to end.
DAX
Time intelligence, context control, tuned measures.
Power Query
M transformations and query folding discipline.
Data Modelling
Star schemas, conformed dimensions, grain control.
Excel
Pivot analysis and stakeholder validation.
Analytics Products & Delivery
Shipping governed reports to real users
Power BI Service
Workspaces, apps, refresh and distribution.
RLS & Security
Role-based access for sensitive datasets.
Performance Optimisation
Model size, DAX cost and visual load tuning.
Deployment Pipelines
Dev → test → prod promotion with governance.
Fabric & Data Engineering
The data layer under the reports
SQL
Complex queries across Postgres, Snowflake, Azure SQL.
Microsoft Fabric
Lakehouse and OneLake based analytics workloads.
Dataflows
Reusable cleansing layers shared across models.
Data Pipelines
Automated multi-format ingestion and validation.
Automation & Productivity
Removing manual work around the reports
Power Automate
Approval flows, alerts and scheduled notifications.
Power Apps
Intake apps feeding governed datasets.
Python
Data cleansing and validation in notebooks.
Git & GitHub
Versioning for SQL, DAX and pipeline assets.
AI Assisted BI
Copilot and LLM assisted measure and doc authoring.