Menu
Close
Have you ever felt the need to effortlessly switch the date ranges within your Pivot Table in Excel? Have you ever wanted to view the data for just one specific time-frame without having to apply a logical filter all the time? When is the last time you were able to get your Pivot Table to […]
Do you have an Excel management pack with multiple worksheets and would like to save it as a PDF for convenient viewing and sharing? In this tip, I’m going to show you how easy this is to do. You have three options for this, but before continuing, there are a few things to take note […]
“When are you introducing user-defined functions for Excel?” This was the big question we had for Microsoft back in the middle of this year (2017). Specifically for us, this meant user-defined functions that were defined in Javascript, and made available through our web-based Excel add-in for the cloud version of Sage Intelligence. We’d asked this […]
In the Sage Intelligence Financial Report Designer, account balances are returned in their “natural format” from your Sage accounting or business management solution. Therefore, credit accounts (with a credit balance) are shown as negative values and debit accounts (with a debit balance) are shown as positives values. However, in financial reporting, there are times when […]
Business Intelligence (BI) has become quite the ‘buzzword’ in the software industry in the last few years, yet many small business owners still view it as the realm of big business only. As we move towards 2020 and information overload becomes commonplace, however, SMBs are now starting to realize that BI can benefit them too. […]
Glen Mund recently requested an ERP Dashboard for Christmas. It was at the top of his wish list, ahead of the “Inception” DVD and a pair of “BOSE” noise reduction headphones. And it was on his list despite the fact that he actually has an ERP dashboard already. You see, his current ERP dashboard is calculated […]
Reason 3: Get immediate ROI Typically the barriers to adoption of BI are cost and complexity. An integrated BI solution makes deployment rapid without any IT hurdles, allowing for an immediate return on investment. Because it is a module of your existing accounting package, no new relationships or extensive IT investments are required. It can […]
Reason 2: Make insightful decisions The ability to make better decisions and proactively solve issues is crucial to success at every level of an organization, every day. And as companies grow or face stiffer competition, the need to make these decisions based on meaningful information quickly becomes an imperative. Most businesses need to be agile […]
ALCHEMEX is the leading developer, enabler and support-provider of affordable Excel-based Business Intelligence (BI) software for small to medium enterprises. Alchemex reporting software provides an integrated, automated, and Excel-based BI solution, presenting preformatted drillable Excel reports, executable at the click of a button. As more and more small and medium enterprises recognize the need for […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.