Home - Page 2 of 4 - Analytics | Planning | Power BI | PowerApps

Power BI/Analysis Services vs Power Pivot Comparison for Planning Scenarios

by Managility Team | Nov 12, 2018 | Acterys, Excel, Financial Planning & Analysis, Planning, Power BI

Planning, forecasting & simulation are some of our key focus areas. Recently, we did some benchmarks what the optimal configuration

Bulk Measure Operations in Power BI

by Managility Team | Sep 17, 2018 | Power BI

A requirement that we face very often in our projects is to be able to easily re-use multiple measures particularly when dealing with similar data models

Recipe For Crispy Profit & Loss Statements with Dynamic Sub Totals in Power BI / Excel / DAX)

by Managility Team | Aug 13, 2018 | Acterys, Financial Planning & Analysis, Financial Reporting in Power BI, Planning, Power BI

As I see lots of ongoing questions and misinformed comments (“Power BI can’t be used for financial statements”) on the topic, I will cover a simple approach to realize

How to Realize Dynamic Asymmetric Reports in Power BI / Excel

by Managility Team | Aug 10, 2018 | Excel, Planning, Power BI, Uncategorized

In this blog we cover how to realize asymmetric reporting requirements dynamically in a Power BI Matrix or Pivot Table. This is a typical requirements in financial forecasting & reporting.

3 Way Forecasting & Planning with Power BI, PowerApps and Acterys

by Managility Team | Jul 10, 2018 | Planning, Power BI, Powerapps

This video covers how you can realize comprehensive 3 way forecasting and planning solutions with Acterys, Power BI and Excel:

5 Tips & Tricks for Financial Reporting in Excel

by Managility Team | Apr 17, 2018 | Acterys, Excel, General Business Intelligence

Excel is likely the most comprehensive, and widely used application software. In more than 20 years in the BI industry I still have yet to see a more versatile solution.