Easily analyse your Infor SunSystems data

As an Infor SunSystems user, you may be experiencing firsthand the challenges of applying modern analytics tools such as Power BI to uncover insights from your financial data. This challenge is not only limited to the analysis of SunSystems data, but also combining it with other non-SunSystems data for a 360° view of the business.

As a Microsoft and Infor partner with years of experience, Professional Advantage can help you solve this challenge. We have developed a data connector to help you automatically extract and load your financial data into Power BI. The Professional Advantage Power BI Connector solves the problem of automating the data extraction from an Infor SunSystems database and translating it into an Microsoft Power BI data model. This allows Power BI users to drop data entities on to their reporting canvas and build up effective visualisations and analytics without having to understand anything about the underlying Infor SunSystems database schema.

Get a single point of view with Power BI's ability to combine data from hundreds of data sources. Built-in functionality allows users to slice, dice and transform data using built-in or custom visuals. Then choose what and when to publish and share insights.

What is the Power BI Connector for Infor SunSystems?

 We have done all the hard work for you.

Our Connector solves the problem of automating the data extraction from an Infor SunSystems database and translating it into an Microsoft Power BI data model. This allows Power BI users to drop data entities on to their reporting canvas and build up effective visualisations and analytics without having to understand anything about the underlying SunSystems database schema.

Our connector for SunSystems translates data in to a meaningful and easily understood format, while offering flexibility to configure the system and controlling the scale of data extracted in to the Power BI reporting warehouse along with the content, such as Business Units, Ledgers, Chart of Accounts and Analysis Dimensions.

Our connector includes a web-based application interface where you can define how many periods you wish to import and which of these are summary totals, and which are transactional data. Meaning you do not have to populate the Power BI warehouse with transactional data where not needed for analysis.

You may also have some data in SunSystems which you do not want to make available in the reporting warehouse, such as payroll data, or other sensitive information. The interface allows you to define exclusion definitions, which remove data sets based on Business Unit, Chart of Account, Analysis Dimensions, or ledgers.

Security is obviously of utmost importance in reporting on financial data. The Connector caters for this with an embedded a Row-Level Security (RLS) model through the data which allows you to control which data users can view in the data model, as well as providing Data Set Exclusions to exclude confidential accounts and analysis from the data warehouse extract giving you confidence in the outcome.

Infor SunSystems Data Reporting made easy with Power BI

  • Drag and drop Infor SunSystems data entities delivered to Power BI canvas
  • Understands SunSystems data structures out of the box
  • Web interface for extraction and security control
  • Consolidate data from multiple systems together with Infor SunSystems data and analyse it in one report
  • Selected extraction of data by Business Unit, Ledger, Chart of Accounts, and Analysis Dimensions
  • Ability to define summary or detail transactions for different time periods
  • Exclusion rules to remove unwanted data from extract by Business Unit, Ledger, Chart of Accounts and Analysis Dimension
  • Builds out a register for all changes in the SunSystems database and, leverages Power BI's incremental refresh capabilities to ensure the data warehouse is up to date. This only extracts new data available in Infor SunSystems
  • Additionally works for iPOS eProcurement data in the same connector
  • Includes a security model to allow Row Level Security across Business Units, Ledgers, Accounts and Analysis Dimensions
  • Power BI helps streamline reporting workflows by automating processes and eliminating inefficiencies associated with the extraction and manipulation of data.
  • Power BI significantly reduces the time spent on creating and preparing month end reports. Transformation rules are set once and data updated in real-time
  • The powerful visualisations in Power BI make it possible to present complex data in an easy to digest way with data interactivity and relationships
  • With its built-in collaboration capabilities, Power BI makes it easy to share and collaborate on data with not only Infor SunSystems users, but also users with the organisation that do not have access to Infor SunSystems but utilise its data in their business role, such as executive level managers, cost centre or department managers.

Talk to us

"I was amazed at the features provided. It surpasses by far the Q&A add-on, as well as other solutions on the market."

Infor SunSystems Data Reporting made easy with Power BI

Removes the requirement for in depth, database level understanding of Infor SunSystems in order to surface data into the Power BI canvas

Save hours of internal effort in producing the same results

Always up to date

Start creating reports almost immediately after the simple & rapid implementation

Does not impose a report structure or limit report creation

Download brochure

Considering Power BI Connector for Infor SunSystems?

Complete the form below, or contact us on 1800 126 499 to speak to one of our experts today.