Sage Pastel Business Intelligence Center 

Powered by Alchemex

Delivering Business Intelligence through Excel

Business Intelligence through Excel – anytime, anywhereBy going Beyond Accounting, Sage Pastel is able to offer you an innovative and flexible Excel-based financial reporting tool designed for small, medium and large enterprises (SME’s). The Sage Pastel Business Intelligence Centre dynamically links to Microsoft Excel where your information can be viewed and manipulated to give you greater insight into your business – and as long as the information is stored in an accessible database, you can access sales, financials, inventory and purchasing reporting.

Some of the standard reports include:

• Management Pack (in a variety of layouts)
  •        Income Statement
  •        Balance Sheet
• Sales Master
  •        Sales Report - manipulate your sales data to see different views
• Inventory
• Purchasing

The Sage Pastel Business Intelligence Centre modules available:

BIC Standard

The Standard Module provides you with a pre-formatted, intelligent Excel reporting tool for your Sage Pastel data. You can use the base of reports to create new reports or even write your own reports in Excel.

The Advanced Module provides a skilled IT user with a powerful and cost-effective report writing solution, capable of delivering Excel reports from any ODBC compliant data source.

BIC Excel Genie

The user friendly BIC Excel Genie gives you the power to transform data using an intuitive drag and drop interface to construct reports.

• It is an extension of the Business Intelligence Centre
• You can generate financial statements from predefined lists
• Edit existing and/or create new financial layouts using drag and drop functionality
• Caters for consolidations, segmented General Ledgers and column reporting using drag and drop functionality
• Refresh newly added accounts into your existing layouts at the click of a button
• Supports the use of native Excel

Click Here to see BIC Genie in Action

OLAP Cubes

OLAP Cubes is an extension to the Business Intelligence Centre. The new OLAP module (Online Analytical Processing) caters for multi-dimensional analysis of your data. It answers the questions ‘what if’ and ‘why’. It analyses trends over months and years from a set of predefined cubes for Financials, Sales and Inventory. You can modify and build your own cubes based on your business requirements, rank customers and suppliers in order of importance and drill-down to the level of detail you need. OLAP is predominantly powerful in analysing large volumes of data where traditional End User Query Reporting may not be appropriate.

This module is an extension of the existing Business Intelligence Centre module. It provides worldwide secure access to your business reports through a standard web browser. This is an excellent platform to share information with partners, suppliers and customers. All you need is Internet access from your web browser and then authenticate yourself and the reports will be made available to you.You will have access to critical information about your business from anywhere in the world at any time you choose. Online Web Reporting supports secure access so you receive your reports in a variety of formats across the web for example Microsoft® Excel, PDF or HTML.

Click Here to See BIC Web Reporting