Decision making in uncertain times The power of Nectari for Sage 200 users

Reporting, analytics, BI, dashboards – there are so many terms to talk about the tools needed to get access to data but ultimately, it’s about making meaningful business decisions.

And over the last 12 months that has been more relevant than ever before. As business leaders, our decision-making skills have been put to the test and individuals and teams that have had real time information about the health of their business at multiple levels have been able to make more precise decisions in this uncertain world.

What’s clear is the uncertainty around us isn’t going away any time soon. But what can support decision making at every level is having the tools to access knowledge and understanding within your world to direct everything from strategy and innovation to day to day decisions at an operational level.

At Datel we have partnered with Tangerine Software to bring Sage 200 users a reporting and analytics platform that has been utilised by our Sage X3 support customers for over 10 years. Nectari (aka Sage Enterprise Intelligence) can now bring insight and knowledge to businesses with Sage 200 at the core of their operations.

Here are the top five reasons why Nectari should form part of your BI, reporting and analytics strategy in 2021:

1. You can continue to work in Excel

Excel is much loved and instrumental to decision makers across businesses with many creating cumbersome reports and downloading data from core systems. The challenge comes from how quickly data can be out of date, incomplete or full of errors.  With the Nectari Excel add-in, the solution combines the robust capabilities of Excel with the power of Nectari.

You can access your data in real-time and eliminate the need to manually update worksheets with data from your ERP. Not only will you receive the most up-to-date information from your BI solution, but you’ll also be able to edit fields and push them back to the database. This means that you can continue to manage your budgets using Excel.

Here’s a few other things you can do with the Excel add-in: 

• Use the formula wizard to create calculated fields.

• Create flexible ad-hoc reports by combining data from different departments into a single worksheet.

• Automatically extract dimensional data from Nectari Data Models to list in a column or row for fast report creation.

• Set parameters on dimensions to help filter data used within formula calculations. Create pivot tables and slice and dice data.

• Maintain the same level of security and user permissions as Nectari, with single sign-on.

The Nectari Excel Add-in can be installed and configured quickly and it integrates into the Microsoft Excel interface.

2. It’s easy to use

Any BI tool is only as good as it’s users’ ability to get at the data they need, in the format they need it in to make decisions.  Nectari was created with the goal to empower all employees, technical and non-technical, and to remove the barrier of relying on IT to provide users with the reports they need to do their jobs.

With a few clicks, you can create and customise views for your specific requirements. Manipulate your enterprise data with easy-to-use features like filters, pivots, ranks and KPIs. Analyse your data in the most meaningful way, with over 100 visualisations and flexible reporting with advanced calculations and customisation options.

3. Nectari comes with pre-set data models

Often, BI strategy is let down by the time it takes to build meaningful insight dashboards and reports that are specific to the decision makers needing access to the data. Serving as a central hub for all data sources, the Universal Data Models makes it easy to consolidate and access large amounts of data and turn that data into actionable insights for smarter business decisions.

Universal Data Models for Finance, Sales, Inventory and CRM provide hundreds of KPIs that adhere to reporting standards. Whether you use the predefined dashboards and reports (or choose to create your own) with the Universal Data Models, you’re equipped with everything you need to analyse your enterprise’s activities, performance, and profitability. The Universal Data Models require minimal set-up and can help boost your company’s performance from the day you start working with Nectari.