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.
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.
Learn how to use the absolute value function, how to create and use email address lists to manage output distribution, and when to use "Print Hide" or "Print Never" when formatting a field. See a demo of an NGS-IQ Web report interacting with IBM's Watson Language Translation service.
We also explain what's covered in our Excel Reporting Features and IQ Client Tutoring sessions and how to use our new on-demand video topic search service. 60 minutes.
This presentation focuses on query and report development and wraps up with an overview of how you might use NGS-IQ with Microsoft Power BI to support data visualization requirements.
We demonstrate group by, having, date arithmetic, date formatting, query to run next, HTML report formatting, charting, drill down, and table (file) self joins to build these types of reports: "slow moving inventory," "items ordered together," "items ordered individually," and "how many items were ordered."
Our segment on Microsoft Power BI provides an overview of this software's capabilities and how to use NGS-IQ output to create graphical, Web-based dashboards. 85 minutes.
Creatively control the use of production queries while they're being revised, design a Web report that automatically refreshes periodically, and discover more of IQ Client's Web report formatting features.
Secure IQ Server's default file joins from being updated, use the "List Query Statistics" and "Change Query Library" commands, and use an exit program to set the value of a conditional new field.
We wrap up with an overview of NGS-IQ's SmartView OLAP module for business analysts. (Requires Adobe Flash with Java enabled.)
In this presentation we focus on interesting topics customers have recently requested:
Use a conditional new field to remove trailing zeros from a character field.
Use a series of conditional new fields to apply more than 32 conditions to calculate a single column in your report output.
Learn about the two different types of HTML reports you can create with NGS-IQ. Create and apply cascading style sheets to assign fonts, colors, type sizes, and other characteristics to your HTML output.
If you think queries can only tell you what's already happened, get acquainted with some NGS-IQ functions to analyze history and forecast future events.
Use sales reporting examples to illustrate powerful query development features, including the PREVIOUS, DAYS, NDAYS, #DAYS, and *TODAY functions; the IQDATE table; SQL Group By and Having; Query to Run Next; IQ Client HTML; and web reports with charts and chart links. You can apply the logic and functions to many business requirements regardless of your industry. 56 minutes. (Requires Adobe Flash with Java enabled.)
This presentation features a community college administrator and a systems analyst in a global manufacturing enterprise discussing how they use NGS-IQ to satisfy a variety of departments and users in their organizations.
After the two customer interviews, watch the step-by-step demo of IQ Server and IQ Client's SQL features, followed by tips for enhancing Web reports with color, larger fonts, and comment boxes. 70 minutes. (Requires Adobe Flash with Java enabled.)
Include images and external data in your NGS-IQ Web reports without programming. Step through the Web Links "drill down" function of NGS-IQ, and see a demo of the NGS Query/400 Application Program Interface (API) for companies still supporting IBM Query/400 users. 70 minutes. (Requires Adobe Flash with Java enabled.)
Hear an NGS-IQ customer talk about the onsite NGS-IQ workshop he recently completed. Then, get an overview of the types of training we offer and the dates for upcoming classes. Solutions covered in this Webinar:
Use the Group By function to create a report that compares a field's value to its expected range of values and lists the records that fall outside the expected range.
Design a query that outputs data to SmartView so that your result includes the name of the user who ran the query, the time stamp of when the query was run, the run-time selection parameters the user entered, and the number of records being summed at each level of the model.
Publish an Excel workbook as a Web page.
Use Microsoft SkyDrive and the Excel Web App to access and revise Excel workbooks from a Web browser on a Apple, Android or Windows device.
Create impressive data visualizations and maps with drill down features by using Microsoft Power Pivot, Power View, and Power Map.
Approximately 80 minutes.
NOTE: This is an edited recording of the original live Webinar presentation. We reproduced the presentation to correct some minor technical missteps. We hope you'll view this, even if you watched the live presentation. (Requires Adobe Flash with Java enabled.)
Simplify run-time variable entry for business users
Automate query execution so that running one query will deliver different data segments and multiple output types (Excel, PDF, CSV, DB2, etc.) to different users and destinations
Design a Web report in IQ Client to include a drill-down hyperlink that passes multiple run-time parameters to a linked query.
This presentation also includes an introduction to the new NGS Dashboard solution. Approximately 75 minutes
NOTE: This is a new recording of the material covered during the original Webinar. We reproduced the presentation to improve sound and video quality, incorporate answers to some points raised during the live Q&A session, and correct some minor technical missteps. We hope you'll view this, even if you watched the live presentation. (Requires Adobe Flash with Java enabled.)
Hear from an NGS-IQ customer who uses NGS-IQ query output to update Microsoft Excel pivot tables, dramatically enhancing visibility into their business performance. Create an Excel 2010 Pivot Table with charts, slicers, and other features. Refresh data in one step, using Qport Access.
We also contrast Excel Pivot Tables with NGS's SmartView OLAP module to demonstrate 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 their IBM i data to watch this presentation. One hour. (Requires Adobe Flash with Java enabled.)
Many times it's the less visible, overlooked, fundamental features of the NGS-IQ query development environment that make difficult jobs easy.
We present the valuable nuts and bolts topics that 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 understand why and how to add Web Links to your queries. Approximately 90 minutes. (Requires Adobe Flash with Java enabled.)
Today's workforce wants to receive and interact with their data on smartphones and tablets as well as on their laptops. They also expect to receive timely email alerts about critical business conditions and to access information anywhere, anytime.
This video shows how the WebRunner function of IQ Server gives these mobile users on demand access to graphical Web reports from Android, Apple, and other devices. Use the Windows 7 Task Scheduler to run queries with Qport Access and WebRunner. See a demo of the email distribution list function included in release 7.1 of NGS-IQ. Approximately 75 minutes. (Requires Adobe Flash with Java enabled.)
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, we give an overview of the enhancements for NGS-IQ Release 7.1.
If you watched this presentation live, we re-recorded the demo 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. (Requires Adobe Flash with Java enabled.)
See an overview of the benefits of the NGS-IQ SeQure security management system. An NGS-IQ Support Specialist leads a demo on using IQ SeQure to control database and query security. Approximately 35 minutes. Part 2 of 2.
NGS-IQ offers a variety of powerful functions so 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:
join files on a new field created in your query
join files using record selection
design a query so that the destination of its output on the Integrated File System (IFS) is a variable you control at run time
include your query's name and library in your output to Excel when using Qport Access
learn about the new Web charting and drill down functions planned for the next release of NGS-IQ
Approximately one hour. (Requires Adobe Flash with Java enabled.)
Use NGS-IQ to send email alerts that notify users of important business conditions, create temporary work files in IQ Client without uploading and running the query that creates them, convert character values into numeric values and vice versa, 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. (Requires Adobe Flash with Java enabled.)
3835 N. Freeway Blvd, Suite 200 Sacramento, CA USA 95834
Office: (916) 920.2200 Sales: (800) 824.1220 Support: (800) 257.2442 Fax: (916) 920.1380