Managers, executives, and other end users rely on SEQUEL to deliver business metrics needed to effectively monitor business activities. SEQUEL offers a number of different dashboard options:

• ViewPoint Executive Dashboards, part of SEQUEL ViewPoint, allow even non-technical users to create their own dashboards displaying key performance indicators.

• Client Tables, another part of SEQUEL ViewPoint, gives you online analytical processing (OLAP) capabilities including drill-down, reporting, and data analysis features.

With SEQUEL ViewPoint, you can create useful Executive Dashboards, like the one shown below, that display a combination of SEQUEL objects, Windows applications, and Web browser windows.

(click image for larger view)

Executive Dashboards give non-technical management personnel and other end users access a wide array of important business metrics by clicking a desktop icon. A SEQUEL Executive Dashboard may contain any of the following objects:

• SEQUEL View and Table results (with drill-down capability)
• SEQUEL Graphs (with drill-down capability)
• Action Buttons (to initiate other applications)
• Web browser windows
• Windows applications
• Company logo and/or other graphic files
• Text (with customizable fonts, colors, size, and style)
• Background images or colors

SEQUEL may be used with Google^® Maps, subject to and in accordance with Google Maps terms of service, to support interactive map plotting based on address, zip code, or GPS coordinates stored in System i database files. SEQUEL can select virtually any location-dependent information (such as customer, branch sites or trucking information) and display a Google Map with color-coordinated "push pins" denoting appropriate locations. Executive dashboards can include run-time prompts or action buttons to display maps containing information extracted from a System i database.

(click image for larger view)

With the SEQUEL Client Table feature, you get an interactive OLAP solution designed to help you perform dynamic data mining and analysis easily. You can drill down from summary levels to the detail level, create reports, and perform data analysis on your System i database files. Using drag and drop, you can easily reorganize table dimensions and quickly see new results. In addition, you have access to various data filtering, drill-down, data marking, dimensional pivoting, ranking, and graphing functions.

Summary of Client Table Features

• Easy-to-use design interface
• No multi-dimensional database server needed
• Fast calculation, summarization, and presentation of multi-dimensional relational data
• Quantity of data points is limited only by the operating environment's available resources
• Interactive drill-down into detail level
• Dynamic data filtering, pivoting, and ranking
• User-defined calculated fields and number formatting
• Analyze any number of dimensions and facts
• Multiple aggregation functions such as: Sum, Average, Standard Deviation, Variance and more
• Print preview / zoom functions
• Show / Hide detail levels in summary views
• Automatic size-to-fit for rows and columns
• Data highlighting based upon user criteria
• Filter row and column elements

Free Email Sign-Up

To get the latest operations automation and business intelligence news, sign up for Robot Direct by entering your e-mail address. We'll let you know about site updates or breaking news about twice a month!