NGS-IQ business intelligence system provides iSeries customers with a cost-effective solution that offers managers and business analysts the multi-dimensional capabilities required for strategic planning; end-users a flexible and easy-to-learn data access environment; IS professionals power, centralized control and optimal field and record level security; and your company the pathway to increased ROI.

With seamless integration to your business applications, NGS-IQ can be your end-to-end business intelligence solution. Modules satisfy the full range of your users' skills set and environments, operating from 5250 terminals and interfaces for Windows and the Web. The scalability of NGS-IQ accommodates your future business intelligence needs as your requirements grow and change.

In comparison to IBM Query/400 and most query solutions, NGS-IQ produces reports in a single step, using only one query. NGS-IQ supports advanced features: conditionally defined calculations, summary-level new fields derived from report totals, rankings, running totals and more.  NGS-IQ features a Wizard to help users join files correctly and provides integrated report formatting, exits to user programs and the optional assignment of user-defined file and field aliases to simplify database access.

NGS-IQ empowers your users by allowing them to select the records they need at run-time, thereby eliminating the need to revise numerous queries. Your users can then download results to their favorite Windows applications, such as Excel or Lotus 1-2-3 spreadsheets, Access tables, Word documents or NGS-IQ's OLAP module. Internet capabilities permit authorized users to access your entire library of NGS-IQ queries from remote locations.  For non-iSeries data, authorized users can run simple queries defined in Microsoft Access and transfer the resulting data directly into a specified DB2/400 file. Users can also output data as HTML text for viewing through most popular Web browser applications.

Qport SmartView™ dynamically transforms your data for multi-dimensional analysis with dynamic drill-down from summary to detail level, user-defined critical-value highlighting, customized caption headings, slice-and-dice capabilities, pivot tables, and presentation-quality charts and graphs.

For building your data warehouse, NGS-IQ provides unlimited data extraction and consolidation, data cleansing, data transformation, data propagation, date arithmetic, and custom business information directories. The NGS-IQ data warehouse development system runs on the iSeries 400 and can be operated from graphical Windows and Web browser user interfaces.

InfoManager

The InfoManager product suite includes all the needed elements to build an integrated data warehouse/business intelligence solution from your operational data.  The integration is done without programming.  Since InfoManager is an application and not a development tool, your organization does not have to employ programmers to implement the solution.

InfoManager has over 1,100 customers around the globe and is known to give organizations quick return on investment.  InfoManager has a broad spectrum of customers in different vertical industries.  Every solution works using the same base package!  

Analytical User Interface

InfoManager offers multichannel information distribution to all users within the organization as well as for customers, vendors and other external users. InfoManager Adviser is an intuitive graphical user interface that provides up-to-date business information through Windows PCs, Internet and wireless devices, and lets the user analyze the numbers behind the report by drilling down to the underlying detail, all the way to the transaction level. InfoManager Reporter provides sophisticated reporting functionality through Microsoft Excel. InfoManager Distributor helps the user to access the data warehouse through third party analytical desktop tools, such as report writers and spreadsheets.

Data Warehousing

InfoManager provides all necessary components for both three-tier and two-tier data warehouse solutions. InfoManager Collector is a tool for data extraction, cleansing, movement, transformation and load. InfoManager Relational Data Warehouse enables the user to build a detailed, transaction level data store based on scalable relational star schema architecture. InfoManager Server is a robust multidimensional database engine which supports sophisticated multidimensional analysis with subsecond response times. InfoManager Broker is a middle-tier server that offers optimized performance through centralized metadata management and scheduling services.

Solutions Webcasts Page