During this video, you'll 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.
During this presentation, we explain and demonstrate how to design queries to satisfy challenging file join requirements, take advantage of NGS-IQ's many email options, and use parenthetic record selection statements to simplify run-time prompts. 70 Minutes.
This presentation features demonstrations by two NGS-IQ users in two very different industries showing the very different ways they have deployed 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.
This presentation demonstrates building 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 that NGS-IQ customers have described during recent technical support calls and site visits. 70 minutes.
Watch this presentation to learn about the many date functions you can use to convert dates into the formats you need for accurate calculations, sorts, and selections. We also share a tip to help you document the logic and functions used in your new fields and record selections and wrap up with a quick look at the Query Inventory features of IQ SeQure. 75 minutes.
Please watch this presentation and learn how to use the absolute value function, how to create and use email address lists to manage output distribution, when to use "Print Hide" or "Print Never" when formatting a field, and see a demonstration 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 show you 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 in the process of building a "slow moving inventory" report, an "items ordered together" report, an "items ordered individually" report, and a "how many items were ordered" report. Our segment on Microsoft Power BI provides an overview of this software's capabilities and explains how you can use NGS-IQ output to create graphical, Web-based dashboards. 85 minutes.
This video has great ideas for everyone. Learn a very creative way you can control the use of production queries while they are being revised, design a Web report that automatically refreshes periodically, and discover more of IQ Client's Web report formatting features. Then, find out how to 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 several interesting topics customers have recently requested. First, we show a query where we use a conditional new field to remove trailing zeros from a character field. Next you'll see how to use a series of conditional new fields to apply more than 32 conditions to calculate a single column in your report output. The second half of the presentation explains and contrasts the two different types of HTML reports you can create with NGS-IQ. You'll learn how to create and apply cascading style sheets to assign fonts, colors, type sizes, and other characteristics to your HTML output. (Requires Adobe Flash with Java enabled.)
If you think queries can only tell you what's already happened, please watch this presentation and get acquainted with some NGS-IQ functions you can use to analyze history and forecast future events. This presentation uses 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. The logic and functions presented can be applied to many business requirements regardless of your industry. 56 minutes. (Requires Adobe Flash with Java enabled.)
Watch this presentation featuring a community college administrator and a systems analyst in a global manufacturing enterprise talking about 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 demonstration 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.)
This presentation shows you how to include images and external data in your NGS-IQ Web reports without programming. We also step through the Web Links "drill down" function of NGS-IQ and then demonstrate 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 different types of training we offer and the dates for upcoming classes. Solutions covered in this Webinar:
Using 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.
Designing 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.
Publishing an Excel workbook as a Web page.
Using Microsoft SkyDrive and the Excel Web App to access and revise Excel workbooks from a Web browser on a Apple, Android or Windows device.
Creating 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.)
Learn how to simplify run-time variable entry for business users, automate query execution so that running one query will result in the delivery of different data segments and multiple output types (Excel, PDF, CSV, DB2, etc.) to different users and destinations, and design a Web report in IQ Client so that it includes 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 mis-steps. 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 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. (Requires Adobe Flash with Java enabled.)
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. (Requires Adobe Flash with Java enabled.)
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. (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. 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. (Requires Adobe Flash with Java enabled.)
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. (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, 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. (Requires Adobe Flash with Java enabled.)
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. (Requires Adobe Flash with Java enabled.)
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. (Requires Adobe Flash with Java enabled.)
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. (Requires Adobe Flash with Java enabled.)
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. (Requires Adobe Flash with Java enabled.)
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. (Requires Adobe Flash with Java enabled.)
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. (Requires Techsmith Screen Capture Codec.)
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