NGS-IQ Demonstration Playbacks

Share and Learn Playbacks

See Our Short Tutorials - Less Than 10 Minutes!

Hear from an NGS-IQ customer whose company uses NGS-IQ query output to update Microsoft Excel pivot tables that dramatically enhance visibility into their business performance. You'll see how to create an Excel 2010 Pivot Table with charts, slicers, and other features. Then, you'll see how you can use Qport Access to refresh the data in one step. We also contrast Excel Pivot Tables with NGS's SmartView OLAP module to help you understand when SmartView may be a better match with the skills of some business users. We encourage Excel users who depend on reports and files pulled from your IBM i data to watch this presentation. One hour.

Enjoy our second back-to-basics session describing valuable and often overlooked features of NGS-IQ, including a refresher on edit codes, the SENDEMAIL command, the CHGQRYLIB command, the LSTQRYREF command, and Query Definition Templates. We've also included a quick look at how you can use NGS-IQ output in Google Fusion Tables to generate maps and charts that can be viewed by virtually any user on any type of Web-enabled device. Lastly, please watch our introduction to the NGS-IQ Cloud, a software service for customers who want to take advantage of NGS-IQ running over a selected subset of their data stored on IBM i in a secure data center.

See how an NGS customer in the transportation and logistics industry is using NGS Business Performance Dashboards and Web reporting to drive efficiency and improve customer service. Next, learn how a cascading style sheet can transform any query into an eye-catching Web report in seconds. Then get some advice on how to simplify the process of integrating secure, run-time access to your NGS-IQ queries into Web pages, portals, and applications. Last of all, see how the new Query Inventory features in the latest release of the IQ SeQure module can save query developer's time. Approximately 70 minutes.

Many times it's the less visible, overlooked, fundamental features of the NGS-IQ query development environment that make difficult jobs easy. This presentation focuses on valuable nuts and bolts topics that can help you find and work around bad or inconsistently entered data, use advanced features of IQ Client, increase the value of the powerful IQDATE file by customizing it to resemble your company's business calendar, and gain a better understanding of why and how to add Web Links to your queries. Approximately 90 minutes.

Today's workforce wants to be able to receive their data and interact with it on smartphones and tablet computers as well as on their laptops. They also expect to receive timely email alerts about critical business conditions and to be able to access information anywhere, anytime. This demonstration shows how you can use the WebRunner function of IQ Server to give these mobile users on demand access to graphical Web reports from Android, Apple, and other devices. The presentation also includes a segment on using the Windows 7 Task Scheduler to run queries with Qport Access and WebRunner. Lastly, there is a demonstration of the new email distribution list function included in release 7.1 of NGS-IQ. Approximately 75 minutes.

A Logistics and Planning executive presents how his company uses NGS' SmartView and IQ Client to simplify access to sales, inventory control, order fulfillment, and other critical information. Plus, an overview of the enhancements NGS has planned for Release 7.1 of NGS-IQ. If you watched this presentation live, we re-recorded the demonstration of the new IQ SeQure Query Inventory feature to better present its capabilities, so please log in and watch that segment again. Approximately one hour.

Discover how easily you can create meta files to simplify working with your data, see how using cascading style sheets can save time and help create better looking Web reports, get a preview of the new Query Inventory feature that will be included in the next release of IQ SeQure, and hear how IBM is enabling NGS customers to save 30% and more on a new POWER7 IBM server. Approximately one hour.

An overview of the benefits of the NGS-IQ SeQure security management system with a demonstration, lead by an NGS-IQ Support Specialist, of how you can use IQ SeQure to control database and query security. Approximately 35 minutes. Part 2 of 2.

NGS-IQ offers a variety of powerful functions so that you can work with just about any data to get the information you need and store it for future reference. In this session, you learn how to do the following: 1) join files on a new field created in your query, 2) join files using record selection, 3) design a query so that the destination of its output on the Integrated File System (IFS) is a variable you control at run time, 4) include your query's name and library in your output to Excel when using Qport Access, 5) and learn about the new Web charting and drill down functions planned for the next release of NGS-IQ. Approximately one hour.

