During this presentation, you'll see how to develop and run queries to populate detail and summary data to different sheets of a Microsoft Excel workbook. You'll also learn how to use the new extended record selection feature and how to take advantage of the different ways NGS-IQ can generate Adobe PDF files. 50 minutes.

During this presentation, we contrast the different ways you can output queries to Microsoft Excel to help you decide which method is best for any business requirement. We also explain the new CSV delimiter and escape character settings, commands to help you manage email distribution lists, and keywords you can use to integrate NGS-IQ web reporting into applications. 55 minutes.

During this presentation, you'll learn how to:

• use and link Qport Access .IQP files to automate output to Excel sheets
• use IQ environment variables to pass run-time variable entries to queries that you run as a series
• design a web report to draw attention to important values
• customize the web reporting user interface
• use email distribution lists

Approx. 55 minutes.

We welcome NGS-IQ users to watch this preview of the forthcoming major new release of NGS-IQ. You'll learn about and see some of the enhancements we have planned. Note: Release availability and new features are subject to change at any time. 55 minutes.

Watch this presentation and learn how to use NGS-IQ to develop "dashboards" for different types of users. We explain the factors you should consider when deciding whether your user's needs can be best met by a dashboard designed in Microsoft Excel, Qport SmartView, NGS WebRunner, or Microsoft Power BI. 45 minutes.

Learn when to use a new field or record selection to add run-time prompts to queries; how to work with inconsistent data values to support accurate file joins, sorts, and summaries; and how NGS-IQ supports Microsoft Power BI's advanced analytics features. 60 minutes.

During this presentation, we'll cover these topics:

• Queries that text (when certain conditions exist)
• Discovering query links (using the Query Reference File command)
• Creative uses for web reports (accessing data from external sites to produce bar codes, etc.)

Along the way, you'll see how to use often overlooked features like Group By, Having, and Unique Key. We also quickly recap some recent IBM announcements. 60 minutes.

WebRunner is built into NGS-IQ, but maybe you haven't had time to get familiar with IQ Client's HTML formatting features.

During this presentation, you'll see five new queries with HTML formatting that we'd like to help you install and run on your own system. We'll also demonstrate using Qport Access with Microsoft OneDrive and WebRunner to link Microsoft SharePoint users to their favorite queries. 55 minutes.

Watch and learn how to use Qport Access' Transfer to Host feature, include the last run date and time in your Excel output, design Web reports that enable users to add and share their comments, and select records when field values include apostrophes. Approximately 60 minutes.

Learn how to use a temporary output file to pass parameters to a series of queries; format date fields for prompting, sorting, and presentation; and run Qport Access from the host using the STRPCCMD command. We also quickly review the enhancements included in the latest releases of Qport Access and SmartView, plus what's coming soon in IQ Client. 60 minutes.

For the best viewing experience, select 1080p in the quality section of the player settings. Watch this video for an overview of the enhancements you'll find in the new releases of Qport Access and Qport SmartView followed by a demonstration of these new features in action. 50 minutes.

Learn how to use SQL Views or NGS-IQ meta files to help staff members develop queries more easily, how to format dates so they will sort and present correctly in SmartView, and about some recent email enhancements that are ready for customers to download and install. Approximately 1 hour.

Design queries to satisfy challenging file join requirements, learn about NGS-IQ's many email options, and use parenthetic record selection statements to simplify run-time prompts. 70 Minutes.

During this presentation, you'll learn how to:

• automate report delivery via email based on the profile of who runs a query
• use the ignore case on sort or %XLATE function to overcome upper and lower case character inconsistencies
• customize the IQDATE file to include important dates on your company's business calendar
• use the IQ Connexion module of NGS-IQ to import and query remote data stored in non-IBM databases
• be an informed consumer of enterprise cloud computing resources.

83 minutes.

See demos by two NGS-IQ users in very different industries. They show the different ways they deploy NGS-IQ to satisfy operational analytics and reporting demand.

We also explain the NGS-IQ tutoring, training, and workshop classes we hope you'll take advantage of in the coming months. 60 minutes.

Build several valuable reports using date arithmetic, conditional calculations, transfer to host, query to run next, report breaks, and other functions. See examples based on real-world questions from NGS-IQ customers during recent technical support calls and site visits. 70 minutes.

Learn about the many date functions for converting dates into the formats you need for accurate calculations, sorts, and selections. We also share a tip for documenting the logic and functions used in your new fields and record selections. We wrap up with a quick look at the Query Inventory features of IQ SeQure. 75 minutes.