BI Components – User Experience
Our business intelligence solution consists of various components to address self-service business intelligence, data warehousing, business process automation, reporting and collaboration. Some of the major components of the solution most companies will already own, these include Microsoft SQL Server, Microsoft Office and Microsoft SharePoint.
User Experience, financial report authoring and self-service business intelligence
Microsoft’s Business Productivity Solution owned by almost every business – BI functionality can be found in all of the office products with our main focus on products such as Excel and InfoPath.
Microsoft Excel 2010 makes it possible to analyse, manage, and share information in more ways than ever before, helping you make better, smarter decisions. New analysis and visualization tools help you track and highlight important data trends. Easily access your important data on the go from almost any Web browser or smartphone. You can even upload your files to the Web and work simultaneously with others online. Whether you’re producing financial reports or managing personal expenses, Excel 2010 gives you more efficiency and flexibility to accomplish your goals.
PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. It’s the user-friendly way to perform data analysis using familiar Excel features you already know, such as the Office Fluent user interface, PivotTable and, PivotChart views, and slicers. It’s the fast way to generate rich and interactive analysis tools, easily mistaken for IT solutions after weeks of effort. It’s the right way to achieve deeper business insight and shorter decision cycles.
PowerPivot Security Architecture
Sage Insight Author and Viewer are Excel add-ins which facilitate the creation of reporting templates/packs and the dynamic refreshing thereof
- The ability to use any Excel features such as pivot tables,
- Refresh reports using different criteria.
- Drill-down to detail transactions.
An Insight data warehouse is created and updated via the Insight job scheduler using standard and/or pre-defined filters. The Sage Insight data warehouse is the key in translating financial and related data within the financial system to more user friendly information which makes standard reporting easier and self-service reporting viable. It also promotes the use of OLAP cubes and could be scheduled to update at specified times to ensure that you don’t have server processing overhead at critical times. The Insight data warehouse is designed to facilitate fast and efficient reporting. The database caters for all “filter” requirements and is period-driven. Current Period, Quarterly, Year to Date and Ending balances are pre-calculated to ensure speedy reporting.
Sage Insight Consolidations – is a fully fledged Consolidations tool incorporating the following:
- Multi-tiered consolidations from many Accpac/X3 or any other
databases or a combination thereof.
- Automatic Multi-currency conversions, using any conversion rates
e.g. Net period, ending balance or historical rates.
- Automated intercompany eliminations with reconciliation.
- Intercompany transactions.
- Consolidated reporting on any level of the consolidations
hierarchy using parent or child currencies.
Sage Insight budgeting is an advanced budgeting tool which includes:
- Budgeting workbook setup within the familiar environment of Excel.
- Creation of spread methods to facilitate the budgeting process.
- Up to 99 budgeting or forecasting versions.
- Budget tracking
Sage Accpac Intelligence allows you to pull information from Accpac into Excel, change it the way you like, and save all your format modification. Most reporting design functionality utilises Excel. Data connections, report parameters and security is well managed by SAI.