Excel is still the budgeting tool of choice for most planning & forecasting processes. For single user planning requirements Excel is a great tool if there is not a lot of complexity in the data model and with minimal requirements to change model structures. As soon as multiple planners need to be involved and you […]
Welcome to the Managility Smart Insights BlogKeep up to date with the latest tricks & tips for planning, reporting and analysis.
In this overview we are comparing analytics & planning options for cloud based accounting applications (QuickBooks, Xero, Myob)
Power BI offers fantastic ways to integrate data from online sources. Often it is useful to just use parts of that and extend your own data set with details from an online API.
In this blog we cover how you can automatically load Power BI activity logs (or any other Office365 activity) into a database for detailed analysis across all workspaces in your tenant.
Planning, forecasting & simulation are some of our key focus areas. Recently, we did some benchmarks what the optimal configuration
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
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
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.
This video covers how you can realize comprehensive 3 way forecasting and planning solutions with Acterys, Power BI and Excel:
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.