Power BI: Showcase Project – Expenditure Variance Analysis – V1

An expense variance analysis created in Power BI using Arria’s add-in

This project showcases what you can do with Arria’s add-in for Microsoft Power BI. Power BI users can open and work with this PBIX file to see the interactivity and flexibility of Arria’s natural language generation in action.

Providing flexibly written, insightful summaries of data alongside the visuals in a dashboard, the Arria add-in augments this report with a narrative summary and analysis. The dashboard shows quarterly general ledger data focused on expenditure variance between two periods. The narrative accompanies the other visuals in the report, summarizing the main facts and answering the questions of what were the main drivers of the expense variance, and what were the key expenditure items in the two periods.

Highlights:

1. The narrative provides analysis across multiple dimensions, with cross references.

2. The narrative provides commentary to further explain the key drivers.

3. Real-time drill-down and roll-up of narratives: Users can drill down into and roll up the account dimensions by selecting the account level in the narrative widget.

Narrative for Account Level 2:

Narrative for Account Level 4: