Menu
Close
In a climate of economic volatility, changing consumers, and globalized competition, small to medium-sized enterprises (SMEs) perhaps need access to accurate, actionable business insight into data even more than bigger enterprises do. Most SMEs are operating on tight margins and don’t have endless reservoirs of cash and credit. They need up-to-the-minute information about trends in […]
Many companies today suffer from a lack of visibility into key performance metrics. We call this “keyhole visibility” because it’s the equivalent of trying to evaluate what’s happening in a room by looking through the keyhole. With a narrow view, you’re unable to fully understand what’s behind the door and what might be lurking around […]
A dashboard is a business tool that displays a set of metrics, KPIs and other relevant information to a business user. Dashboards are here to stay because of their simplicity and self-service capabilities. And recently, Microsoft has made dashboards even more relevant, visual and efficient to use through Power BI. Haven’t heard of it? Here’s […]
In our last tip, I showed you how to create a Consolidation Connection in the Connector module, which lets you combine data from different companies into a single report to obtain a holistic view of your organization. If you would like to review the tip, you can find it here. Once one is created, there […]
Multiple users can effectively work on a spreadsheet by sharing it, and then collaborating on it. Edits can be made simultaneously by team members, thus having a continuously updated version of the spreadsheet available all the time. In this way, version control is enforced, and duplicate work is eliminated. Applies To: Microsoft® Excel® for Windows […]
With a good business management solution that manages your finances and operations all in one system, you can gain company-wide visibility into your business so you know where you’ve been, where you are currently and where you will end up in terms of cash spent, time and schedule commitments met. In addition, you can keep […]
I read an interesting article the other day about how a novel targeted at young, single females and housewives wasn’t selling as well as expected. When the publisher looked deeper into its sales data, it found that this market segment made up only a small portion of readers – and that the majority of buyers […]
Sometimes when working in Excel, you may want to compare two versions of a workbook to see what was changed. It could be an issue such as totals that are manually entered instead of formula calculated that you want to check. You can use Microsoft Spreadsheet Compare to run a report on the differences, and […]
Did you know that apart from being able to run reports out to Excel, Sage Intelligence allows you to switch output modes which can be useful when designing and debugging reports? Two additional options are provided, output to Screen and output to SQL. Output to Screen does away with rendering a report to Excel and […]
Charles Teversham, MD of Sage Intelligence, considers the benefits of moving from a feudal model of sharing data to a more democratic one. In 13th century Europe, literacy was largely confined to the clergy and some elites, and few adults among the general population could read or write. But that picture changed as a result […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.