|
AccountMate 6.0 for SQL and MSDE - Business Intelligence
Now
that you have improved operational efficiency by implementing Visual
AccountMate, it is time to harness and exploit all the analytical
benefits made possible by Visual AccountMate databases. You can do this
with ease and flexibility by using Visual AccountMate Business
Intelligence.
VAM
BI is a powerful query and reporting tool. It enables you to analyze ALL
of your business data from any angle you wish, including non-AccountMate
application data. Benefits include faster reporting cycles, higher
quality information, sophisticated data analysis capabilities, better
data on customer buying behavior, and improved end-user productivity.
Since VAM BI is integrated
with Visual AccountMate databases, you can enjoy benefits
immediately after installation. It comes with many predefined
queries such as Best Selling Products, Largest Customers and
Vendors, Top Salespeople, Product Class and Product Line Analysis,
and much more. You can quickly create new queries and reports to
satisfy your most demanding information needs, including pulling in
data from other sources.
Visual
AccountMate Business Intelligence- Dynamic Online Analysis
Descriptive
Names and Relationships
Provides
long, descriptive names to tables and fields, allowing users to quickly
find information. The relationships among the database tables have been
established, making it easy to create complex reports and online
queries.
Seamless
Integration of Data
VAM
BI is fully integrated with most Visual AccountMate LAN modules. Integrating with other
VAM modules and outside data is quick and simple.
Sophisticated
Security Features
A
User Profile management system provides security features to protect
users from unauthorized access to sensitive data and software functions.
Straight
Reporting
The
Report Wizard guides the user step-by-step through the creation of new
reports, making available fields from related Visual AccountMate tables.
Users can also add calculated fields to summarize complex information.
Multi-dimensional
Queries
Multi-dimensional
queries allow users to dynamically analyze business facts from different
perspectives simultaneously, such as Sales by Product Line, Customer,
Year and Salesperson. VAM BI's unique multi-dimensional architecture
allows ad hoc addition of dimensions by the end-user.
Descriptive
Field Names and Formulas make reporting easier Powerful
Formula Engine
The
Formula Engine allows users to create new calculated fields, using data
from any VAM table. Formulas can have long expressions, logical
functions and rankings.
Scheduled
Data and Formula Refresh
VAM
BI extracts VAM data into a data warehouse, so as to maximize reporting
performance and overall system stability.
The data extraction and formula calculation processes can be
scheduled to automatically execute in off-peak periods, so the data
warehouse remains current without user intervention.
Dynamic
Online Analysis
Users
can view any set of data tables using the Relationship object.
While viewing Customer data, users can drill down to Invoices and
Invoice Details, and dynamically set filters, summaries and graphs.
Quick Data Locate
& Export to Excel
It
is quick and easy to find any data set in the VAM database and export it
to Excel and other formats. The export function uses the descriptive
field names.
Prepackaged
Reports offer immediate benefits
Power
Drill-down
It
is possible to access any level of data detail, from high-level business
summaries to single cells, providing full drill-down capabilities for
all VAM modules.
Other
Features
-
Users
can send query results via email.
-
Filters
can be color-coded so Customers with declining sales will appear in
red, while the top ten best-selling products appear in blue.
-
Other
systems and third-party applications can be integrated so all
company data is viewed as a single database.
-
All
information objects can be reused. That means the users define a
filter or formula only once, and then use them in all queries and
reports. This feature, in conjunction with the pre-mapped
relationships, make complex reporting quick and easy.
-
The
Graph Engine is integrated to Microsoft Graph, likely familiar to
Excel users.
|
