Portfolio

A showcase of Power BI reports

Six interactive reports exploring custom KPIs, field parameters, variance visualisation, and storytelling — built from real-world business problems.

6 reports Live Power BI embeds Interactive

Healthcare

Hospital Revenue Performance & Drivers

This report actually helped me to land my first PBI Dev contract with a private healthcare provider.

This is why it’s good to have a report showcase portfolio. Even better if your data is related to the industry in which you would like to work.

KPICustom TooltipsHealthcare

View Full Project

hospital-revenue.pbix

Sales

Onyx Data Challenge, Sales Analysis

This report gives insight into customer sales metrics like moving averages, new/returning customers, and satisfaction metrics.

The middle line chart uses a secondary y-axis that consistently shows all sales when dimensions are filtered, so the user can see what proportion of the whole the selected dimensions make up.

Moving AvgCohortsSecondary Axis

View Full Project

onyx-sales.pbix

Profit

Service Profit Analysis

This project explores the capabilities of field parameters.

Field parameters are a winning PBI feature for building highly interactive visuals. In this example users can dynamically control the displayed metrics, adjust date granularity, and see appropriate number formatting with the click of a button.

Field ParametersInteractivity

View Full Project

service-profit.pbix

Revenue

Revenue Analysis

This report focuses on showing variances to a selected metric (target, last year or 2 year’s ago).

The KPI in the top right shows an overview of the selected year and all of the comparatives while the line chart gives the detail on a monthly basis. This report also makes use of the very awesome PBI feature, field parameters.

VarianceKPIField Parameters

View Full Project

revenue-analysis.pbix

Dashboard

Revenue & Gross Profit Dashboard

This report makes use of a Top N selection as per business line (department).

This report also makes some great use of field parameters for selecting visible chart metrics. Report users are also able to sort the charts by revenue or gross margin via a slicer.

Top NField ParametersSlicers

View Full Project

revenue-gp.pbix

Variance

Variance Highlights with Stacked Bars

An exploration of what can be done with stacked bar charts in Power BI, this report showcases an alternative way of presenting a variance to last year.

The size of the variance is represented by the red or green stack to quickly show the reader where the gains and losses are coming from.

VarianceStacked Bars

View Full Project

variance-stacked.pbix