Power BI: Showcase Project – Expenditure Variance Analysis – Version 2


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

Enter your Studio email below to access this sample

 

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 Articulate Intelligence 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:

 

  • Analysis of multiple dimensions and measures. The narrative provides analysis across multiple dimensions, with cross references.

 

  • Additional commentary. The narrative provides commentary to further explain the key drivers.

 

  • Real-time drill-down and roll-up of narratives. You can drill down into and roll up the account dimensions by selecting the account level in the narrative widget. With Arria’s add-in, you can have up to four levels of drill-down and roll-up, on any hierarchical dimension.

 

  • Copy to clipboard. You can copy/paste the narratives generated to embedded-formatting tools such as Microsoft Word and Microsoft PowerPoint.

 

Note: In order to use the Open with Studio button in this showcase project, you need to make it your own by publishing it yourself.
 (For information on publishing a project, see the NLG Studio documentation.)