Financial Performance Analytics Model

A star-schema Power BI model with a 29-measure DAX library covering profitability, growth, efficiency, pricing, and risk

Overview

Analyses financial transaction data across products, countries, customer segments, and discount bands. The semantic model is engineered to support multi-dimensional financial analysis — from top-level revenue and profit summaries down to per-unit, per-transaction, and per-day operational metrics.

Built using the modern Power BI Project (.pbip) format with TMDL (Tabular Model Definition Language), enabling full version control of every model artefact as plain text — model settings, relationships, table definitions, and all DAX measures.

Model at a Glance

29
DAX measures across profitability, growth, efficiency, pricing & risk
Star Schema
One fact table, five dimensions (Date, Product, Country, Segment, Discount)
.pbip + TMDL
Version-controllable model definition as plain text, not binary

Tech Stack & Skills Demonstrated

Power BI Modelling

  • Star-schema design with CALENDARAUTO date table
  • Fact-to-dimension relationship management

DAX Measure Library

  • Profitability & growth (MoM/YoY) ratios
  • Efficiency, pricing-realisation & risk/variance measures

Power Query

  • Transformation pipeline from raw Excel transaction data

Explore the Code

Full DAX measure library and data model reference are on GitHub.

GitHub ↗ Visual Write-up on Notion ↗ ← Back to Portfolio