Menu
Close
When working with Sage Intelligence, you may feel the need to make changes to your reports using functionality that isn’t included online, like adding tables, charts, trendlines, etc. If this is you, then Sage Intelligence has you covered by allowing you to download and open your reports in Microsoft Excel, giving you access to standard […]
In our last tip, we looked at the functionality of the different icons provided on the Report Manager menu ribbon. You can find this tip here. Now, we’re going to do the same for the Connector module. Take note that icons will activate / deactivate based on your selection in the object window. These icons are […]
In a previous tip, we explained how you can easily remove duplicate rows from your data using the Remove Duplicates function. You can find it here. At times though, you may just want to highlight duplicate rows without actually deleting them. In this tip, we show you how you can do this using an Excel […]
When you use the Sage Intelligence Report Manager module, you will see an array of icons on the menu ribbon. Here is a quick tip on their functionality. Take note that icons will activate / deactivate based on your selection in the object window. These icons are available on software using Sage Intelligence Core 7.3 […]
In our example workbook, we’re working with Date, Value In and Value Out fields. We need to create a Pivot Table that will also display the variance per month, as well as a running total of the variance for the year. In this tip, we show you how to do this. First up; select your […]
Being able to check if the components of a report are functioning as expected while working with them can help provide a smooth workflow and save time dealing with problems later in the report creation process. Also, if you do come across errors in a report, being able to test its components easily allows for […]
This tip may seem basic, but with Microsoft continually adding value to its products—we just had to mention it. It’s lead by a repository of every icon imaginable (and maybe even a few that are unimaginable) that you may find useful, especially if you’re someone who likes your Excel workbooks to look a little more […]
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 […]
The 3 skills and knowledge domains a Business Analyst requires to effectively add value is well versed and well documented; they need a degree of Technical Knowledge, Business Knowledge and Interpersonal Skills. Although most industry reports and literature focus on the two former items in the list, the latter is certainly not emphasized enough, and […]
In a previous tip, we showed you how you can navigate around a data list quickly using keyboard shortcuts. To view the tip, take a look here. By combining the same shortcuts with the Shift key, you can easily make selections in your data for editing purposes. Assume that you have a data list with […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.