Learn how to use NGS-IQ to send email alerts that notify users of important business conditions, create the structure of temporary work files in IQ Client without having to upload and run the query that creates them, convert character values into numeric values and numeric values into character values in your database, and understand the differences between summary results produced with the Group By and report break functions. These four topics are presented in separate segments, so you can skip directly to the ones you want. Approximately one hour.

The report tables function is powerful, but frequently overlooked by query developers. In the first half of this presentation, you will learn how report tables work and see how to design a query with three report tables that calculate sums, averages, running totals, rankings, and more. Do you think NGS-IQ is just for writing queries? Think again. The second half of this presentation shows how you can use NGS-IQ to create a live Web form that supports data entry, input validation, and an e-mail confirmation message delivered with an Adobe PDF as an attachment. Approximately one hour.

Watch this overview of the new features that were delivered in the most recent release of the Concert Series G/L, A/P, A/R, Payroll, and Human Resources software. Approximately one hour.

Get an overview of the latest NGS-IQ enhancements that are now available in an update to Release 7.0. You'll see how to use the new WebRunner feature of IQ Server to run queries from your Web browser and output your results directly to Microsoft Excel and Adobe Acrobat; work with the new WebRunner keywords to embed NGS-IQ query processing into Web pages and portals; customize the e-mail distribution list, subject, and message sent with your query output each time you run a query - without having to revise the query definition; add calculated fields to your SmartView models; and export SmartView data to HTML and Excel. Approximately one hour and five minutes.

See the power of NGS-IQ Release 7.00 in this educational session that explores the new HTML report design features of IQ Client; the new IQ Server WebRunner feature that lets you run NGS-IQ queries from your own Web pages, portals, applications, and smartphones; how to use the NGS Business Performance Dashboard module to create a custom Web user interface to Web reports; and how to design queries with built-in "Web Links" that enable a user to drill down from summary to detail on demand as they view query output with their Web browser or smartphone. This presentation revisits the valuable and often overlooked Transfer to Host function of Qport Access to create DB2 files from data stored in Microsoft Access and Excel. Transfer to Host has been a standard Qport Access feature for many years. Approximately one hour.

Learn how to use NGS-IQ's IQDATE and IQTIME files along with the remainder function to design a query that calculates elapsed time in days, hours, minutes, and seconds between two events. In addition, see how to use the previous function of NGS-IQ to create a conditional new field that calculates the running balance of a numeric field. Third, get an overview of the new ShipView Plus transportation analytics solution developed jointly by NGS and Varsity Logistics using the NGS-IQ suite of software. Finally, enjoy a preview of the upcoming release 7.0 IQ Server Web interface and IQ Client Windows desktop query development module. Approximately one hour.

Learn how to use NGS-IQ's previous, skip, and count functions to overcome the challenges of "one-record-to-many-record" joins and to create "top n reports"; see how the Query/400 API enables users to enhance and run Query/400 queries from NGS-IQ; get a quick overview of the NGS Business Performance Dashboard development process; and see how the upcoming release 7.0 of NGS-IQ will enable you to combine dashboard components and the new IQ Server Web Interface to create easy-to-use, custom Web pages for end users. Approximately one hour.

For a limited time, NGS has waived the license fee for a two-concurrent user license of Qport Office to qualified IBM i customers who complete an NGS Software License Agreement. Read more.

Get a first look at IQ Connexion, the newest module of NGS-IQ. IQ Connexion enables NGS-IQ users to develop reports and presentations over data stored in SQL Server, MySQL, Oracle, PostgreSQL, and DB2 databases on other platforms. Find out how easy it can be to use NGS-IQ as the reporting and business intelligence engine behind all the databases used in your enterprise. Approximately 25 minutes. Part 3 of 3.

Important

Because of their size, these presentations may take a few minutes to fully load, so please allow some time before you attempt to use the table of contents to advance to a later segment.

If you can hear the presentation but not see it, go to http://www.techsmith.com/download/codecs.asp and click on "Download TSCC Codec." It only takes a moment to download and install this code. After the installation, re-launch the recording.

For all other technical issues or questions, please contact NGS at (800) 824.1220.

Thank you.