Excel Power Query

Excel Power Query seamlessly integrated with Advanced Business Manager (ABM), Excel Power Query empowers users to effortlessly extract data from various sources, including databases, spreadsheets and online services and then manipulate it according to specific requirements—all without the need for complex coding.

The beauty of Excel Power Query lies in its ability to automate repetitive tasks. Once a query is set up, it can be easily reused with a simple refresh command, saving valuable time and effort. This means that users can focus on analyzing data rather than wasting time manually extracting and formatting it.

With Excel Power Query, accessing and interpreting data from the ABM database has never been easier. Users can choose from a selection of pre-built template reports that seamlessly link with the ABM database, ensuring that the data presented is always accurate and up-to-date. Whether it’s financial reports, inventory summaries or sales analytics, Excel Power Query provides the tools needed to transform raw data into actionable insights.

One of the key features of Excel Power Query is its interactivity. Users have the flexibility to interact with reports based on various parameters such as Job, Sub-Contractor, Cost Centre, Supplier or Client. Whether they want to focus on a specific job or analyze data across multiple accounting periods, Excel Power Query makes it possible with just

a few clicks.

Real-time updating capabilities

Furthermore, the real-time updating capabilities of Excel Power Query ensure that reports are always current. With a simple refresh, the latest transaction posted to the ABM database is immediately reflected in the report, eliminating the need to manually export and reformat data.

As part of the ABM Power Query Package, users gain access to the ABM tables where reports can be designed to address common business needs. When you design these reports, they can serve as a solid foundation, providing valuable insights into various aspects of the business operations. However, should further customisation be required to meet specific business requirements our team is ready to assist in “tweaking” the reports accordingly.