Power BI Connector
For Infor SunSystems & iPOS
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.
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
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