With an ERP system already in place, some businesses are hesitant with integrating third-party business intelligence or data analytics solutions because it may add more complexity to the way they work.
Instead, they rely on Microsoft Excel for its basic and intuitive reporting functions. Luckily, there’s Velixo – an analytics solution that connects your ERP system to Microsoft Excel.
According to an article on Velixo, the ERP system is the central repository or source of data while Excel acts as “the presentation layer”. In Australia, Velixo was built for MYOB Advanced.
How Velixo and Excel Work Together
Over the years, Microsoft Excel has gone through fundamental evolutions to improve their solution. In 2010, they modified the spreadsheet format to a million rows on a worksheet. Subsequently, they introduced the Dynamic Array Formula in Excel 365 – a game-changer in business’ way of working with data.
The Dynamic Array Formula allows formulas to return multiple results to a range of cells on the worksheet based on a single formula entered in one cell.
For Excel Users, this provides greater control over their data, allowing them to access and return to their datasets for analysis. However, this function can be very complex and requires advanced Excel skills to use them both effectively and efficiently.
Velixo simplifies this process through a set of functions, allowing even those who are not advanced Excel users to take advantage of The Dynamic Array Formula and other complex Excel operations.
Velixo General Inquiry Functions
Now, let’s talk about the General Inquiry Velixo Functions that make data analytics and reporting on Excel much easier and allow users to extract data effectively and efficiently. Here they are:
- GI Function
- GIFILTER Function
- GILOOKUP Function
- GILOOKUPF Function
Through the GI Function, users can extract a set of data from any Generic Inquiry within MYOB Advanced which can be analysed with standard Excel tools to create comprehensive reports.
Some may suggest that this is easy to do natively Excel, however inexperienced users may not be as efficient. Velixo also provides an added layer of security and filters upon extract, as opposed to applying filters once data is within the workbook. This can be done with the GIFILTER function.
The GIFILTER Function allows users to set parameters that filter data instead of returning raw Odata. With this feature, Excel criteria syntax such as <>, >=, =, and more can be used instead of Odata syntax. Smarter and quick reporting is achieved because data can already be filtered upon extract.
So, where to with this information?
Now, as you write Generic Inquiries on any data within MYOB Advanced, you can use Velixo to provide insights across any dataset with ease and efficiency.
Security is also a big advantage in choosing Velixo because it provides improved security settings, restricting access to data within MYOB Advanced only to those who are allowed.
If you’d like to know more about the other functions of Velixo or would like to know how to integrate it with your MYOB Advanced system, reach out to our friendly team!
AlphaBiz Solutions also has business intelligence software partners for non-MYOB Advanced users, such as Alchemex and Power BI. We also provide MYOB Advanced support, MYOB Exo Support, and Sybiz Vision Support.
