Share on facebook
Share on twitter
Share on linkedin

Acterys 2019.2 Planning, Performance Management & Consolidation

End to End Performance Management on a Unified Platform For Power BI, Excel and Power Platform

Despite adding a 3-figure number of companies to the Acterys client list in the last quarter -and the efforts to support this process- the product team has burnt the midnight oil adding fantastic new planning, data warehousing and consolidation features in the upcoming 2019.2 Acterys update. In particular with the new “Cube Wizard” that adds unparalleled business user driven data warehouse automation features optimized for Power BI and Excel data model use:

Business User Driven Data Warehouse Automation: Optimal Data Models For Power BI and other Analytics Solutions.

In addition to the proven Acterys Connectors for a variety of accounting and marketing systems we are adding the new Cube Wizard feature that enables business users without IT skills to build robust data models from nearly any  source.

In a simple web interface users can choose their desired source (Excel, Power BI tables or relational sources) and just specify their required model specifications: “Time”, “Dimension”, “Attribute” (Level in a dimension) and “Value”.

This will then automatically create data warehouse star schema tables in the Acterys or the client’s Azure SQL cloud tenant or on premise SQL Server. An approach that guarantees optimal performance and easy maintainability (definition of calculations!) optimized for use in Power BI and other client tools.

No More Bad Power BI Models

This revolutionary approach automates weeks of typically necessary data warehouse and model development and ensures that users work on a platform that offers optimal performance and maintainability. We have seen too many bad Power BI models where business users without the necessary background waste time with unnecessary performance impediments and related “DAX nightmares”. Cube Wizard puts and end to that.

All this works of course alongside all the functionality that Acterys users have come to love:
• comprehensive write-back & planning,
• model edits,
• simulating, storing scenarios,
• managed by effective governance features.

Here is a short video that introduces our new baby:

Acterys & Power BI Model PDF Report Distribution

Another key feature added for this release is PDF distribution: users can flexibly design dynamic reports in Excel with a live link to their Power BI or Acterys model and then automatically distribute tailored reports to an unlimited number of email recipients.

Acterys & Power BI Model PDF Report Distribution

Linked Dimension

Acterys offers unlimited flexibility how to structure dimension. Some of our clients asked for some restriction on this to limit changes to items in a predefined list. An important feature to -for example- turn Acterys into a business-driven master data management tool.

In come linked dimensions: you can now setup a column as a linked dimension this means it can only contain elements defined in another list (dimension column).

And we have one more (Steve rest in peace…):

With 2019.2 we have a new visual in the stable:

Acterys Visual Planning

The new visual enables users to plan by just dragging on the bars of a bar chart. An extremely quick way to test new scenarios and gain a comprehensive picture how drivers are affecting your results. Scenarios are not just a temporary insight but can be immediately saved to the central data model. No more messing around with inconsistent spreadsheets:

Acterys Visual Planning

Recent Posts

Top 5 Tips & Tricks For Planning, Budgeting and Forecasting in Power BI & Excel In this blog I am

Planning and Analytics [Infographic]

It is not uncommon for companies to have separate planning and analytics processes or legacy solutions that result in more

Materialize and Synchronize Power BI with a Data Warehouse “Materialize” is a database concept that refers to storing the result

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.