Long-time IBM i programmer and systems analyst Russell Berkeley of ICS Courier has used NGS-IQ for many years. He developed this demonstration to share some programs he has written to automate and simplify a few of his common tasks. Some of his examples use NGS-IQ, and some work in any IBM i environment. We encourage you to watch Russ’ presentation and see if his methods can help make you more productive. 26 minutes.

Watch this fast-paced, 30-minute video if you're an IT professional who doesn't use Excel but does need to prepare and deliver data to Excel users in your office. You'll learn what file formats and delivery methods will help those users and save you time. We also step through Excel's file import features and how to automate refreshes of the visualization objects used to analyze that data.

Microsoft Excel is where your users expect you to deliver the data they need to analyze. But as an IT professional, you might not use Excel. Knowing how others do - and understanding some of the ways Excel can import and present data - can reduce the time you spend transferring files and answering questions.

This video is the first of a two-part presentation (30 minutes each) to gain a better understanding of Excel from an IT professional's perspective.

In this video, we explain NGS' Query/400 Application Program Interface (API) and the IBM SPOOLED_FILE_DATA command - two simple methods you can use to leverage legacy queries and spool files.

NGS provides advanced IBM i query, reporting and analytics software - but right now your company may expect you to get more out of your existing legacy reporting tools from IBM. IBM Query Management (QM) is a great example. It hasn’t changed, but it has helpful features that are often overlooked. We asked respected IBM i developer and IBM® Db2® on i expert, Vern Hamberg, to explain what IBM QM can do. A quick overview of NGS-IQ is included after Vern's presentation. 60 minutes.

NGS's participation in the IBM i Solution Edition program can help you save 30% and more on IBM i software when you move up to an IBM POWER9 server model. It's surprisingly easy to take advantage of this offer. Please watch this video for an overview of IBM's Solution Edition hardware and software offering. 18 minutes.

Where is your IBM POWER server on the IBM POWER hardware lifecycle? What is the support timeline for your current IBM i release and future releases? NGS asked Mike Budzich, Managing Partner/CEO of GEMKO Information Group, LLC, to provide some guidance. 15 minutes.

Is IBM committed to IBM i? Is IBM i the right foundation for your current and future computing requirements? NGS welcomes Mike Budzich, Managing Partner/CEO of GEMKO Information Group, LLC, to explain the unique strengths and investment protection features of the IBM i environment. 23 minutes.

For the best viewing experience, select 1080p in the quality section of the player settings. NGS welcomes IBM i expert Simon Hutchinson of RPGPGM.COM to share his thoughts on the most useful features of SQL for IT professionals, including SQL Views, extracting data from spool files, searching history logs, and much more.

Following Simon's presentation, there will be a quick overview and demonstration of how the NGS-IQ query, reporting, and analytics solution leverages the power of IBM i to enable non-IT staff members to securely access, visualize, analyze, export, and share data without programming. This presentation is also available to anyone registered to attend the COMMON iNSIGHT virtual conference during May and June 2020. Length: 55 minutes.

NGS-IQ is a versatile and proven upgrade path from IBM Query/400 and a cost-effective alternative to IBM DB2 Web Query. TLA Forms from TL Ashford transforms data in your spool files into beautiful custom PDF forms and automates their distribution.

This joint presentation from NGS and TL Ashford demonstrates how these two solutions complement each other to help IBM i users economically generate custom business forms, reports, OLAP models, and more. 60 minutes.

This video features respected IBM i programming expert, Simon Hutchinson of www.rpgpgm.com, who explains SQL Views and how you can use them to support database access. A short demonstration of NGS-IQ concludes the presentation. Approx. 60 minutes.