Streamlining data modelling in Fabric with Acterys

Table of Contents

Acterys is all about taking you further faster – and that’s particularly the case when we work within the unified Fabric analytics platform. Fabric’s ability to bring together hundreds of data sources from across an organization combines with Acterys to create integrations that unlock new levels of agility, scalability, and intelligence across your data, planning, and analytics ecosystem.

Because Acterys offers unrivalled enterprise write-back and planning capabilities, users get to connect, model, plan and act within one seamless environment. Here Acterys effectively provides the connective tissue that turns deployments into a truly bidirectional application environment – rather than just a standard reporting engine.

However, delivering at this scale demands simplification – whether that’s the ability to edit data directly in reports, or ensure that your Fabric and Power BI models require zero manual set-up. That’s where the Acterys Modeller data modelling tool makes such a difference, helping users to manage all aspects of financial planning and analysis – and enabling the integration with major ERP, accounting, SaaS, Fabric and Power BI datasets in minutes.

With Fabric’s data foundation and Acterys’ unrivalled write-back and planning capabilities, Modeller offers advanced capabilities for building financial models. Data is collected from multiple sources for consolidation into a single financial data model. Dashboards then visualize model outputs, letting stakeholders interpret results quickly and effectively. Acterys Modeller also ensures scalability, allowing models to adapt and evolve by incorporating new data sources and expanding analysis dimensions. Finally, Modeller helps keep your models current by syncing with live data feeds to enable continuous decision-making.

Empowering non-technical end-users with Modeller
With ready-made or drag-and-drop planning models and pre-built templates, Acterys Modeller provides a great way for the Office of the CFO and key business users to build unique tools to solve their emerging challenges. Modeller empowers non-technical end-users, helping them to manage their models within Fabric, enable true self-service planning, and remove their reliance on the corporate IT function.

Capabilities like Acterys Modeller certainly make a difference when organizations need to move quickly with their deployments. At AMAG, the biggest Volkswagen Group dealership group in Switzerland, the company was keen to deploy a solution that was intuitive for end-users. According to AMAG Retail’s Financial Controller Reto Haupt: “We were able to finish the project in just five months, from initially learning Acterys through doing the data model and integrating different sources, implementing Power BI reports, and completing all the Acterys write-back visuals. Tools like Acterys Modeller certainly helped, ensuring that we didn’t need deep SQL skills – apart from building views – in order to connect different data. Adopting a lean and agile execution method proved the right approach for AMAG Retail.”