loader image

Share:

Share on facebook
Share on twitter
Share on linkedin

Financial Reporting in Power BI

The Easiest Way Realizing Financial Reports in Power BI

The default visuals in Power BI are not perfectly suited for financial reporting. There are ways to realize more advanced financial reporting requirements using DAX as Managility describes in Income Statement using DAX These, though typically require intermediate knowledge of DAX that many financial professional don’t necessarily have.

For an easier way to realize financial reports in Power BI, Acterys is adding a new visual to the existing 7 listed Power BI visuals on Appsource.  The new Acterys Reporting Power BI Visual includes:

    Add/Edit Report Calculations With Ease
  • Addition of custom rows and column calculations and subtotals exactly where needed e.g. income statement and balance sheet lines like Gross Margin, EBIT, Return on Equity etc.
  •  Financial reporting format options per row (under/over lines, (), %, scaling etc.) and column
  • Variance visualization according to IBCS principles with dynamic switching between relative and absolute display
  • Unparalleled write-back, planning and business modelling options with all components of the Acterys Suite 8 Power BI Custom Visual, Acterys Modeller, Excel Add-on)
Acterys Reporting Absolute Variance Power BI Desktop
Acterys Reporting Absolute Variance Power BI Desktop
Acterys Reporting Relative Variance

• Row based comments that are stored automatically in Acterys database and can be edited directly in Power BI with Acterys Comments visual

Download the free preview here: Acterys Reporting Preview & Sample File

Detailed documentation of all features is available in the Acterys Wiki

For any comments and feature requests please use the new Acterys Forum

Recent Posts

I can’t help smiling when I see legacy BI/Planning application vendors -that were not so long ago laughing away Power BI- coming out with their own “Power BI Integration” after Microsoft has turned around the industry. These are more often than not nothing but “a marketing spiel” to build on Power BI’s awareness and of very limited use in real life application scenarios.

Across many mid-sized and large companies, finance and operations teams are at crossroads. This was one of the findings from the recent BPM Pulse 2021 survey which revealed that only a third of companies had truly harmonized strategic, financial, and operational plans.

Power BI offers unparalleled features for analysis and visualization: in this post we explain the quickest way to connect Oracle Netsuite in Power BI Deskop and how you can add comprehensive planning and budgeting.After your account has been setup, click on the “Integration” menu and go to the “Oracle Netsuite” section:

The default visuals in Power BI are not perfectly suited for financial reporting. There are ways to realize more advanced financial reporting requirements using DAX as Managility describes in Income Statement using DAX These, though typically require intermediate knowledge of DAX that many financial professional don’t necessarily have.

The Acterys Modeller is cloud based service (with on-premise installation option) that allows enables business users to automatically create optimal analysis models (star schema data warehouse) from a variety to ERP. accounting and SaaS systems. The created models are write and planning enabled and can be edited and extended as needed by business users e.g. for adding new products/attributes, account mappings, new scenarios etc.

Tags