Financial Performance Analytics Model

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

View on GitHub ↗

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.

Key Results

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

Project README

Pulled live from the GitHub repository — always in sync with the source.

Explore the Code

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

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